This is an automatic translation from Japanese.
Sorry if the text is strange.
Information on columns with errors
- column name: Material_Quest (in Japanese)
- Type: Enum
- Base type: Ref
- Referenced table name: Material_Quest (in Japanese)
- Valid if: I want to dynamically display a [Material_QuestID] list that is displayed according to the combination of inputs in the other columns, so I enclose 2^4 patterns in an IFS function
Example:- IFS(
AND(
ISBLANK([クエスト種別]), —> Types of quests
ISBLANK([クエストランク]), —> Quest Ranks
ISBLANK([クエストレベル]), —> Quest Level
ISBLANK([クエスト]) —> Quest Title
),
SELECT(素材_クエスト[素材_クエストID],TRUE,TRUE) —> I want to change the [Material_Quest ID] list depending on whether the above columns contain information or not.
- IFS(
Operation procedure until “unexpected error” is displayed
- Opened Valid if input form to edit Valid if function in material_quest column
- A popup message saying “An unexpected error occurred (id:772803)” appears.
It says "Please report to support with the error information so it can be fixed.
Copy error information states-
Error id: 772803
Stack: TypeError: Cannot read properties of undefined (reading ‘length’)
at t.GetErrorState (https://www.appsheet.com/assets/5374f8c06d544d30528ccdc2901658a7175461666fc9903afe96cf2d6ddeb229.js:1:756903)
at Z.render (https://www.appsheet.com/assets/5374f8c06d544d30528ccdc2901658a7175461666fc9903afe96cf2d6ddeb229.js:1:1810001)
at Ho (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:143826)
at Bo (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:143625)
at ql (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:184412)
at Tu (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170629)
at Ru (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170557)
at _u (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170420)
at bu (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:167407)
at https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:117194 -
Error id changes each time it is opened
-
Perhaps the function is too long to be recognized.
However, when I try to edit it, the above error message appears and the editor does not open, so I cannot edit it.
So I would report it to support, but I don’t know where to report it.
Is this the right place?
Thank you.
PS
I contacted AppSheet Help.
I couldn’t figure it out because the Japanese help page didn’t show the contact asus.
Thank yuo.