Latest Contributions by DougBrowning

We are starting to get a lot of reports on this crash on a Tab Active 2 as well.  Seems like the last update maybe.   ... View more

I have got grids and pages to work together.  You have to use the style theme-grid pages.  Then any place you want a normal page use a w1 and then each question will take up one line.  It will still have boxes around everything but the team said they are working on that. For the user seeing repeat issue what I do is have a join() that sits outside the repeat.  This way the user can see the list of everything they have entered.  I also use this for a unique check to make sure they never pick the same thing more than once.  Only real trick is to take a few chars off the end of the join() to check (otherwise it will see itself all the time). Hope that helps. ... View more

All relevant fields that are not showing should always be "" empty string.  (note there is another bug where a default will be added to a relevant that is not showing). This was not always working before but was fixed in 3.5.  There was a post about this when 3.5 came out but I cannot find it.  There were also some other posts about it today. Using hidden or calculate is the way to go. ... View more

Looks like your Excel validation got messed up.  This happens when you copy/paste cells and forget to use right click Paste Values.  It is just using simple Excel constraints looking up via the types tab. Options are  Fix the validation by looking at another cell. Copy paste (not using paste values so you get the validation to come over) from a cell that does work then type your value back in. Start a brand new form, copy all the old form in using Paste Values, then save over the top of the original.  This is what I do to "update" my old forms when new features come out. Turn off Excel validation for that cell.  I do this a lot when using grid or it will yell at you constantly.  I also use this to get rid of the annoying yellow popups. ... View more

Once you sync Collector could show you all of them.  But if you are all offline at the time then no since well you are all offline. We have some people here working on a app that uses the 123 API to query the tablet database.  But that would still not help you offline to get data tablet to tablet. ... View more

When a relevant is hidden it will always be "" string.  No way around that.  (Except for the default values bug.) You could use the hidden type or something maybe?   ... View more

Why not use the globalid?  And/Or GUID.  Not sure if you can calc a GUID in a form.  Objectid changes all the time on export and import. In our old Access DB they created unique keys bases on date, time, milliseconds but I never loved that way. ... View more

Sorry I think I am not getting the logic then.  If you just want to calculate a value then a select multiple is not needed - just calc it.  Do not need a drop down if you are just calcing the answer. I also do not like select multiple because it will store values as A,B,C in a list.  This makes it hard to use later.  But if you want it that way a calc that concatenates the 3 fields would work.  So minor has a calc of if(minor>0, "Present", "").  The last field is concat(minor, etc).  But data wise I would have 3 fields that are just Yes/No for each.  Must easier to symbolize and such. I am also not sure why if you have a youth count field you need a present field.  If it is > 0 then present.  Seems like double data. Sorry not sure I get it. ... View more

You need to use selected(${Customers},'Other') There are many posts about this - see here https://community.esri.com/thread/184917-relevant-field-syntax-for-multiple-choice-questions  ... View more

I suggest writing Ismael.  I did and it sounded just like what you wrote - but it could help to hear it from more than just me. ... View more

Could not agree more.  We have lost a lot of time and money in the last year due to bugs that are often many years old.  In years prior 123 has always been good about getting these core ones fixed but they seem to concentrate more on the new toys lately. I have asked for sticky post or known issues lists or something.  Bugs happen - that is life.  But to ignore them for years and not tell anyone is not good programming.  It makes us that push it look bad. I suggest writing Ismael as he has been responsive to me on these issues.  The team needs to hear more about how big of a deal these things are.  It may seem minor with a few forms or a few users but when you are at scale with hundreds of forms and thousands of users it is a whole different story. ... View more

Arc never ever auto updates any field.  I personally got away from static lat long fields since they are always out of date and you have no idea what projection they are in sometimes.  You can always ask Arc for the lat/long so why store it. For use in apps I use Arcade to calc the lat/long dynamically if I need it for display or for sending to 123.  I have this code let me know if you need it. ... View more

Just make it a calculation instead of a dropdown using Pulldata.  No need for the drop down if you know the answer. You could also use Collector for the existing feature and just pass the ID to 123.  Keeping a list of assets up the date in the form will become a pain.  Plus then you get a map to find the location. ... View more