Hi Team,
I have data in the smart sheet and I want to fetch that data and store it in the database and it is working fine for me.
Required Functionality: if new data is added to the smart sheet then only that data should insert into the database.
I tried the Unique index but got errors as can not insert a unique key
I use 'For each' for smartsheet data and need to check whether the value is present in the database or not, and this functionality is not working for me, Any suggestions?
Thanks,
Pallavi
Hi Pallavi,
I showed you how to do it on oml file. I hope it works for you.
Please check the oml file.
Best regards,
Yusuf Kerim
Thank you, Yusuf.
It is working fine.
Regards
When you write "if new data is added to the smart sheet then only that data should insert into the database.", do you mean new rows added at the end of your smart sheet, or any cell that could be changed?
You seem to only save a limited set of data from the spreadsheet. If you have an attribute that uniquely identifies that data, you could create a unique index on it. And then use an aggregate to see if the record already exists or not.
Regards,
Daniel