Thanks for sharing all of your tests here! I am similarly trying to create records from appsheet. I’m not the most technically literate - so records like yours are very useful. I would greatly appreciate your insight on our specific use case.
Our team works in humanitarian zones. When offline, they log data into APPSHEET. This data is then uploaded to Salesforce for nonprofits once they reach an internet connection. We regularly see user profiles duplicated. We would like to prevent duplicates. However, rather than merging two user profiles into one (potentially erasing unique data created at an earlier date), we would like all user data to be included in a ‘log’.
To further explain this, please use this example of ideal usage:
Humanitarian Workers are in Haiti. They meet with a user, Jane. They log Jane’s name, height and weight into appsheet. Once the humanitarian worker reaches an internet connection, this data is manually pulled through a .csv into salesforce.
The next month, the humanitarian workers return to Haiti. They log Jane’s name, height, and weight into appsheet. Jane has gained significant weight. Once the humanitarian worker reaches an internet connection, this data is manually pulled through a new .csv into salesforce. The salesforce database recognises that the new update on Jane should be connected to the previous upload on Jane. It shows the two logs together, noting the weight change.
Do you know how to handle multiple uploads from appsheet like this?
@Takuya_Miyai do you have any particular insights?