Latest Contributions by RachelS

‎12-05-2023

Hi @BrianBulla This is the problem, it won't let you '....tap in and make any changes needed' if Now() expression is added. Will it let you? Thanks

‎11-24-2023

Hi @IssyAmis The form currently has 'No Value' in the date field and staff have to click into the field then click ok for it to input the current date. I'm trying to streamline the form with as few clicks as possible. In Survey123 the current date appears in the field and users don't need to click near it unless they want to change it. I was hoping to have the same in FieldMaps. Every Click counts!

‎11-23-2023

Hi, I'm looking to have the current date in a form with also the option to click in to edit it. I've been able to add the current date with now() expression however, in the form it won't allow me to click in to edit it if needed. In the form properties if I tick 'Allow Editing' it says it must be disabled when there is a calculated expression. Does anyone know of a way to have both, like it is in Survey123. Thanks

‎10-05-2023

Thank you @Ismael, This is exactly what I needed and works a treat.

‎10-05-2023

Thanks for replying Tyler, I'll have a look at those links, ideally I'd rather not use repeats if I could get the data in the same record. I got it working with Ismael's spreadsheet.

‎10-03-2023

Isn't that the x and y of where the point was placed on the map rather than where the survey was sent from?

‎10-02-2023

Hi, I'm wondering is there a way to get the coordinates of where the survey was completed as this could be in a different location to where the point is placed on the map. Thanks Rachel

‎08-29-2023

This would be really useful, any sign of this happening?

‎08-15-2023

Thanks, I got around it by creating a new gallery for the second group, as I wanted everyone to use the Map Portal. So although everyone can see the thumbnail for the gallery there is no web apps visible within it, if they don't have permissions to see it.

‎07-20-2023

Hi, I have a map gallery on portal that only a certain group can access, within that gallery I have one mapviewer shared with that group. I'd like to add another map viewer to that gallery that is shared with a different group of people. Is this possible because both mapviewers have to be shared with the gallery which will have both sets of groups accessing it. Essentially what I'm looking to do is have my map gallery called 'Restricted Access' contain different mapviewer that different groups can access. Or is there a different way I need to set this up? Thanks Rachel

‎07-17-2023

Hi @MobiusSnake , Thanks for that, I'm just going to force the user to complete all the questions. Regards Rachel

‎07-11-2023

Ah thanks @MobiusSnake , I'd updated the dollar signs but didn't update the xls sheet. I've attached the xls with the updates you mentioned but the calculation still doesn't work for me. I'm on version 3.18.123. Here's what I get below. RachelScott_0-1689079158337.png

‎07-11-2023

Hi, I have 6 select from one list type question where the possible answer is +1 or -1. I then want to add the answers from these. But rather than adding the integers in a calculation it just adds a 1 into the sum box. e.g. -1111. If I try setting the bindType field to Int then it says Error converting XLS form. I'd appreciate any help. Thanks Rachel

‎06-01-2023

Hi Jennifer, Thank you so much for your help. I've finally got there. The first question, when I put in 0 as the default it still wouldn't work but I found a thread that said to add the coalesce () function and that worked. Survey123 Calculations not calculating - Esri Community So my formula is: coalesce(${hoursworked1},0)+coalesce(${hoursworked2},0)+coalesce(${hoursworked3},0)+coalesce(${hoursworked4},0)+coalesce(${hoursworked5},0)+coalesce(${hoursworked6},0) For the second question, your formula's worked great, just when I changed the field type to 'hidden' the field type changed to boolean rather than decimal even when I had bind::esri:fieldType set to esriFieldTypeDouble. I discovered I also need bind::type set to decimal on the hidden fields. It's working like a dream now. Thanks again for you time. Rachel

‎05-25-2023

Hi, I'm trying to create 2 calculations at the bottom of my form for totalhours and totalunsocialhours. 1. The first is totalhours, the formula I've tried only works if all the 6 fields are filled out which won't always be the case. How do I allow only if it's filled in? ${hoursworked1}+${hoursworked2}+${hoursworked3}+${hoursworked4}+${hoursworked5}+${hoursworked6} 2. The second is much more complicated. There are 3 time periods to choose from in a drop down list 12-8am, 8-6pm, 6-12pm. If either 12-8am or 6-12pm I want to add the hours. if(${timeperiod1} 12-8am or 6-12pm then add {hoursworked1} if(${timeperiod2} 12-8am or 6-12pm then add {hoursworked2} if(${timeperiod3} 12-8am or 6-12pm then add {hoursworked3} if(${timeperiod4} 12-8am or 6-12pm then add {hoursworked4} if(${timeperiod5} 12-8am or 6-12pm then add {hoursworked5} if(${timeperiod6} 12-8am or 6-12pm then add {hoursworked6} But again all 6 may not be filled out, there may be any between 1 up to 6. I'd appreciate any help with this. Rachel

Online Status	Offline
Date Last Visited	‎07-09-2026 02:47 AM

My Ideas

Latest Contributions by RachelS

Re: How to edit the current date and time

Re: How to edit the current date and time

How to edit the current date and time

Re: How to get the coordinates of where the survey was completed?

Re: How to get the coordinates of where the survey was completed?

Re: How to get the coordinates of where the survey was completed?

How to get the coordinates of where the survey was completed?

Re: Confidence intervals for Ops Dashboard

Re: Restricting access to mapviewers in Portal

Restricting access to mapviewers in Portal

Re: Adding integers for a select One from list type question giving error

Re: Adding integers for a select One from list type question giving error

Adding integers for a select One from list type question giving error

Re: Calculations in Survey123 connect form

Calculations in Survey123 connect form

Analysis Widget not showing updated data

Re: How to edit the current date and time

Re: Show/Hide Columns in Table Widget for Export t...

Re: No Layer List option in webmaps

Re: No Layer List option in webmaps