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: