Survey123 - Appending text to existing field while showing current field text

722
2
Jump to solution
12-08-2020 02:00 PM
MichaelKnapp
Occasional Contributor

Hi there - 

We are tracking repairs in a hosted dataset via survey123. We have a "Repair_Progress_Notes" field that needs to get updated multiple times over a number of days. We'd like the Survey form to be able to show the current value of the field while providing a text box to add new text, which is then concatenated to the existing field value. I was thinking something like in the excel below, but it hates the circular reference. Capture.JPG

Is there any other was to accomplish appending text to an existing field while showing the current value of that field? 

Thanks!

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
by Anonymous User
Not applicable

Hi @MichaelKnapp,

As the error suggests, the calculation you are trying to use in both questions will not work as it creates a circular reference, this means the fields would continually keep updating in a loop that would never end.

You need to design the questions in a different way to avoid the circular reference.

Regards,

Phil.

View solution in original post

0 Kudos
2 Replies
by Anonymous User
Not applicable

Hi @MichaelKnapp,

As the error suggests, the calculation you are trying to use in both questions will not work as it creates a circular reference, this means the fields would continually keep updating in a loop that would never end.

You need to design the questions in a different way to avoid the circular reference.

Regards,

Phil.

0 Kudos
JasminePrater
Occasional Contributor II

Were you ever able to figure this out, @MichaelKnapp?  I am trying to accomplish the same thing for our field notes.  Thanks!

0 Kudos