Highlighted

Web Form Export Data field names - can current field names be applied to previously filled forms?

New Here ,
Aug 10, 2020

Copy link to clipboard

Copied

Six versions of student financial aid web forms are filled out and signed by up to 5 people. The names of the fields were automatically named as User field 1, User field 2 and and so on but were later renamed to better indicate their content, after some of the forms were already in process. These forms have up to 75 fields. The data from the forms needs to be exported to feed another system. The problem is that some data fields have the original field names and others the newer names. When they are exported each version of the name goes into a separate column and everything is sorted alphabetically. In addition, the data entered by each participant goes in a different line in the data file. Needless to say, it is tough to determine what columns make up the data from one form.  The agreementId value identifies a form, but up to 5 lines share that same value and have data in different columns. Can all the data be re-exported with the current field names to obtain consistent columns? 

Topics

Web forms

Views

17

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Web Form Export Data field names - can current field names be applied to previously filled forms?

New Here ,
Aug 10, 2020

Copy link to clipboard

Copied

Six versions of student financial aid web forms are filled out and signed by up to 5 people. The names of the fields were automatically named as User field 1, User field 2 and and so on but were later renamed to better indicate their content, after some of the forms were already in process. These forms have up to 75 fields. The data from the forms needs to be exported to feed another system. The problem is that some data fields have the original field names and others the newer names. When they are exported each version of the name goes into a separate column and everything is sorted alphabetically. In addition, the data entered by each participant goes in a different line in the data file. Needless to say, it is tough to determine what columns make up the data from one form.  The agreementId value identifies a form, but up to 5 lines share that same value and have data in different columns. Can all the data be re-exported with the current field names to obtain consistent columns? 

Topics

Web forms

Views

18

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 10, 2020 0

Have something to add?

Join the conversation