Help

Re: How do I Concatenate with fields from another table?

673 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Dukes
6 - Interface Innovator
6 - Interface Innovator

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

2 Replies 2

Hi @Chris_Dukes - try this:

Your table B is as you describe:

Screenshot 2019-03-27 at 14.40.03.png

Your table A is:

Screenshot 2019-03-27 at 14.40.12.png

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

Screen Shot 2019-03-27 at 1.06.54 PM.png