Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Conditional Logic when referencing another record?

Topic Labels: Base design
1169 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Jones1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey everyone,

I’m trying to find a solution or a workaround that will allow me to populate a cell with a record from another table, based on the value of another cell in that table.

Screenshot 2021-02-03 at 09.59.27

Basically I would like to populate a cell in another table with the values of “Type”, but only if the value in “Location” is Finsbury Park.

Would love some help with this.

Cheers!

1 Reply 1
Daniel_Kasuardi
5 - Automation Enthusiast
5 - Automation Enthusiast

Populating another table is what I am really looking for as well.
If there are any new information on it, would really love to.

I tried using your concept and run it on automation. In short, it fails. In long, here’s what I did and the result.

image

This is the base.

And then I make a new ‘View’ (on the left side) called View - Place A only. In this case, I use 'Filters" so that only [Place A] is shown.

image

Then add automation, with ‘When record enter View’ as the trigger. Select the View - Place A only.

image

And then the Action is ‘Create Record’ in Table 4

image

And this is the result …

image

In short: Scribbles.

The logic should be right, it’s just some implementation problem. If you find out how to do it, please post it. Very interested to know as well as I am looking for similar things.