Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

need help with a formula to scan values in 3 fields in Table B and

Topic Labels: Formulas
245 4
cancel
Showing results for 
Search instead for 
Did you mean: 
jym
4 - Data Explorer
4 - Data Explorer

Hi - first timer here!

I have 2 tables in 1 base.  Table A contains info about Recipes I'm creating. Table B is where I schedule those recipes for newsletter publication. Recipe names are pulled from Table A into Table B by linking fields. There are 3 recipes per date, so 3 linked fields. So far so good.

I want to have the newsletter date in Table B pulled into the corresponding recipe record in Table A. See attached illustration - what formula do I need to replace the question marks with dates?

4 Replies 4
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

If the newsletter date is the primary field in Table B (the field with the record's name), then the linked record in table A will itself be the newsletter date. If not, then you will need to add a lookup field in table A (right click the linked record field linking table A to table B (from table A), add lookup field, select Newsletter date).

Hi there! I tried that, but it is only pulling the newsletter date for recipes entered under the Recipe 1 column.

jym
4 - Data Explorer
4 - Data Explorer

Hi Again - I found the solution - and you probably already assumed I knew this, lol.  I now have just 1 column for recipes in Table B - and have set it to allow multiple records to be linked.  So simple!~

Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

I literally had that typed up in my initial response and deleted it haha. Glad you got it figured out!