Form not usable, works when tested, broken with no changes

💬 App Building
1

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

Screenshot_20250227-000544
Screenshot_20250227-000544758×1688 52.1 KB

2

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.

1 Like
3

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

4

Hi @mascaritas,

Forms are definitely supported :slight_smile:

This is a catchall error, so it's a bit hard to tell so far why it is happening :thinking: 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.

5

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

6

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?

7

Sorry I meant to say:

  1. in App Forms work very reliably, I give the app out on a public link, the only thing that is sub optimal is, that its not nicely formatted and needs some stacks and containers to be mobile ready.

( if anyone knew a good template to use for apps with forms, this would be fantastic help)

  1. However in the from itself I did not do the console log diagnostic, that I need to do again separately