Form generated from database populates fields in a random order

  1. My goal: Generate a form from a database maintaining the column order
  2. Issue: The form populates the fields in a random order, and I have 55 fields so it takes a very long time to reorder correctly
    Also I have updated some of my field types in the database (from boolean to text), but this is not then updated in the form without generating a new one (which is then not in the correct order)
  3. Steps I've taken to troubleshoot: looked at the forum to see if this problem has occurred before, tried to play around with settings but no luck.

Please could you help, thanks!

Hey @G_Box Welcome to the retool community ,

For your issue follow the steps :

Click on generate form from table in form component:


Click on the table you want or data base you want

Select the table you want from the database

Now in this you can change the index of the field you want using that 6 dot drag where ever you want
And you can also change the input type whatever you want to use in it. It will give you fields in order that you set in this table.
If you need any other thing in it ask me.