# Append record with defaults based on a selection (in Form)
**URL:** https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353
**Category:** Uncategorized
**Tags:** app-builder
**Created:** [April 24, 2026, 12:36pm UTC](https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353 "2026-04-24T12:36:35Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@richards](https://community.baserow.io/u/richards)
#### Post date: [April 24, 2026, 12:36pm UTC](https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353/1 "2026-04-24T12:36:35Z")
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
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [April 28, 2026, 1:26pm UTC](https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353/2 "2026-04-28T13:26:26Z")
Hey @richards 👋
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. 🤔
---
### Author:  [@richards](https://community.baserow.io/u/richards)
#### Post date: [May 1, 2026, 12:08pm UTC](https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353/3 "2026-05-01T12:08:13Z")
@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.
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [May 4, 2026, 8:41am UTC](https://community.baserow.io/t/append-record-with-defaults-based-on-a-selection-in-form/12353/4 "2026-05-04T08:41:45Z")
> [@richards](#):
>
> 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…
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.