Creating the back the ID cards was an interesting challenge.
Working in conjunction with the memberships team,
I designed the back of the ID cards in InDesign and used mail merge to designate several text boxes as dynamic fields that could then be populated from a linked Exel spreadsheet.
The fields pulled from the Excel spreadsheets supplied by membership were the ticket number, zone, seat and a scannable QR.
The spreadsheets were cleaned up and preppared before being converted to a CSV format and then connected to Adobe InDesign to batch generate PNG files for each back for each memeber.
How I made the backs of our ID cards