Hello,
I've been asked to develop an auditing tool for users in the field that must be user friendly on a mobile device. I thought Control Center and WorkApps would be the perfect solution. Users can access a user friendly intake form from WorkApps and then the audit would be auto-provisioned into the WorkApps project list. From there, the auditor can access their new project/audit.
I am running into a problem with formatting. Not only is the format totally different, but WorkApps is including hidden columns on the sheet.
The "Reporting" checkbox is a helper column I have hidden in the sheet, and you can see that when accessing the sheet outside of WorkApps, there is no helper column, but within WorkApps there is.
Screenshot of what the sheet looks like when accessing outside of WorkApps:
Screenshot of what the same sheet looks like when accessed from the "Project List" inside of WorkApps:
Do you have any advice on how to make the auto-provisioned sheet not show hidden columns in WorkApps?