I need help creating an app that populates data into an Excel doc
I am trying to design an app that will feature a drop-down list of "names", once a name is selected then the "next" button is enabled, then when you tap next it takes you to a page that says "where will you be tomorrow 'name'?" and has an input text card underneath for the user to type in their expected location. then there needs to be a submit button that sends the selected name, and location, as well as the date for the following day to an excel document.
If you think you can help please let me know, I have made the basic layout for the app but I cannot figure out how to send over the data.
Can/should they pick a name other than their own? If not,you don't need the drop down. Using the function User().FullName you get the name of the current user and don't need to ask about it. Just set the default value of the datacard to User().FullName instead of the drop down's selected value and then hide it, unless of course you want the user to see it.
Have you used the Excel connector and connected the form to that data source?If you have, it's only a matter of calling SubmitForm() in a button's OnSelect.