Is it possible to edit the form/submissions by editing an Excel file?

  • SVdPPTOHouston
    Asked on August 16, 2018 at 5:35 PM

    We previously us GoogleForm and I was able to manipulate the excel in real time so when I get a situation like the "limit available" and they decide they do no want that spot anymore, I was able to delete it in the excel and the limit is put back on the form again.

    I would like to edit in real time when people call me and say I accidentally added something I don't want or I would like to add something to the registration I already submitted.    

  • Kevin Support Team Lead
    Replied on August 16, 2018 at 5:47 PM

    As I can understand, you basically need to be able edit the Excel report or a spreadsheet and submit that changes to the form, so when you view the form using the URL those deleted fields on the Excel/spreadsheet file are not appearing either. 

    Please note that this would be a bit tricky to implement since JotForm will need to be connected to the Excel sheet, I'm not sure if in the case of Excel the changes can be submitted to an online server via an API, but in case of Google, they are able to easily connect their forms with the spreadsheets since they are theoretically hosted in the same place. 

    We may however escalate this as feature request to our second level, but we cannot provide an ETA or ensure this will be implemented, but we will keep you updated via this thread. 

    Thanks.