Automatically update list

Hi,

I would like to create a form for my 5 branch managers so that they can place their weekly order to me directly.

The issue is that we are working on the list of the products and we change a few details every week, as a result it is a pain to send new order forms every week

Do we have the possibility through a widget to update an Excel file with approx 300 products, probably 5 columns ?

Hi D,

Thanks for reaching out to Jotform Support. I understand what you’d like to do, I’ll need a bit of time to work out a solution. I’ll get back to you as soon as I can.

Hi D,

You can use the spreadsheet to form widget. Please note that there are limitations and requirements for a spreadsheet to form widget to work. It's also not possible to automatically replace the Excel sheet in the Spreadsheet to Form widget with the updated one. You have to manually re-upload the updated spreadsheet. I know you haven't created your form yet, but can you send us the .xlsx file you're trying to upload so we can provide the best solution for you?

As soon as we hear back from you, we can move forward with a solution.