Appending records with new data in a new field?
Let's say I have a form already developed that is currently being used to collect information. Let's also say that I have another field I want to add to this form.
Is there a way to add this new data field, then upload a .csv file such that it will merge whatever information has already been collected, with new information to populate the newly-created data field? In the ideal case, there will be no loss of data or duplication of any records.
Hi Jon, thanks for reaching our and while it isn't possible to upload a CSV file to get the desired outcome, I think our Table Edit View might be able to help you transition your existing data into the newly added field.
You would setup a filter on your form to show the fields you wanted to work with (old field, and new one) and you can copy and paste from one column into the other.
An alternate approach would be to leverage the iFormBuilder APIs and do everything through code if you had the means and did not want to use the interface.
Hope that helps!
Please sign in to leave a comment.