Issue with Form Inputs Not Submitting Correctly in End-User Mode

💬 App Building
, , ,
1

Hey Retoolers!

I’m currently experiencing an issue with a Retool application I’ve built, and I’d appreciate your help.

In my app, I use a form to submit data into a Retool database table. Everything works as expected in Edit Mode: all form inputs (including text inputs and select fields) are correctly submitted and displayed in the table.

However, when I switch to End-User Mode, only the fields that have a defaultValue set are submitted correctly. Any values entered manually into text inputs or select fields (which do not have a default value) are not included in the database insert — those fields are saved as empty or null.

I’ve confirmed that:
• The form fields are using .value bindings in the insert query.
• The query is triggered correctly on form submission.
• The issue only occurs in End-User Mode.

Is there a recommended way to ensure that manually entered values are reliably captured and submitted or is it just a bug?

Thank you in advance for your support!

1 Like
2

Hey @Niklas.ITN, and welcome to the forum!

What may be happening (not sure why this happens though and it doesn't behave the same was as in edit mode) is that your form is cleared/reseted before i t is submitted.

Are you able to share more on how are you triggering the query? Is it the default submit settings from the form or a script? What other event handlers do you have around submitting the form?

3

Hey @MiguelOrtiz,

I modified the additional scope for the SQL query which inserts the data. Anyway, now everything works perfectly.

Thank you for your help!

1 Like