Enum Field resets every time child record is entered

AppSheet AppSheet Q&A
,
1

I have an ENUM field that resets every time an entry is made in the child record but Reset on Edit is not turned on for the field. In addition to the image the following is turned on but nothing else - in prior designs the system doesn’t react this way. Any thoughts?

Editable? Yes
Searchable? Yes

3X_f_7_f77f5751750a9ac088a9a5994423cd9e0d4db68e.png
3X_f_7_f77f5751750a9ac088a9a5994423cd9e0d4db68e.png1174×1719 113 KB

Here is button that keeps resetting each time I make an entry in the child records. Child records are currently set to not be seen unless the value of the button is set to Yes

3X_b_2_b2c20b7c7c70354ec1cff971539d14bf1a6dcb63.png
3X_b_2_b2c20b7c7c70354ec1cff971539d14bf1a6dcb63.png636×783 30 KB

2

Are there any actions running that would reset that field?

3

Nothing yet. New form

4

Does the column have a Valid If expression? If so, please post a screenshot of the complete expression.

Does the column have a Spreadsheet formula set? If so, remove it, delete all empty rows of the spreadsheet below the last used data row, and regenerate the table’s columns.

2 Likes
5

Thanks Steve. There’s no Valid If expression and no Spreadsheet Formula. I regenerated the columns but still no luck.

1 Like
6

I would think, then, that there must be an action involved somewhere. Or maybe a bug with Yes/No QuickEdit in detail views?

You’ll probably need to engage support@appsheet.com to dive into your app configuration.

1 Like
7

Thanks Steve

8

Not sure, but did you check the data source, spreadsheet.
The exisitng value could be saved as TRUE / FALSE instead of Yes or No?

4 Likes
9

Thanks Tsuji, the data in the spreadsheet was Yes and No. I deleted the field and created a new ENUM with the same options and we’re back on track.

Thanks for the support as always!

1 Like
10

Not sure what did cause the issue, but good to see the problem is solved, which is the most important.

2 Likes
11

Ok found the bug. The issue occurs when I make another field’s “Show If” option dependent on the ENUM field. For example: the ENUM is a Yes/No. When the user presses Yes, the related child records should appear. When they press No, the child records stay hidden. When I remove these ShowIf options, the ENUM buttons work fine.

Submitted to Appsheet

2 Likes