Hi there,
I'm trying to connect some data from Forms to Excel.
Basically, I want to create a day off system. I already manage to synchronise the Form with the Excel, so that the responses are automaticly registered in the Excel Table.
Now in a different sheet, I want to keep track of the people registered.
Every time that someone uses the Form, they have to add their unique ID code. I want to create an automatization, when this code appears for first time, a new row will be added in the table, but if the code already excist, then simply update the row with the new data.
Thanks for the help.


Report
All responses (
Answers (