Trigger adding a value to another table

Hi,

I’m trying to add a value to another table when a new user is added to my ‘users’ table. Based on the email added in the users table, I’d like to add this same email into the ‘filters’ table.

I have this workflow…

and this action…

Upon adding a new user to the users table, the filters table is not updated.

0 7 335
7 REPLIES 7

Hi @Colin_Lough,

You can accomplish by adding the action to form saved action. Add the Add new user to filter table action to the Event Action: Form Saved on the Behavior section.

Thank you @James_McFarlane.
Where I have ‘test@email.com’ listed as the new value of the useremail column, what would be the expression used to find the most recently added value of the ‘useremail’ column in table ‘users’

I’m looking at maxrow() but can’t figure that one out.
Thanks

Easiest way to find the latest record is to add a column with “Reset on edit” and initial value “NOW()”

khuslid
Participant V

I did this. From ACCES to FILTER
Used the action: Add a new row to another table using values from this row.
Then the value Email to Filteremail. (I made a REF from ACCES table)
And then only if this condition is true:
NOT(IN( [Name.[Email], FILTER[Filteremail]))
And I trigger the action when saving the form in ACCES.

@khuslid, thank you. Can you explain the 3rd point for me please?
What do you mean (I made a REF from ACCES table), where did you add that?

  1. You have an access table and are updating that email address to filters table.

  2. Used the action: Add a new row to another table using values from this row

  3. Then the value Email to Filteremail. (I made a REF from ACCES table)
    And then only if this condition is true:
    NOT(IN( [Name.[Email], FILTER[Filteremail]))

Or I just missed the now completely obvious solution

Top Labels in this Space