nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 - Data from fields removed

FranciscoAndrade1

A survey has been created and anytime the following steps have been performed the quantities get removed:

Configuration of form:

Step 1:

Input quantity under 'Quantity' field (value greater than or equal to 1).

Step 2:

Update input quantity to Zero under 'Quantity' field.

Step 3:

Update input quantity to greater than or equal to 1 under 'Quantity' field.

Error: Values under fields named, Wattage, Hours/Day, Hours/Years, kWh, Cost Per Month and Cost Annually get removed. Values do not get regenerated.

Video below:

Encontre mais publicações marcadas com

Accepted answers

All comments

JamesTedrick

Can you share the XLS file? I'm also wondering a bit on the survey design - you have separate sets of questions based on the size of the TV - are they the same questions (for different sizes) or different questions per size?

FranciscoAndrade1

James Tedrick‌ i don't know how to attach the file. See link below for the XLS file.

Appliance Calculator - Test.xlsx - Google Drive

JamesTedrick

Hi Francisco,

What you're experiencing is an interplay between default and relevancy. As you might expect, a default value is only assigned when the form is created. When a question goes from relevant to not relevant (i.e., not displayed), the answer for that question is removed; this is to ensure we don't save answers to questions that, according to the form's logic, haven't been asked.

As a workaround, instead of supplying a default value, we can use a calculation that uses the same statement as your relevant clause in an if statement to calculate in the default value - see attached.

Appliance Calculator - Test.xlsx

FranciscoAndrade1

Thanks JTedrick-esristaff‌

That helped out. I really appreciate the help.

FranciscoAndrade1

James Tedrick‌ I am having an issue again with the survey123. See issue below.

Step 1: The survey is loaded and fields named Estimated KWH Monthly Average and Estimated KWH Annually have a value entered 'zero'.

Step 2: A value is entered in field name Water Pump (Quantity). Values for Estimated KWH Monthly Average and Estimated KWH Annually are updated.

Step 3: A value is entered in field name Pool/Spa Pump (Quantity). Values for Estimated KWH Monthly Average and Estimated KWH Annually are removed.

Note:

Calculation for Estimated KWH Monthly Average can be found on row 713.

Calculation for Estimated KWH Annually can be found on row 714.

I don't know how to attach the file. See link below for the XLS file.

Form 1.xlsx - Google Drive

Also, if there is something you can recommend to make the loading time quicker it would be great.

Thank you and I appreciate your support.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.