Select to view content in your preferred language

Using repeats and copying a date field value into other date fields

362
3
Jump to solution
08-01-2023 06:22 AM
traviss
New Contributor

Hey There,

Not sure if I have this structured properly. I have a form using repeats for collecting water samples. I have sample group 1, sample group 2 which are both tables, and then a point feature class that has a globalid. the globalid is passed to the tables as parentglobalid so each submission is properly linked together.

the feature class has a date field, the sample group 1 table has a capture_date1 field and the sample group2 has a capture_date2 field (this was necessary for importing historical records as the date value was a unique field and was used for assigning the globalid in the featureclass to related tables as parentglobalid for each unique date).

In my survey123 form, I only ask the user the date once in the first repeat which is capture_date1. I then use the calculate field to assign that date to capture_date2 in the second repeat, and the featureclass which is capture_date.

If the user chooses, say July 25, 2023, it assigns that date to one record in the repeat, but the second item in the repeat, or third, etc is assigned the current date. How can I have it assign the date selected to *all* of the records for that repeat?

Hopefully this makes sense, thanks for any help

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

Could you instead have them set the date at the start of the form outside the repeat?  So move capture_date to the top, then set that at form open then inherit that in the repeats.  That should work.

View solution in original post

3 Replies
travisslack1
New Contributor III

Sorry I posted this on a different account that can't upload attachments. I've attached my XLSForm for the issue I described above in this post. Thanks.

0 Kudos
DougBrowning
MVP Esteemed Contributor

Could you instead have them set the date at the start of the form outside the repeat?  So move capture_date to the top, then set that at form open then inherit that in the repeats.  That should work.

traviss
New Contributor

Yeah I think I posted this too soon, I actually tried that right after posting this and that did the trick. I'll leave this up in case someone else does the same thing and finds this through google. Thanks