How to fix regenerate schema error?

[colodev]

I am building an app with multiple tables that reference each other. In the form view for Table A, the inline view for the child Table B was showing up correctly. I had to add a couple of fields to Table A, regenerated the schema, and all was good. Today, I needed to add a couple of more fields, regenerated the schema, and Table B no longer shows up in the form for Table A. I rolled back to a previous version and deleted the fields, and Table B’s records showed up in the form. However, I wanted to test if it was the new fields causing the issue, or just regenerating the schema, so I regenerated without the new fields (so, as it was after the last regenerate that worked fine), and Table B disappears from the form again.

I have tried deleting and re-adding the reference (I’ve made sure “Is Part Of” is correct) and that didn’t work, neither did rolling back the sheet itself to the last update when I last successfully regenerated in AppSheet.

I have searched for answers and have tried every trick I could find to fix the problem, and I just cannot figure out why I can’t fix this nor why adding columns would break unrelated references.

Sorry if this is a total noob question, I am, afterall, a noob.

[Steve]

I’m not entirely clear on the problem. Could you post some screenshots of the screens that don’t display what you expect? Also, screenshots of the column configurations of the columns involved.

[colodev]

No problem. I’m a new user, so I’ll have to add them in separate comments.

This is how the form is supposed to look. When I click “regenerate schema” on the “Opportunities” table, the “Dates, Times, and Roles Available” field disappears.

[colodev]

Here is the parent table

After I regenerate the schema, I have tried to remove the “show if” expression and that doesn’t help.

[colodev]

The child table.

All other fields are default.

I can see no changes to the underlying expressions or references between after I regenerate the schema and the view I roll back to.

[colodev]

Finally, the form view setup.

I should mention that when I deleted the reference and re-added it, I did the same in the form view. Still no joy.

[scott192]

Your Initial Value formula for column Opportunity is incorrect. When you use [_THISROW] you have to follow it with the name of the column IN THE ROW that you are looking up. So something like this [_THISROW].[Title]…

[Steve]

Actually, [_THISROW] should be fine: it just refers to the key column value of the row.

[Steve]

Does the Dates, Times, and Roles Available column have a Valid if expression? If so, what is it?

[scott192]

Everyday I learn something new! Cheers @Steve

[colodev]

It does not.

[Steve]

Please post a screenshot of the configuration of the Dates, Times, and Roles Available column, and a screenshot of the form view configuration that includes it.

[colodev]

Here is the form itself

[colodev]

Here they are all again after I regenerate the schema of the Opportunities table

[colodev]

[colodev]

[Steve]

All that looks good.

When you regenerate the table causing the column to disappear from the form, has AppSheet changed the table’s key column? Sometimes, AppSheet decides during a regenerate that the previous key column is no longer suitable and changes it, typically to _RowNumber.

[colodev]

I double-checked and the key and label are correct the way I set them up.