topic Re: Related table creating blank rows despite minimal appearance. in ArcGIS Survey123 Questions

Related table creating blank rows despite minimal appearance.

NicholasConnolly — Wed, 07 Aug 2019 17:14:24 GMT

I have created a Survey in Survey123 for Street Sign Inventory and Inspections. The survey and features are hosted. There are three tables, a feature layer (Poles), a related table (Signs), and a related table (Inspections). Signs table is related to Poles features and Inspections table is related to Signs.

When I use a minimal appearance for the Poles – Signs relationship a row is created when + button is pressed.

However, when I use a minimal appearance for the Signs – Inspections relationship the + button is not present and a blank row is created. This is not ideal as there will be a blank inspection for every Sign.

Using an appearance of minimal compact doesn't seem to work either.

How do I configure the Inspections so that they are only created when necessary? Something like the + button described above?

Re: Related table creating blank rows despite minimal appearance.

JamesTedrick — Thu, 08 Aug 2019 21:56:53 GMT

Hi Nicholas,

It appears that you have set up the form correctly. The issue seems to be the datetime with now(); when I create a duplicate survey, the submission/lack of submission for the nested works until that is added to the form. Can you try removing it and see if the submission behavior works correctly? Based on this, I've logged an issue to address this.

Re: Related table creating blank rows despite minimal appearance.

NicholasConnolly — Thu, 08 Aug 2019 23:48:03 GMT

Hi James Tedrick,

Removing the now() function from the datetime field alone didn't fix the issue. I also had to remove the calculations from the SignID and SignTypeDesignation fields.

After removing the default value of now() and removing the calculations from the fields, the Survey now only adds an inspection when the + button is tapped.

Thanks for your help and thank you for logging an issue to address this problem.