I'm experimenting a very strange behavior in my app: I've many IsaPartOf relationship between table father and child and I'm able to Interact and use them as supposed, but today's with no apparent reason a relationship start to have problems:
First I've noticed that the child table row miss the parents ref after save.
I'm able to see the parents ref in the detail form when try to add a child row on a table, but after save and sync the parent ref was not stored in the gsheet child table, this results in a un-linked row.
So I've completely removed the child table data source and re add it. When I've re-generated the father structure data , after setup the IsaPartOf reference in the child table, AppSheet has not recreated the ref_rows virtual column for this child. Other 3 child ref_rows was recreated and work with no problem from the same father table.
Now the last surprise: There is no way to have this child ref_rows list in the edit form of the father table. Other child ref row's from other table are visible and I can create and edit if from the edit form of the father.
Save, update and reload the page does not solve the mystery. I'm very frustrated.
LinkedIn
Twitter
