Importing hidden excel sheet into filemaker
Hello guys! I'm new to filemaker pro. I created an excel file that has users fill out a form. Once they press the submit button, the form info is converted into a second sheet in the same workbook. It gets converted to a row format so it can be synced with filemaker. However, that second sheet is hidden from all users and requires user to enter a password. It's not a workbook password lock but a script that basically makes the sheet visible if the correct password is written. My client wants to make a script in filemaker that will import that info automatically. Is it possible to import a worksheet that is hidden in excel into filemaker?
Yes. Just select that sheet on the import