Error editing table with different error codes

AppSheet AppSheet Q&A
,
1

Hello Everyone, I hope you’re all doing well.

In one particular table in one particular app I’m facing a strange problem, where it is not possible to edit any row after being created. Action buttons than change column values just do nothing when clicked, while the Edit button shows an error with a different error code each time it is clicked.

This behaviour is consistent across different browsers, different users and among the Editor, Mobile and Desktop views. Things that didn’t help include: regenerating structure, changing the data source, removing columns, etc.

AppSheet support has been investigating with no outcome yet. They made me make a copy of the app for them to investigate freely since I’m having problem in a production one. Interestingly, the copy is having the same problem.

Please tell me if you had a similar issue in the past. I’ll update you as well with any feedback from support. Thanks.

Some screenshots and details about the error:

Capture d’écran 2024-03-12 à 04.36.13.png
Capture d’écran 2024-03-12 à 04.36.13.png956×238 14.6 KB

Capture d’écran 2024-03-12 à 04.36.27.png
Capture d’écran 2024-03-12 à 04.36.27.png922×238 14.5 KB

Capture d’écran 2024-03-12 à 04.36.55.png
Capture d’écran 2024-03-12 à 04.36.55.png922×228 14.7 KB

Capture d’écran 2024-03-12 à 04.37.09.png
Capture d’écran 2024-03-12 à 04.37.09.png920×220 14.6 KB

Error id: 8226

Stack: TypeError: Cannot read properties of null (reading 'basestType')
    at b (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:591102)
    at https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:591038
    at Array.map (<anonymous>)
    at b (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:591014)
    at https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:585353
    at Array.map (<anonymous>)
    at n.value (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:585306)
    at n.value (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:582501)
    at n.value (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:603905)
    at n.value (https://www.appsheet.com/assets/66aa69d7b3241cd0537457156d984eeb70a8f7c16b5f4da6ef6e7f3bf5cf9827.js:1:604354)
2

Looking into it, thanks very much for the stack trace

1 Like
3

I can’t find the engineering ticket for this, it’s possible support hasn’t filed one yet. Please ask them to assign it to me.

With the tools I have and my psychic debugging powers, there is a broken expression somewhere causing this. You have an expression running a set difference operation (the - operator) and it’s blowing up trying to figure out the base type of one of the operands (i.e. it’s a list, but what is it a list of?).

1 Like
4

Hey Jess! would you please give me some psych1c* powers training? I’d happily pay for it :smiley:

I had one column with a “- LIST()” in its formula. It went like this:

[Related Refs A][EnumList of Refs B-1] +
[Related Refs A][EnumList of Refs B-2] - LIST()

I removed “- LIST()”, replaced it with UNIQUE(), and the problem was solved.

Thanks much!!

  • :grinning_face_with_smiling_eyes: :grinning_face_with_smiling_eyes: :grinning_face_with_smiling_eyes:

Joseph_Seddik_0-1710307682678.png

5

It is very funny that they ban that word. The phrase is from Raymond Chen from when he was able to look at the code but not run the program to reproduce a bug. We should either not allow this at edit time or handle it at runtime, but I’m glad I was able to help

1 Like
6

Didn’t know that, thank you!

Thanks!