I think this may not be possible based on Access fields from linked record in formula without creating Lookup fields - #2 by Kamille_Parks but I’m going to try anyway!
I have a pretty complex base based on some longterm needs and incoming records and trying to squeeze things into Airtable that aren’t quite possible. Right now, I’m dealing with two tables that are linked together and linking existing records together.
Table 1: Main table.
Table 2: Form submission.
Table 1: Over a years’ worth of information about people, including linked records of people who are in relationship with one another.
Table 2: People who exist in Table 1 one are submitting updated information about themselves AND other people that exist in Table 1. When someone submits information via a form, we link their record to their record in table 1 (usually by the VLookup automation, but since this breaks a lot, often manually.)
Table 2 has an important field called “Can you continue to pay for groceries?” that is filled out by someone submitting a form. When the the submission is linked back to Table 1, a lookup field is created so this information shows in that table.
I would like to create a formula that shows the information in that field (yes/no) NOT for the person who submitted the form, but for the linked record in Table 1.
So:
- Person A and Person B are linked because of a relationship in Table 1.
- Person A submits a form, which appears in Table 2.
- Person A’s record in Table 2 gets linked to their matching record in Table 1.
- A Lookup field displays {important field from Table 2} on Table 1 for Person A.
- I would like to display {important field from Table 2} on Table 1 for Person B on Table 1.
Is this possible? (I’ve tried to explain this clearly, but please let me know if you have questions!)