Adding +1 in Table/Tab 1 when a record match Table/Tab 1 and 2

[YohanLafon]

Hi, I would like to add +1 to a #Number column to a dedicated Name line in one table as soon as a record is created in another table including the same name. Is it possible?
Thank you very much 🙏

Example:

Table/tab 1

Name.      Surname Number

Yohan       Lafon.      5

Table/tab 2

Name   Surname

Yohan   Lafon   

When a new record is created in table/tab 2 including this exact Name + Surname, it adds +1 (therefore it gets to 6) in Table/tab 1.

Do you know how to do it?

[pressGO_design]

You want to run the Update Records on the Mentors Table, not the the GaiaMatch table. The record ID you want to use is from the Find Records step, and the field that you want to put into # of Matches is Next Number. 

[YohanLafon]

Yes exactly but in the "find record" step, the Record ID is from the GaiaMatch Table (because it's the trigger action) whereas I want to update the Record ID of his twin in the Mentor page not in the GaiaMatch. Therefore it's working well to add a +1 to the GaiaMatchs table but not in the GaiaMentor table because he can find the record idea. Is it clear?

[pressGO_design]

The trigger is when the checkbox is checked in the GaiaMatch table, but the "Find Records" step happens in the Mentors table, not the GaiaMatch table.

In the Find Record step, you need to set the table to Mentors and then find records based on the dynamic condition that GaiaMatch Full Name = Mentors Full Name

If it finds a record in Mentors, then you update that specific record using the RecordID field from the Find Records step. You put the Next Number into the NUM Match field.