Pre Populate a Link Field To Return Set Values By Default

[SparKey]

Hi there, 

I am hoping that someone will be able to help me with this interesting little problem. 

I have a table as a "reference table" which allows me to set fees globally across the base so if a fee for tables goes up I can change it across all records. That same table contains other fees such as fee for square footage used elsewhere.

In the table "Bookings", the second table, where the reference field is then used, I would like the ability to auto pull through the value field based on the lookup value. Example below. 

In "Reference Table" the fee for tables is 12.00 

In the "Booking Table" I have the link value as the Reference Field "Table Fee" and the lookup value of "Value"

All of this works fine but in the Reference Field, I would like that to be able to populated with the "Table Fee" so that the value pulls through also. Is there a way to do this?

The option for pre selecting a value that appears in other fields is not available in a linked field.

Thanks in advance for your help. I appreciate it. 

S

[Cobey-Wan]

Hello there, I'm struggling a bit to understand the exact issue you are having. I have an idea of what your looking for but I will need additional photo to fully comprehend your use case.

1. Please send me a picture of the 2 linked tables and briefly explain to me your work/data flow (example: data enters on this table, which creates a record on a different table, which triggers an automation to update a record on another table etc etc.)
2. What do you envision and how is your current project falling short?

🤘Airtable Rocks 🤘

[TheTimeSavingCo]

Setting a default record in a linked field isn't possible at this time I'm afraid.  Perhaps you could try creating an automation for this instead?  You'd make it trigger whenever a record was created and its action would be to link the new Bookings record to the appropriate Reference record

[Alexey_Gusev]

Hi,
Sorry but your question is not quite clear.
If you want to fill the whole link column with the same value, just copy and paste it to the whole field

[SparKey]

It looks like this might well be the solution. I will try to create an automation when I get to this point and then copy my findings back here when I have done that. 

[VikasVimal]

If the linked record is fixed, you can run an automation and pass the recordid of the record you want to have filled in the field. That has the same behaviour as filling a default value in a linked record field.

Get the default linked record's recordid by opening the record and copying the 17 character 'rec2wefe2f4f2d23f' type string from the url. it starts with 'rec'

Run when a record is created > update the record > add the linked record field and paste the value you copied.