Online/Offline sharepoint backup system creating duplicates.
3 weeks ago
So I've made an app for a field crew to record quality control conditions, it saves data locally when offline, and uploads when online. it also stores each record locally as a backup if an upload to sharepoint fails or if the record is deleted from the back end.
It works fine if there are no edits made to the record. but if the record is changed, even if the strings its checking are identical, it will push a new duplicate record. See example code below, it runs on a trigger to check the backup data against the sharepoint list.
Text(ElemQCNum) in ElementData.ElemQCNum,
Text(DrillCount) in ElementData.DrillCount,
Text(Title) in ElementData.ProjectFullName
does anyone else have a cleaner "upload if record doesn't exist online"? "ElementData" is the online list, "ElementDataBackup" is the local collection. all column names are double checked and correct.