Latest Contributions by Trippetoe

Hey @abureaux . Thank you for your suggestion. That's a clever workaround that i think will get mostly what i was after. ... View more

Hello @abureaux . Thank you for sharing your ideas. If i understand your suggestion correctly, in my case it doesn't seem feasible to do a calculate per option.  My list of options are coming from an AGOL standalone table via the 'autocomplete search()' function, the options are dynamic with not infrequent changes to the underlying list of options, and there are upwards of 50 or so options. To me the suggested approach doesn't seem practical for the use case. Have you seen any additional documentation from Esri (or from other users) that gives details on how to construct a more complex 'where' clause when doing an 'autocomplete search()'? ... View more

Hey @DougBrowning  Thank you for your suggestions. When i shortened the field name that is referenced in the choices worksheet, i was able to republish the survey without that error. That approach seems much more simple that expanding the field size in the feature service. we've got many years of data in the service and i don't want to recreate/republish all of that. It seems like maybe the Esri team chould rethink either how the search() functionality is setup/configured within the xls form or reconsider the form validation process when search() is being used. It's reasonable that the length of a field name could be longer than the values going into the field. Or maybe its just me 😉 ... View more

i think you are on to something.  Yes, the question is a select_one. I am using the 'search()' functionality to populate the field based on input from a previous question. And the 'search' column name used that gets set in the choices worksheet is longer than 10 characters.  I'm gonna try shortening that to see what happens.   ... View more

Using a Calculate as the value of the searchText worked perfectly.  I didn't have as much good look changing out the autocomplete appearance for minimal. The app behaved the same regardless of that setting. But I'm calling this a victory for now and moving on to the next hurdle. Thanks again for your help. It is super-appreciated! ... View more

Hi @abureaux  It has been a fun adventure learning more about the search() functionality. Thank you for pointing me in that direction. Broadly speaking, I think your suggestion will work fine. I am seeing two bits of functionality, though, that are a bit nettlesome.  When the survey loads and before any Company is selected, all possible Work Order Numbers are available in the dropdown. Once a company is selected, the list is filtered as expected, but i'm a bit bothered by having all work order numbers present prior to selection. I certainly could hide the Work Order question until a Company is selected, but the question is 'foundational' to the survey and i'm a bit hesitant to hide/display the question depending on the state of the Company selection If i select a company, then make a Work Order Number selection and then clear the Company selection, the selected Work Order Number remains visible. Once i make a new Company selection, the selected work order number is cleared and all is as expected. I would expect the Work Order Number to be cleared if the Company  selection is cleared Those two items aren't enough to prevent me from using the Search() functionality, but just troublesome enough to slightly irk me.  Do you have any suggestions for making the Work Order Number list blank until, and only if, a company name is selected? ... View more

Hey @abureaux  Based on your suggestions I'm gonna take a deeper dive into this, but before i got lost in that I wanted to Thank You for your sharing your time and knowledge. I really appreciate it. I'll get back to you later with results from my fiddling around.  ... View more

Hi @abureaux  Thanks for your suggestion, but it doesn't work as i need it to. It seems that your formula detects whether or not a value has been selected from the Work Order Number question. I need a formula that can detect whether there are any options available in the Work Order number question. Its possible that there are no options in the Work Order Number questions based on the filter value in place because of the previous question's (Company) answer (hopefully that makes sense!) ... View more

Perfect. Thank you! A minor note is that to see the changes in Experience Builder, i had to close and re-open the experience to see the changes in the map.  ... View more