Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 27, 2019 07:28 AM
Here’s the idea:
I want to automatically fill a record’s Primary Field in TableA with a title that is a combination of the “Guest Name” from the same table AND the “Show Code” from TableB, a different table in the same base. However, the “Show Code” from TableB should be automatically determined by the “Show Name” also in TableB that is referenced in TableA’s linked field.
I feel like there most be an If, and, then something or other in there.
EXAMPLE FIELDS:
TableB Fields
SHOW NAME - “Command of Desserts”
SHOW CODE - “COD”
TableA Fields:
PRIMARY FIELD - “COD: Harry Morgan”
SHOW NAME - Linked to TableB’s Show Name
Please help me clarify my convoluted question and thanks for ignoring my ignorance . :grinning_face_with_sweat:
Best,
Chris
Mar 27, 2019 07:44 AM
Hi @Chris_Dukes - try this:
Your table B is as you describe:
Your table A is:
The name field is a formula, concatenating the Show Code and the Guest Name:
CONCATENATE({Show Code}, " : ", {Guest Name})
The Show Code field is a link to table B
The Guest Name is just entered text
The Show Name field is a lookup on Show Code to table B
So, you have to enter the guest name and pick the show code from the link, but the Show Name and the key field are automated.
Hope this helps!
JB
Mar 29, 2019 12:56 PM