Skip to main content

Hello everyone,


So I’m a bit confused on how to do this one.


I have two tables named “Dashboard” and “Payments”.


Table “Dashboard” has two important fields - “PU Date” and “Driver(s)”.



Table “Payments” has 4 important fields - “Driver” (manually choose), “From” (manually choose), “To” (manually choose) and “Loads” (needs to be automated).



So, I want to import all records from “Dashboard” table to another field (Loads) in “Payments” table “as link to another table”. But I want these newly imported records to be between certain dates “From” and “To” and to match the Driver I choose.


How can I do that?


Hope you understand. Thanks

You may need two automations. Try one of the following setups and if it doesn’t suffice use both:



  1. Triggers when record in Payments has the fields {Driver}, {From}, and {To} are not empty

  2. Find Records step that looks at the dashboard table where the conditions are “{PU Date} is on or after {From} field” and “{PU Date} is on or before {To} field” and “{Driver} is {Driver}” and “Link to Payments is empty”

  3. Update record step to fill in the trigger record’s Link field with a concatenation of the list of record IDs from step 2 and whatever the current value for that field is (so records already linked don’t get overwritten)


Second Option



  1. Triggers when record in Dashboard has {PU Date} not empty

  2. Find Records step in Payments table where “{PU Date} is on or after {From}” and “{PU Date} is on or before {To}” and “{Driver} is {Driver}”.

  3. Update record step to fill in the trigger record’s Link field with the list of record IDs from step 2

You may need two automations. Try one of the following setups and if it doesn’t suffice use both:



  1. Triggers when record in Payments has the fields {Driver}, {From}, and {To} are not empty

  2. Find Records step that looks at the dashboard table where the conditions are “{PU Date} is on or after {From} field” and “{PU Date} is on or before {To} field” and “{Driver} is {Driver}” and “Link to Payments is empty”

  3. Update record step to fill in the trigger record’s Link field with a concatenation of the list of record IDs from step 2 and whatever the current value for that field is (so records already linked don’t get overwritten)


Second Option



  1. Triggers when record in Dashboard has {PU Date} not empty

  2. Find Records step in Payments table where “{PU Date} is on or after {From}” and “{PU Date} is on or before {To}” and “{Driver} is {Driver}”.

  3. Update record step to fill in the trigger record’s Link field with the list of record IDs from step 2



There’s no option to choose {From} and {To} fields in conditions. I can only choose “today, tomorrow, yesterday, onw week ago” etc.

Reply


Terms & Conditions