"e want to compare the field entered by the user with data from an Excel file.
The form should be positive if what you enter matches a line in the Excel file.
Is something like that possible? Can you help us with that?
This should be possible with our GP Populate Anything Perk and GP Google Sheets Perk. However, you’ll need to import the Excel file into Google Sheets and use that as the data source for your setup. You’ll need the two perks above to connect Gravity Forms to Google sheets to check if the value entered in the field, matches a value in a specific column of the Google Sheets. If there is a match it would return a value to confirm and if there is no match it will return blank.
Please check out the documentation, for more information on how this works. If you have any questions, you can contact us via our support form so we can assist you further.
Best,
1 Like
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.