Dear Community
I created a working form that submits to retool db and a workflow, tested, published, worked.
(There is a primary key increasing integer involved in the form but it is hidden)
Now when I gave it out, it suddenly stopped working, and there is no explanation why.
How can I find out what's gone wrong in an otherwise working form?
Is it generally not recommended to use forms it looks like it's no more supported
Hey @mascaritas,
I'm sorry your experimenting this error, and I noticed you posted also here. I'm assuming it is the same issue, right?
I unfortunately have no suggestions for you, but tagging @Tess in case she's able to help.
Thanks Miguel
Yes, I was hoping to get a hint from anyone in the community or team, even if it was "don't ever use forms because its end of life or unsupported"
If @Tess has an idea or comment , would be great.
cheers
Hi @mascaritas,
Forms are definitely supported 
This is a catchall error, so it's a bit hard to tell so far why it is happening 
Can you start by checking the form setup under "Database"? Do you still have a database and table selected?
This error could also come up if the form was moved to the Drafts folder or there's a problem connecting to the database.
Hello @Tess thanks for your reply.
I built the whole process with in app forms and there it works flawless.
when I use from for the same functionality (form derived from the db table that was created earlier, it includes a primary key that is a increasing integer ID, maybe thats the problem, I have to hide these values for the form)
now the behavior was very spooky, it worked, when I gave it out for testing, stopped . In App form works everytime
Hi @mascaritas,
Are you sharing it out as a public app or are folks logging in to your Retool org to access it?
Are they getting an error message in the app or browser console (do you see any errors in the Network tab)?
Generally, it should be fine to have the id hidden in the form. Do you have the id set to auto increment?
Sorry I meant to say:
( if anyone knew a good template to use for apps with forms, this would be fantastic help)
For troubleshooting, if you show the id in the form, does it work? I noticed if my form submits an invalid value for the primary key, I can reproduce this error.
Did you add any columns to the underlying database and then run "Sync from database"?
When you get a chance to go back to the standalone form, it would specifically help if you can check the network tab for the query that triggers when clicking submit on the form. The network tab may have more insight into why the error is showing up:
thanks a lot for this debug info, I was able to replay this.
however I do not find any option to "sync from database" I did in fact add more columns to it.
I also see that other variables in my form have lost their connection to pre existing colums., therefore a "sync from database" option would be super appreciated, where can I find it ?
