Feb 07, 2021 06:48 AM
OK - I have built a crazy complex base (IMHO) over the last month and a half. I am amazed at what it can do, but as it seems all advanced bases have - there are some kludgey solutions. Schema just for fun:
OK - so vertically linked tables:
How to get the record created in #3 (Flag created in a Resource Table) to link over and show up in the Master table?
Solution #1: Use automations to grab lookup field names and populate the linking record to get a flag created in #3 to show up in #1. That works. But with four programs, and three or four Resource Tables per program, plus other automations - am at max of 25 automations before I can get them all covered. should have looked up automation caps before I went down that path… :dizzy_face:
Solution #2: I just discovered Link Records by Fields App. Wow! This seems like the solution I have been needing. Sweet. But, I cannot figure out how to automate it. I can’t ask my team to go run an app every time they add a flag from a Resource Table - they might as well just do the extra linking step.
Solution #3: Integromat (or similar) - Requires special IT request, same as special request as was approved for Airtable to begin with, but more scary because it moves data around, and we cannot pursue until some other app requests are made/approved/settled out. #stategovprobs
Solution #4: Junction Table (??) or other similar obvious answer I am not figuring out. This is vertical, not junction as far as I can figure, but open to ideas and missing obvious.
Solution #5: Hire a a professional. See #3 issues, and #stategovprobs
Thanks for your help, and I am looking forward to a proper show and tell post when I have kinks worked out!
Feb 07, 2021 09:19 AM
It sounds like you need #4, a junction table by setting up a many-to-many relationship, as described here:
If not, #3 Integromat is a great option. If you have a budget for this project and you’d like to hire an expert Airtable consultant & Registered Integromat Partner to help you set this up, please feel free to contact me through my website at ScottWorld.com.
Regarding your #2 question, Airtable apps cannot be automated.
Feb 07, 2021 10:15 AM
Thank you Scott! I was afraid of the answer to #2 was no automation. And yes, would love to consult with you and/or use integromat (both would be best I am guessing) but covid/budget restrictions are killing us right now. thanks for your help. Will spend some more time trying to solve the junction table option - which is breaking my brain right now…