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.

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.

1 Like

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

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.

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

@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]))

5 Likes

Or I just missed the now completely obvious solution :shushing_face:

2 Likes