Relação entre relatorios

  • arthuraureliops
    Perguntado em 23 de outubro de 2023 às 15:20

    Boa tarde.


    Gostaria de saber se é possível criar um campo de selação dinamico de acordo com outro formulário.


    Meu case é, meu usuário irá cadastrar planos de viagem, Ex: Viagem p/ SP


    Em um segundo momento quando o usuário quiser informar as despesas que ele teve em sua viagem, ele irá preencher um formulário de reembolso, e neste formulário deverá informar referente a qual viagem. Neste caso ele iria pegar o dado do outro relatório para exibir no menu suspenso.

  • Rica Support Team Lead
    Respondido em 23 de outubro de 2023 às 20:30

    Hi Arthur,

    Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Unfortunately, it is not possible to dynamically add dropdown options based on the answer they provided on another form. You may want to use a Short Text element for the Trip field and the Spreadsheet to Form widget in the Reimbursement Form. This widget will auto-fill a field using the data from an Excel or CSV file uploaded to the widget. All you have to do is download the submission data of the first form and then upload it to the widget. Once the user enters a correct Unique Code (this can be their name or another field), the widget will automatically autofill the Trip field in Form 2 with the data they enter on Form 1.

    Give it a try and let us know if you need any help.