topic Re: Join time field type within a repeat to note field in ArcGIS Survey123 Questions

Join time field type within a repeat to note field

GeorgeClutterbuck — Fri, 05 Jan 2024 10:54:41 GMT

I am recording a number of observations within a repeat. I can then create a summary of the results using the join calculation for most fields, but I can't create a list of times from the time field. How would I go about joining them to a new field? I have attached a screenshot which will hopefully be clearer. Thanks.

Re: Join time field type within a repeat to note field

DougBrowning — Fri, 05 Jan 2024 15:36:37 GMT

My guess is that it not being a string is causing the issue. Have you tried a hidden field that uses this formula and then do a join on that field? You can sent the bind esri column to null so these temp fields stay out of the feature service.

format-date()

Fits an existing date or time value to a defined format.

format-date(${previous_time}, '%H:%M')

Hope that works

Re: Join time field type within a repeat to note field

abureaux — Fri, 05 Jan 2024 18:50:56 GMT

@DougBrowningIs correct. It's a super strange limitation, but you cannot use a date, dateTime, or Time field directly in things like join().

You first need to convert it using format-date(). For example, this is what I am using to display my time in a summary section outside of the repeat using join() on the calculate: