Thanks very much. I’m quite new to app development. Just wondering is there a tutorial on how to sync data using integromat?
I tried a few times with integromat and the normal data is easy to push to my OneDrive Excel. But when there is linked data from another collection where I want to push it from Excel to the app, it pushes empty value.
For example, when I try to push a message to a user, I put the message in Excel then push to the user. The message went through but the user email linked to the user collection is blank.
(Solved: later on I find that the value of the linked property is actually a number insdead of the user’s email. So i need to get the user’s record ID first to be able to link it. But it doubled the number of operations in integromat. hope there is an easier way to identify the link value)
Another issue is that when the message is pushed, I want to delete it in Excel. Otherwise it will keep push the same messages. I put a delete command in integromat. But somehow it didn’t delete the right row, end up with sending message row 12345678 then sending row 2468 again. haven’t figerred out how to solve this…