Latest Contributions by PanGIS

‎05-20-2022

Hi @IanGallo have you solved? I am replying in order to see if someone has something new to say. It happens randomly and I can't figure out whether there is something wrong from my side. I have a hosted feature layer with new fields and 1 view is used in a complex system of apps. I can't risk to lose everything by creating a new view. All the other views can see the new fields (a couple of them where created at the same time with the one that doesn't work.) I can't understand!

‎05-20-2022

Thank you for this late reply but I worked, thank you! 🙂

‎05-04-2022

Hi everybody! I am trying to complicate my life 🙂 and I want to get the following: I have a multiple choice that will be eventually hidden. This multiple choice is fed by other questions. I would like to get all Options selected in the "Option needed" question, but it selects only the fist option. If I select the second and the third choice, then it will select the second only. This is the calculation: if(selected(${Choice1},'Choice1'),'Option1', if(selected(${Choice2},'Choice2'),'Option2', if(selected(${Choice3},'Choice3'),'Option3',''))) I am not able to figure out how to solve it. Thanks!

‎04-14-2022

Hello! I am trying to filter my repeats in order to get only one (the last) in my web form, trying to edit the URL parameters but I don't seem to find a solution. Anybody has an idea? Thanks!

‎03-22-2022

Hello! I need to calculate a date that is "Next month from today AND always on the 10th of the month" I followed this article and I managed to get this, which is great How To: Apply a constraint on a date question in Survey123 Connect for ArcGIS (esri.com) The problem is that I would like to make this valid every month. Any idea? thanks! 🙂

‎03-02-2022

Fantastic Derrick, it worked! With you example you also pointed me out to the right documentation. Thank you!

‎03-01-2022

Hello! I need to create a report the prints only the last repeat submitted. I am implementing the flow in Integromat but what I get as attachment is all the inspections contained in the repeat: I suppose it should be something like the following but, of course, it is wrong. ${#Repeat | stats:max,surveyDate} ${/} Thanks! 🙂

‎02-24-2022

Hi @GregoireCatineau here a blog about repeats, Section: "Repeats in the Inbox" Survey123 Tricks of the Trade: Repeats - Esri Community

‎01-24-2022

@DougBrowning wrote: Best thing is to make a second set of if(value, 1, 0) and then count those just like you do for Choice_T. I think it is the best way. int("") is what is causing the non calc. Thank you!!! this solution worked, and it is amazing. Unfortunately, I realized that when I set the esri:parameter to allowUpdates=true the count goes back to NULL as it was before. This is a pity because I need to review a previous survey and for some reason it doesn't pick up all the info, but I am still working on it. I have to see if there is a workaround.

‎01-20-2022

Hi @DougBrowning thank you again! I had a look at your suggestion but the problem is that I want to actually calculate : int(${Choice1}) +int(${Choice2}) +int(${Choice3}) because these values count how many solved problems I have, instead int(${Choice1_T}) +int(${Choice2_T}) +int(${Choice3_T}) calulates the original problems. Then, the difference gives me the number of problemes that still need to be solved, don't know if it make sense. ${Choice1} is a Yes or No question where no=0 and yes=1 and, I can't understand why, it sums up the values only when all 3 of them are selected (the default value is 0 and I believe here is the problem: this default value is not taken in consideration.) If I choose all of the in the first question, then I have all of them are answered I have 0 +1 + 0 =1 If I choose only one or two, this doesn't work.

‎01-19-2022

@DougBrowning I set all binds to int, and I fixed that calculation but still...same as before I uploaded here the updated XLS, in case you have time to see it again. Thank you for the hint. I have always overlooked that bind.

‎01-19-2022

@DougBrowning all the calculations are inside the repeat. This is my sample. Thank you!

‎01-18-2022

Hi, I've created a calculation that counts how many problems are solved. - Problems are first selected from a multiple selection question. Every problem, if selected is =1 in a hidden question. the sum of all of them gives me the "Problem = number" When the problem is selected a question: "it has been solved" comes up: if answered yes, an hidden question collects =1 and they are summed up. Solved = number A calculation Problems - Solved = to be fixed this I know how many problems I have, how many fixed or not It works perfectly if all my 3 problems are selected, if I select only one or two the calculation doesn't work: solved and to be fixed are empty. this is a repeat table. By default all values are set to 0 {es.= if(selected(${Problem},'Choice_1'),1,0)}, can't understand why the value Solved and To be fixed is empty Thanks!

‎01-11-2022

@RobertScheitlin__GISP Hi Robert, this is great! I wanted to ask you if it would be possible to enable it on GlobalId as well. I am too afraid of screwing up everything. 😅

‎12-03-2021

Thank you @ZacharySutherby . I removed some old surveys from my design and now everything loads quicker.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by PanGIS

Re: "Update View" not displaying newly added fields in feature layer

Re: Auto select Multiple choice from other answers

Auto select Multiple choice from other answers

Filter repeats in Web Form (according to the allowUpdates=true query...... in Connect)

Re: Dates and Time in Survey123

Re: Create report for the last repeat only - help with syntax

Create report for the last repeat only - help with syntax

Re: repeats section is not populate with the data

Re: Help in Calculating Difference when a multiple selection is involved

Re: Help in Calculating Difference when a multiple selection is involved

Re: Help in Calculating Difference when a multiple selection is involved

Re: Help in Calculating Difference when a multiple selection is involved

Help in Calculating Difference when a multiple selection is involved

Re: Enable ObjectID field for Find Locations and web map url parameters

Re: Survey123 Connect is extremely slow when I dare to do anything

Re: June 2026 update - Category Selector no longer...

Re: June 2026 Update - Dashboards performance issu...

Re: June 2026 update - Category Selector no longer...

Before June 2026 update my Dashboards were working...

Re: Survey opened via link in Field App does not p...

Python Snippets