Complete previamente los campos del formulario con datos de una tabla con fórmulas

Es posible obtener datos de otras tablas con formulas como en excel VLOOKUP? para poder generar nueva información?

Hi joslrv,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so 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 Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, to clarify, did you mean you're looking for a feature to prefill a form with data from another Jotform Table with formulas, and the data to be prefilled on the form should be the generated results from the formulas in Jotform Table? If yes, this feature is currently not available in Jotform.

If what you meant is importing data from an external sheet, which has formulas, and the imported data should be the generated results, this currently not possible as well. I suggest you take a look at the Spreadsheet to Form widget, which allows you to populate your form fields with data from an external Excel Sheet. But the external Excel sheet should already have the generated formula results before uploading the sheet to your Jotform form.

If that’s not exactly what you’re looking for, can you explain a bit more, so I can help you better?

Once we hear back from you, we'll be able to help you with this.