Pulling new information into Sponsored Member applications
We have a bespoke version of our Sponsored Member application form for each sponsor. The link has a query string at the end for the Crossref member ID of the relevant sponsor. We have a data file (Data > Join_sponsored > sponsoring-orgs) that maps the Crossref member ID to a specific sponsor's name.
So, for example, if you go to https://www.crossref.org/_apply/sponsored-member/?id=14661, the system is able to identify via that data file that the query string at the end means Lund Univesity Library, because we have the following in the data file:
"id": 14661, "name": "Lund University Library"
Lund University Library then automatically displays as the name of their sponsor on the form that the applicant fills out on the website. This information is then captured in the formspree results, and fed over to Zendesk in the ticket that we create for that application.
We also want to be able to automatically capture the Intacct ID of that sponsor. We don't need it to display on a specific field on the form that the applicant fills out on the website, but we do want it to end up in the Zendesk ticket that's created from the formspree results.
If we add "Intacct ID": to each listing in the data file, would we be able to collect this information?
So for example, could the listing in the data file for 14661 say: "id": 14661, "name": "Lund University Library" "Intacct ID": UBLU00"
And this means that in the info we collect in formspree, we collect "Intacct ID: UBLU00" for any applications on that specific link? So this information can then be included in the relevant Zendesk tickets? (And so on for all the other bespoke links?)