Form not loading

[CarlosBr]

I'm facing a  problem in my app. This one is new to me. Try the community but nothing related .. maybe someone could give me tip on this..

I have a  input form to add data to a simple table and for some reason that form stopped showing the fields , just that form. I have another one for another table that works fine.

it doesn't show not even one field. I have some condition to hide some os the inputs but not all of them.  Its just acting very weird

when I click to open the form it shows an empty screen and I just noticed that underneath the app preview it doesn't shoe the right table or the right view like its supposed to.
I also tried to go back to older version but I 'm still getting the same empty screen in all the version and I mean all! 

Maybe I'm missing something?

any tips on this?

[Steve · Accepted solution]

In my experience, this can happen when an expression that's used only or primarily in forms exercises a bug in AppSheet itself.

To find the problem, remove all expressions from all settings of all columns of that table, save the config, and reload the form. If the problem was with one of the expressions, the form should load without problems. Then add one expression back, save, and open the form. If the form loads okay, leave the expression there and restore another one. Save, load form. Repeat until you find the expression that causes the problem.

The most common cause (again, in my experience) is an IFS() expression that does not have a default case, and so does not always produce a result. I've also seen problems with EXTRACT...() functions.

[Steve · Accepted solution]

In my experience, this can happen when an expression that's used only or primarily in forms exercises a bug in AppSheet itself.

To find the problem, remove all expressions from all settings of all columns of that table, save the config, and reload the form. If the problem was with one of the expressions, the form should load without problems. Then add one expression back, save, and open the form. If the form loads okay, leave the expression there and restore another one. Save, load form. Repeat until you find the expression that causes the problem.

The most common cause (again, in my experience) is an IFS() expression that does not have a default case, and so does not always produce a result. I've also seen problems with EXTRACT...() functions.

[CarlosBr · Accepted solution]

I solve the problem yesterday. I did almost what you said. So for people who's facing this problem this is what I did. 

I made a copy os the form and stared removing the collumn in the UX editor. So when I deleted the one that was with a bug the form immediately popped up.

For some reason my formula was creating the bug and the formula was a valid formula.  So I when back to the table editor and did some changes to that formula and I got it working again with a new formular.

[Steve]

Well done!