-
GATG_ATEGPerguntado em 29 de janeiro de 2025 às 13:29
Quando utilizo o Widget de Planilha para Formulário ele não preenche os dados da minha base nos campos de Entrada Mascarada, preenche apenas os campos básicos.
Como posso fazer para que o campo de entrada mascarada receba o dado da minha base de dados inserida no Widget de Planilha para Formulário?
Link da planilha usada de base de dados: https://docs.google.com/spreadsheets/d/1EF7B9EHXD9XKFU2rBUx0qACVhLzQpIVs/edit?usp=sharing&ouid=103274337106690474664&rtpof=true&sd=true
Page URL: https://form.jotform.com/250213332629045 -
Raymond Jotform SupportRespondido em 30 de janeiro de 2025 às 04:17
Hi GATG_ATEG,
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.
Unfortunately, the Spreadsheet to Form widget does not work with the Masked Input widget. However, we can create number fields to your form where the data from your spreadsheet will be pass to. Let me show you how:
- In Form Builder, click on the Add Element button on the left and select the Number to add it to your form.
- Next, rename the number field to Valor 1, then add another number field and rename it to Valor 2.
Now, we can pass the value of the number fields to your masked input widget. Let's do it:
- In Form Builder, click on the Settings tab on the orange navigational bar at the top and select the Conditions option on the left side pane.
- Next, hover your mouse over your condition and click on the Pen icon.
- Update your condition form fields with the new number fields you've created using the Add Field button and click Save.
That's it. Here's how it would work:
If you're trying to perform calculation and add the percentage suffix to your output, we can simply use the Form Calculation for that. Let me show you how:
- In Form Builder, click on the Add Element button on the left and under the Widgets tab, select the Form Calculation widget to add it to your form.
- Next, in the Form Calculation settings on the right, use the Add Field and mathematical operators to perform your calculation. Strings like texts can also be added by using your keyboard.
- Once done with the calculations, click the Save button.
My example would work like so:
That's it. We also have a guide on How to Perform Calculations Using a Widget that you can check out. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?
Give it a try and let us know if you need any help.
Sua Resposta
Something Went Wrong
An error occurred while generating the AI response. Please try again!