I have a separate excel spreadsheet for every job opening posted on my site — for candidate submissions to be populated into.
The candidate submission form contains all the necessary data to be able to target the specific spreadsheet by its file name (using a “Custom” input versus one of the radio options for existing files under “Spreadsheet”). No matter what I put there for the “Custom” input, the next step (Worksheet) always shows “Unable to load choices. We're having trouble loading 'Worksheet' data. The app returned "Invalid request".”
...For “Custom” I’ve tried typing in the file name itself, I’ve tried typing in that ID that appears below the file name in the options under “Spreadsheet”. The only way to get the 'Worksheet' data to return Sheet 1 {000-000...etc} is to click the file name under Spreadsheet (vs “Custom”), but I can’t do that because I need the zap to target a worksheet based on the form submission.
Perhaps there is a specific syntax to making a “Custom” input be able to find a spreadsheet? Or maybe I can use some sort of middle Zap I can use to find a spreadsheet?
Any ideas?
