Latest Contributions by MikalaRandich1

‎10-16-2019

Hi James, so I did end up implementing repeats and some other suggestions which reduced the size of the form greatly, removed relevant statements for hidden questions, etc. I'll be more specific about where the crash in iOS is happening, as it is still occurring on all iOS devices I test it on. If you select 'No' for the "Rapid test for hydrophytic vegetation met?" question, then choose either Four or Five stratum, and go to one of the repeat stratum sections and go to enter data. Once you enter species, absolute % cover, then go to choose an indicator status for the "Vegetation - Tree Stratum - Indicator Status" (example) question, the form consistently crashes. Any more suggestions would be a huge help! I'll update the original question with my updated xls form sheet.

‎10-07-2019

Hello, I have a fairly large form with calculations. At first, some of the calculations worked in Connect and the Android field app, but not in iOS. I added the coalesce function to some of the calculations, and that made them work in iOS. However, after adding coalesce functions to the final field that was giving me problems, now the form crashes in iOS, but still works in Connect and Android field app. Specifically, adding coalesce to the calculation in field 435 seems to be the tipping point, as without it, the form will not crash, but the calculation will not work. Any help to get the calculation in field 435 to work in iOS without crashing the form would be greatly appreciated!! The two versions of the form are attached. Thank you, Mikala

‎10-04-2019

Hi James, thanks so much for the suggestion! I thought I would have avoided this by entering "0" as the default for the preceding input questions, but the coalesce function solved the problem. Thanks again!!

‎10-02-2019

Hi Doug, thanks for your response. I updated the question to hopefully be more specific. I changed the field types to all be integer as well as put 'int' in bind::type, and removed the int() functions from rows 438 - 443 as a test, but row 443 still will not sum rows 438 through 442. As background, the original form was created in the web designer before pulling into Connect, which created the duplicate lists, and I will look into creating groups to better organize the form.

‎10-02-2019

Hello, I have a large form where some fields that are calculated build on each other. I have some pretty basic addition calculations of previous fields I need some of the last fields to complete, that I cannot get to work. There are slightly more complicated conditional statement calculations that work fine, so I'm having a difficult time figuring out why the addition won't work. In the attached xlsx file, I would like row 443 to sum rows 438 through 442 , row 450 to sum rows 445 through 449, row 457 to sum rows 452 through 456, row 464 to sum rows 459 through 463, and row 471 to sum rows 466 through 470. Currently, nothing appears in these fields, when the sums should be appearing. Any help would be greatly appreciated!!! Thank you, Mikala

‎08-05-2019

Thanks so much Jim, that worked!

‎08-02-2019

Hello, I was wondering if you could configure the template in Survey123 or the feature report tool to omit fields from the report that have null or no response? Thanks for any assistance! Mikala

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by MikalaRandich1

Re: Form crashing in iOS only

Form crashing in iOS only

Re: Addition Calculations Not Working

Re: Addition Calculations Not Working

Addition Calculations Not Working

Re: Can you configure the template or feature report to omit null fields?

Can you configure the template or feature report to omit null fields?

Can you configure the template or feature report t...

Re: Can you configure the template or feature repo...