Help

Re: Updating Linked Field automatically

470 0
cancel
Showing results for 
Search instead for 
Did you mean: 
rfscott2016
6 - Interface Innovator
6 - Interface Innovator

If you have a table, Table B, which is linked to Table A which has Project Name. Is there a way to update Table B with any new project specified in Table A? 

 

1 Reply 1

Hmm, so you have a single record in Table B, and every time a new record gets created in Table A you'd like it to be linked to that one record in Table B?

If so, try:

1. Create an automation that triggers when a new record is created in Table A
2. Give it a "Find Record" action that will look for that single record in Table B
3. Give it a condition logic step
4. If the "Find Record" action's result length is > 0:
  - Give it an "Update Record" action that will update the single record in Table B with the value of its linked field to Table A from step 2, followed by a comma and the record ID of the triggering record from step 1 into its linked field to Table A
5. If the "Find Record" action's result length is = 0:
  - Give it an "Update Record" action that will update the single record in Table B the record ID of the triggering record from step 1 into its linked field to Table A
Screenshot 2023-04-14 at 1.21.03 PM.png

And here's a link to a base with that automation set up to get you started!