Append record with defaults based on a selection (in Form)

1

I am using SaaS to build an Risk Assessment application.

I have a ‘master hazards’ table…. Each record has a default risk field.

I have another Risk Assessment table… I have a form to append to Risk Assessment table… the form has a ‘choice’ control used to pick hazards from the master hazards table (single selection). So far, so good.

But… I would love to append other default values read from the selected master hazards record, i.e. the default risk value, and use that to pre-populate a risk field in the Risk Assessment table. I don’t want to use a link/lookup, as this will fix the value… just looking to default.

Is this doable?

Thanks in advance

2

Hey @richards :wave:

I’m not sure this is currently possible in Baserow, but tagging @frederikdc to confirm.

You can select a hazard from another table, but you cannot automatically populate other fields (like default risk) in the form based on that selection unless you use a lookup field, which remains linked and not editable.

I also couldn’t think of a way to copy a value from a linked record into a normal editable field during form entry or submission. :thinking:

3

@frederikdc any help on this would be much appreciated. I need to query one table based on a user selection, and then append the results of the query to another table. This is quite a standard SQL/database task? Is this doable using API/make.com… I really hope this is doable somehow…

If I can figure out how to do this… then i am off and running to build an application that my clients can use.

Thanks in advance.

4

It can be done with the application builder, but not with a default form view. In the application builder, you need:

  1. A form that shows all the records of one table in a Record Selector element.
  2. When you submit that form (we don’t have a change() of select() event at the moment), you reload the page, but pass the id of the selected record as a query string to the page (or to a new page)
  3. You can use the value from that querystring to prefill a second form to add a record to the second table.
1 Like