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.
Is there any other was to accomplish appending text to an existing field while showing the current value of that field?
Thanks!
Solved! Go to Solution.
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.
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.
Were you ever able to figure this out, @MichaelKnapp? I am trying to accomplish the same thing for our field notes. Thanks!