Using Softr DB, forms and new linked records ... best workflow?

Ask the community
1

I’m testing out the new Softr DB and trying to work out how to best create a new linked record when adding a new main record. Here’s the scenario:

Table of Events, primary field is DATE
Table of Venues, primary field is VENUENAME

All Events have one Venue.

Using a form, when I want to create a new Event and add a Venue I use a Dropdown mapped to VENUENAME which picks up existing records. “Allow adding new options” cannot be toggled on, so what’s the best way to allow users to add a new record to the Venues table so that the form can show this VENUENAME in the dropdown?

I was hoping to add a button in the form, to open a modal to an Add Venue form but this doesn’t seem possible.

2

@MarkSchofield you do want to create a new related record right in the form correct ?

I think we still need to add that future… We do have that for select fields but not for linked records yet however this is something we will be adding in Q3/Q4

3

Thanks @artur
Yes, this is what Fillout Forms can achieve (with Airtable) so I want to do the same with Softr DB.
Here’s a short Loom of theirs with parent and child forms and new child (linked) record creation