I have an application where I need users to input data sequentially every time a new unit is added to the system. Prepopulating answers doesn't work, because the user input number has to be a new unique value. So I'm just trying to make a list of old answers for review by the user to input the next value sequentially.
I'm essentially looking to be able to use the search() or pulldata() function in a note. I was hoping that someone out there might know of a solution.
The search() appearance wouldn't be ideal for this workflow as it's intended for select_one or select_multiple question types.
With that information you could prepopulate the answer as you can sort the unit ID's and add one to the highest value.
Using the Object ID or post processing the data will ensure that each record in the sequence is unique.
Thank you for replying Zach,
I've gone with using the ObjectID, simplest easiest way to work this. I really appreciated the advice.
However, I think I still have a use case. I have a survey for vendors to register vehicles, and some of these vendors have more than one vehicle. I'm looking for a way to show previous answers (ideally selectable) so that if the form gets filled out twice I don't end up with "Roses Roses" and "RosesRoses" for the same vendor. At the same time, if the vendor is new, and hasn't filled out the survey before, they still have the option to input their name. Kind of like how excel reviews value's in the column above and populates value's as you type.
I have this worked out using two fields, but that leaves room for user error.