Planilha para Formulário: Atualizar o arquivo Excel baixado com um valor inserido no campo do formulário

  • welenson
    Perguntado em 16 de junho de 2024 às 13:07
    Fiquei com uma duvida, poderia me auxiliar por favor.

    https://www.jotform.com/build/241445548508057

    No formulario abaixo eu estou fazendo um teste onde trago os campos da planilha a partir de um numero de celular.

    Os campos Nome e Email vieram corretamente.

    Tenho o campo TESTE vazio, seria possivel preencher ele no formulario e quando eu enviar, o conteudo digitado atualizar na planilha do Excel?

  • Gian_D Jotform Support
    Respondido em 16 de junho de 2024 às 18:20

    Hi Welenson,

    Although the Excel file uploaded in the Spreadsheet to Form widget can't be updated as it's a static file, as a workaround, you can integrate your form into Google Sheets, then download that Excel file, and upload it to your Spreadsheet to Form widget. Let me show you how to do it:

    1. In Form Builder, click on Settings in the orange navigation bar at the top of the screen, and in the menu that opens on the left side of the page, click on Integrations.
    2. Search for Google Sheets, and click on Google Sheets.

    Planilha para Formulário: Atualizar o arquivo Excel baixado com um valor inserido no campo do formulário Image 1 Screenshot 30

    3. Authenticate your Google Sheets account.
    4. Click on Use an Existing Spreadsheet, and select your Excel file.
    5. Enter your Worksheet Name, and select all the fields you want to include.
    6. Tick the checkbox for Send Existing Submissions to the Sheet to include the past submitted data.
    7. Click on Save.

    Planilha para Formulário: Atualizar o arquivo Excel baixado com um valor inserido no campo do formulário Image 2 Screenshot 41

    Now, your submission will be added to your Excel file in Google Sheets, then you can download it and upload it to your Spreadsheet to Form widget.

    That's it. Let us know if you have any other questions.

  • welenson
    Respondido em 16 de junho de 2024 às 18:27

    Essa parte da integração eu entendo perfeitamento, o que eu precisava de fato, era conseguir trazer os dados do excel a partir de um codigo, e atualizar aquela linha no excel conforme o meu exemplo na primeira mensagem.

  • Rene Jotform Support
    Respondido em 16 de junho de 2024 às 20:42

    Hi Welenson,

    Unfortunately, all new submissions will create a new line in the connected Google Sheet and there's no option to change that. The integration assumes and doesn't check for existing submissions and updates them if necessary.

    While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

    Thanks for your patience and understanding, we appreciate it.

  • welenson
    Respondido em 16 de junho de 2024 às 20:45

    Obrigado

 
Sua Resposta