Hello everyone!
I'm new on Retool and I'm facing an error when I try to submit a form.
I'm using Retool database and created a form from database.
When I preview, it looks ok
Could you help me?
Hi @Cirilo_Souza,
Yes, of course we can help. Can you plese post your query form2SubmitToUsers. My guess is you have to explicitly name the ::uuid.
Hello @Shawn_Optipath,
I dindn't change the default configuration, it's using GUI.
In your table can you tell me which columns are of uuid type? also in your form, which fields these are?
1 Like
In Retool db (PostgreSQL) for a uuid field you need to enter either valid UUID string (e.g., "550e8400-e29b-41d4-a716-446655440000") or a null value and not an empty string like "".
In your preview I do not see any uuid strings but a few empty strings (""). This is likely the cause.
Did you sort this out already?
If not, it would be helpful to see the schema for the table