Is there a formula that can be used when utilizing Integromat to send an email that pulls the label value, not the name value, from the choices tab in the spreadsheet for Survey123 Connect? For example, the instance_name field on the Settings tab of a spreadsheet can utilize a formula to extract the label, not the name, and display this in the Inbox. In the image above, the Inbox of a Survey will display the Code Officer's actual name, not their "dumb" name as stored in the database, listed in the 'name' field of the spreadsheet. This is what I've currently put together using the Office 365 Email trigger: The field values for 'Codes Officer' and 'Type of Violation' being sent in an email are displaying values that are unintelligible. Is there an evaluator that pulls the label instead of the name?
... View more