- procesosAsked on May 14, 2016 at 12:36 PM
JotForm team would like to know if there is any alternative to simulate through some widget or application form or another deemular buscav Excel function in a form.
I remain attentive to your comments, thank you very much,
- BorisAnswered on May 14, 2016 at 01:36 PM
We do not have a VLOOKUP function available on our forms, but depending on your needs, you may want to use our Data Grid widget:
Data grid widget allows you to present data on your form in a grid/table, which is sortable by clicking on the header of any column, and it also has a filter bar at the top, as can be seen on the demo form:
On the other hand, if you were looking to perform VLOOKUP-like functions on the data that your users have submitted, you may want to export your submissions in Excel format and use the VLOOKUP function of your spreadsheet software:
Similarly to the above, you can also forward your submissions to Google Spreadsheets, and then perform the Excel functions there: