https://community.esri.com/t5/arcgis-survey123-questions/survey123-handling-relationships-for-non-spatial/m-p/1372021#M54127 <P>I develop a survey to be used <STRONG>offline</STRONG>. The data is non-spatial and consists of several tables with one-to-many relationships. My form fills a child data but needs to handle a relationship to a parent.</P><P>If my data were spatial, I would create an offline map, make a user choose a parent feature on it and open Survey123 from a popup parsing the globalID of a parent to a child form to handle a relationship.</P><P>But my data cannot be shown on a map. I am even not sure how a user takes it offline. So question1 is:</P><P><STRONG>1. Does Survey123 allow to take offline non spatial data?</STRONG></P><P>Even it I took my data offline to an sqlite, it doesn't seen to be a way to query DB from a Survey123 form in order to retrieve globalIDs of a parent.</P><P><STRONG>2. Can I query an sqlite db from Survey123?</STRONG></P><P>I thought that I might download parent data to CSV and store it into media folder of my survey to query it from there. But the parent data is dynamic and often updated so I would need a user to make CSV files updated every time they start a survey. CSV update is possible with Python API but I am not sure if it would work on a tablet especially if I'd like it run in the background.</P><P><STRONG>3. Is there any smooth way to regulary update the survey media folder on a tablet while it is online?</STRONG></P><P>Another option would be to make a dummy form with the embedded links to child survey which includes a globalID of a parent. Such a form could be generated while a user is online. But I am not sure what happens if a user gets offline and accidently closes the form. Could it be restored while offline?</P><P><STRONG>4. Any way to save/protect a current view of a form (embedded links in notes) while a device is offline?</STRONG></P><P>Another workaround of a same kind would be to generate an html file with the embedded links.</P><P>Please, let me know if anything of these makes sense or if there are other ways to make it work.</P><P>Thank you,</P> Fri, 19 Jan 2024 00:38:12 GMT EM-wsp 2024-01-19T00:38:12Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-handling-relationships-for-non-spatial/m-p/1372021#M54127 <P>I develop a survey to be used <STRONG>offline</STRONG>. The data is non-spatial and consists of several tables with one-to-many relationships. My form fills a child data but needs to handle a relationship to a parent.</P><P>If my data were spatial, I would create an offline map, make a user choose a parent feature on it and open Survey123 from a popup parsing the globalID of a parent to a child form to handle a relationship.</P><P>But my data cannot be shown on a map. I am even not sure how a user takes it offline. So question1 is:</P><P><STRONG>1. Does Survey123 allow to take offline non spatial data?</STRONG></P><P>Even it I took my data offline to an sqlite, it doesn't seen to be a way to query DB from a Survey123 form in order to retrieve globalIDs of a parent.</P><P><STRONG>2. Can I query an sqlite db from Survey123?</STRONG></P><P>I thought that I might download parent data to CSV and store it into media folder of my survey to query it from there. But the parent data is dynamic and often updated so I would need a user to make CSV files updated every time they start a survey. CSV update is possible with Python API but I am not sure if it would work on a tablet especially if I'd like it run in the background.</P><P><STRONG>3. Is there any smooth way to regulary update the survey media folder on a tablet while it is online?</STRONG></P><P>Another option would be to make a dummy form with the embedded links to child survey which includes a globalID of a parent. Such a form could be generated while a user is online. But I am not sure what happens if a user gets offline and accidently closes the form. Could it be restored while offline?</P><P><STRONG>4. Any way to save/protect a current view of a form (embedded links in notes) while a device is offline?</STRONG></P><P>Another workaround of a same kind would be to generate an html file with the embedded links.</P><P>Please, let me know if anything of these makes sense or if there are other ways to make it work.</P><P>Thank you,</P> Fri, 19 Jan 2024 00:38:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-handling-relationships-for-non-spatial/m-p/1372021#M54127 EM-wsp 2024-01-19T00:38:12Z