Latest Contributions by DougBrowning

You are using YesCount at the beginning but in the loop you have yesCount.  That could be it. But as posted this will all break if someone deletes a record in the middle.   ... View more

The description of the form and such in Connect get wiped.  Just add them back in. ... View more

Yea its a no. Some things You can use AGOL Assistant to swap out the Dashboard data sources I think.  They also were talking about a way to flip the sources but not sure its out yet? Before you do anything export a GDB of the service! You can let it wipe the service and then append the old data with Pro from the export above.   You can make an all new form then copy over with Pro from the old service directly.  This is usually a good plan since you can time a decommission of the old form.   You can point the old form to the new service but no real point in that. This is a major schema change so not much way around it. ... View more

I kind of got it working by setting the new text then resetting the width.  With 2 lines the fonts can end up being different but its closer at least. thanks ... View more

Any way to scale the font size of a text element when I swap out the text in script?  I got it to recenter on text change by setting the anchor but if I add more text then my saved layout has it runs off the page and does not adjust the font size at all.   title = layout.listElements("TEXT_ELEMENT",'Years')[0] title.text =    I can change the font size to a set number but that would be just a guess based on the char limit. DougBrowning_0-1730848521388.png   ... View more

For me it is changing the text in a text element.  I have it set to Align Center in the Layout but if a change the text out in script it does not recenter at all so it looks terrible.  What is the point of being able to change the text if it does not realign?  I must be missing something.   ... View more

No and I have been asking for years.  My idea is that now that the lists are in the SQL lite DB add a counter each time its picked.  Then sort the list by that.  Would be so cool!  A true "smart form" that learns over time.   In our old app we had this "same as last" button and it made data collection so much faster.  Probably the biggest user complaint for us.  Our species list is 8,000+ items and every single time the user has to tap the box, start typing, then pick.  Like just give me another one.  On a line we tend to see the same species over and over so it would get the collection time way down.  I have tried dozens of way to solve it but none worked. In fact I would say 123s biggest downfall is how slow it is to collect data.  Too many taps and no way for it to learn, no way to copy repeats, no table looking repeats, etc.  It is rather clunky really.  I posted a whole list of ideas to make it faster in the past.  Hoping the new app in .Net will have more options. ... View more

I am not sure it will store a NaN in it actually.  I would try changing Q1 to string and see what it gives you. ... View more

123 is built on a completely different platform than any other Esri tool so this is probably not possible. Also they try to follow the internet open source XLSForm spec.  https://xlsform.org/en/  ... View more

Are there any spaces in the csv file name?  Does the case match exactly?   Next look at the csv in Notepad vs excel.  Then special chars can jump out at you. Next also in Notepad look for trailing commas.  This comes up a lot and will break it. For example  one, two, three,,,  Will break.  You can remove them manually or in Excel pick the last few empty columns and delete them and save.  Does the trick usually. Hope that helps ... View more

You may have some luck making a join view and then exporting from there.  But I don't think that will work in the 123 tools.  Unless you build a dummy 123 form off that join.  Not sure that join will dynamically update though - which is always a pain.  Really wish they would add that to AGOL. ... View more

The thing that takes the longest seems to be images that we use for help.  We have forms with like 60 images in some.  We took a lot of time to reduce the file size as much as possible using online jpeg reducers.  Helped a lot and no loss in quality for most images. Also being off of VPN to get full internet speed can help if that is possible for you. Other times it just hangs and times out for no real reason. Hope that helps a little ... View more