pull data from related table into survey

435
1
Jump to solution
05-25-2023 03:56 PM
CoreyWilliamsESRIAccount
New Contributor II

Is it possible within Survey123 to surface the username of who created each repeat?  I am looking to concatenate then join, outside of the repeat, the data from a select one question, the username and open text.

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
ZacharySutherby
Esri Regular Contributor

Hello @CoreyWilliamsESRIAccount

Within the repeat you can add a question that uses pulldata("@property", 'username') in the calculation column. Anytime someone adds a new repeat value the username will be extracted and added to the repeat record. You can also set the calculationMode to whenEmpty to ensure the calculation only runs when the repeat is added ensuring the value isn't updated if the repeat is updated. 

Thank you,
Zach

View solution in original post

0 Kudos
1 Reply
ZacharySutherby
Esri Regular Contributor

Hello @CoreyWilliamsESRIAccount

Within the repeat you can add a question that uses pulldata("@property", 'username') in the calculation column. Anytime someone adds a new repeat value the username will be extracted and added to the repeat record. You can also set the calculationMode to whenEmpty to ensure the calculation only runs when the repeat is added ensuring the value isn't updated if the repeat is updated. 

Thank you,
Zach
0 Kudos