Retool Forms Help

App Building
1

  • Goal: I'm creating a form for KPI results. Two of those fields are drop-down values. Using the foreign key relationships, I want to return the values of the KPI field and the person name field from the person table. How do I bind the form fields to those values but insert the IDs in the DB? I am getting a field type error every time I submit the form.

  • Steps: I need some urgent help, please. I have three tables within the Retool default DB:

  • KPI Master
    • id
    • kpi
  • Person
    • id
    • first_name
    • last_name
  • KPI Results
    • id
    • kpi_master_id (foreign)
    • person_id (foreign)
2

Hi William!

I took a look at your scenario and tried to build something similar myself using Retool DB and Retool Forms. From everything I can tell using the UI, there's no direct way to make a Select Field display your name fields while submitting the person id fields for the foreign constraint row value.

While I'm still new to using Retool, I think you could build a similar form-based interface in a full Retool web app instead of using the Forms builder, which is more well-suited to flat, less nuanced data submission.

I might be wrong and will continue investigating as I can definitely see the usefulness here for just about anyone and I see some previous conversations requesting similar "display this but send that" behavior for forms.

Best,
Taylor

1 Like