Latest Contributions by DougBrowning

I have a constraint on an Integer field where it must be 0 if another field is No and > 0 if Yes. if(${FlowPresent}="No",${ThalwegDepthCM} = 0,${ThalwegDepthCM} > 0) (note I had to write out the field name since .>0 did not work) If I pick No then enter a value that is not 0 then the constraint fires and stops me. But if I leave the field totally blank then it lets it go through. Is this a bug? I also tried testing string length and that lets it go also. if(${FlowPresent}="No",${ThalwegDepthCM} = 0 and string-length(${ThalwegDepthCM}) != 0,${ThalwegDepthCM} > 0) and tried string-length(${ThalwegDepthCM}) > 0 How can I fix this? Note I cannot use relevant since the users sometimes do not do the form in order. Thanks

It seems that my repeat count is overriding my relevant and giving me a blank repeat row. I have my relevant and repeat count like this on my begin repeat (relevant first). This says if it is a X transect to not show this repeat at all. I am getting a phantom all blank row in the repeat on X transects. I also tried to add a statement to set repeat count to 0 on a X transect but I still get the phantom row. if(contains(${Transect}, "X"), 0, if(${Transect} = "K" or ${ThalwegType} = "Core", 1, ${MidThalweg})) Using 3.12/3.11 Any ideas on how to get rid of this phantom row? Or is this a bug? Thanks

Sorry I have never used Inbox. I do have issues where calcs do not work when opening a draft however. Has been a big issues for us.

Thanks but this does not cover what happens in the GDB export. I do not see NaN being stored at any time. thanks

I was wondering on 32. The big reason I was excited about this change is getting a little more life out of these Active 2s. It is over 22 seconds to load the form. I did try an Active Pro now and that seems to have cut the load time in half! 11 seconds to under 6. I will try and do some more testing tomorrow. On my iPad Pro it is so fast it is hard to tell. I will get some more testers on this. Thanks! Any thoughts on the "smart learning" list sort order? Our old app did this so users really want it back.

I tested a older device with the old and new versions but not seeing any speed improvement at all using add itemsets to database. Posted to the Beta forum. thanks

Thanks Phil. I just tested quick and the form does seem to load faster. However the autocomplete search does not seem to work right. I seem to get all choices no matter what I type in (I typed in moon and for 500+ matches it says but there is just one). In one case it worked but usually does not. Note these are still select one externals with no changes to the new style. At first glance I am not really getting how search() is different than choice filter. Maybe that I can use text? Can I set the csv file name to a field that I can calc? I will have to play with it a bit. Is it yet possible to dynamically sort the list? I would love it if the last item picked went to the top of the list, and that this grew over time. For example if I have 50 repeats the list changes on each repeat load where the order is now repeatchoice3, repeatchoice2, repeatchoice1. It would be really cool if this then persisted across the form. Since you are storing this in a DB now you could resort it in the DB as the choices are made. Any plans on this? thanks

Is there a doc anywhere that talks about when a field is Null and when it is Empty string? It my testing I have seen that for a Hosted Feature Service if a user leaves a field blank, or if it is not relevant, it it gets empty string. This is true even for Int/Dec which is not possible in most Arc. But when you download that data to a GDB int and decimal convert to Null, but strings stay empty string. Dates not sure yet. For now I have been adding code to my scripts to check for both "" and Null. I want to make sure I know the pattern correctly. Will there ever be a way to have strings be Null? Or would this need to be post processing to match our legacy data. Thanks

Bump to see if this is a logged bug yet? thanks

The warning box on a publish dialog is so small I cannot actually read the field names. Plus there is no way to resize it. Can you please make it so it can be resized? It has limited use if I can't read anything on it. Thanks!

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by DougBrowning

Constraint allows blank values to go through on Integers

Repeat count is overruling relevant?

Re: Survey123 Tricks of the Trade: Repeats

Re: Documentation on Null vs Blank

Re: Can external_choices use more than one lookup column? (and query speed)

Re: Can external_choices use more than one lookup column? (and query speed)

Re: Can external_choices use more than one lookup column? (and query speed)

Documentation on Null vs Blank

Re: Survey123 Select_multiple question unable to unselect items in field app

Can the publish dialog box have resize option please