The data from the column in my spreadsheet that I set up is not populating. It shows in the preview, but does not populate the form. The field that I am populating contains a formula to add columns A and B so that the name and email address appear in C. I highlighted the row and used the Remove Duplicates function in Google Sheets to ensure there are no duplicates. This is an example of what the data would look like:
"Last, First", <na...@emailaddress.com> and this is an example of the formula: =CHAR(34) & A93 & CHAR(34) & ", <" & B93 & ">"
Any help would be greatly appreciated! I've been using Form Ranger for several years and this is the first issue that I have had with it not working as expected.
Thanks!