Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 02, 2022 05:17 AM
Hello world
I’m working on a budget base which requires a linked field to pull in cost data.
It currently means manually searching for a linked record 20 times for each choir rehearsal (there are 10 venue costs, and 10 staff costs per choir)…
And we have 19 different choirs to do this for (almost 400 manual ‘clicks’).
I’m either being stupid and missing something obvious, OR it requires some form of scripting (in which I am clueless) or automation to make this happen automatically.
Could anyone shed some light?
Here’s a short video showing what I currently have to do.
And here’s a link to an abbreviated version of the base.
Any help would be hugely appreciated!
Many thanks
Curtis
Solved! Go to Solution.
Sep 05, 2022 05:46 AM
I mean not ‘choir’ (it looks like linked field), but the field of MB table, which links to 22W. What you doing now is really a waste of time.
How much records do you have in unfiltered MB? 418 ? if you add ‘count’ field to each link field and see Sum, it’s the same number for both tables. That quickly helps to understand how linking working.
Automation works too, you just should put there all the values found by ‘Find records’, as @ScottWorld advices.
I’m not sure about list of Names, as they are the same and I don’t know how table engine inserts them. Maybe list of Names works too but List of ID should work 100%
Sep 02, 2022 05:37 AM
This could be done with an automation, but you would need to figure out how to tell the automation which records to “find” from the first table that you subsequently wanted to “paste” into your linked record field.
If so, you could just use a “Find Records” step in your automation, and then the next automation step would be to insert the list of records that were previously found into your linked record field.
Sep 02, 2022 10:43 AM
Hey Scott - thanks for coming back so quickly.
I’ve had a play around and can only seem to get one of the twenty records to work…
I added a ‘run automation’ check box to trigger it - would you mind having a look and see what I’m missing please?
The base is here…
Thanks,
Curtis
Sep 02, 2022 04:15 PM
I don’t have access to your base… but why don’t you just post a screenshot or a video? That would probably be easiest to explain.
Sep 03, 2022 11:55 AM
Hi,
Yes, that should be very simple ‘from the other side’. Just copypaste whole Name Column into ‘choir’. If links not created, check difference in values (extra space, wrong letter etc)
Sep 05, 2022 01:56 AM
Hey Scott - sorry for the delay coming back to you…
Here’s a video - so close yet so far!
-C
Sep 05, 2022 02:26 AM
For your “update record” action, you’re telling it to put in just one name. You have to pull from the “find records” step and choose “make a new list of names”.
Sep 05, 2022 05:46 AM
I mean not ‘choir’ (it looks like linked field), but the field of MB table, which links to 22W. What you doing now is really a waste of time.
How much records do you have in unfiltered MB? 418 ? if you add ‘count’ field to each link field and see Sum, it’s the same number for both tables. That quickly helps to understand how linking working.
Automation works too, you just should put there all the values found by ‘Find records’, as @ScottWorld advices.
I’m not sure about list of Names, as they are the same and I don’t know how table engine inserts them. Maybe list of Names works too but List of ID should work 100%
Sep 05, 2022 05:52 AM
Oh right, do “List of Record ID’s” instead of “List of Names” for 100% accuracy under all circumstances.
Thanks, @Alexey_Gusev! :cowboy_hat_face: :raised_hands:
Sep 08, 2022 01:58 AM
Hey Alexey & Scott
Thanks so much for your help and advice on this. What you’ve said makes perfect sense, but I still can’t get it to work… If you have a moment, here’s yet another video showing the issue:
[video 3](https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0)
https://www.dropbox.com/s/ea2lq96wjjae3hx/airtable%20HELP3.mov?dl=0
I've tried everything it would seem but nothing will make it run properly!
Thanks
Curtis