Form Ranger stopped working

2,389 views
Skip to first unread message

Ian McNeill

unread,
Jun 14, 2021, 4:31:28 AM6/14/21
to NV Form Ranger Add-on
I have a simple form which access a Google Sheet containing a list of names. The form has used Form Ranger successfully for a couple of years but yesterday stopped working. I have deleted the range referenced and reset the column containing the names, but although the preview panel seems to reference the correct data the form does not contain the required dropdown list of names.

I have tried copying the data to a new column, bit that didn't work either. 

My user key is 

AEMJz5yRaR41KxyXoasLx94r6VW1h7GBfq0hiJwCfj5Cyxq2kTOOLYEE/fBSUqo2g93LStn04+zW

Can you help?

Ian

Joseph Schmidt

unread,
Jun 14, 2021, 7:37:32 AM6/14/21
to nv-form-ra...@googlegroups.com
Make sure you don't have any duplicates in your table. Two John Smith records will prevent the table from loading.  Use unique function on your list.




--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/0bebb86c-3f85-4dcd-9e55-707db5a3fa35n%40googlegroups.com.

Ian McNeill

unread,
Jun 15, 2021, 4:21:34 PM6/15/21
to NV Form Ranger Add-on
Changing my spreadsheet code to ensure a unique member listing fixed the issue.  Thanks for the suggestion. 

Kahire Yunus Emre

unread,
Mar 1, 2022, 3:59:05 AM3/1/22
to NV Form Ranger Add-on
This was really useful tip. Thank you

nafees khan

unread,
Sep 17, 2022, 3:49:17 PM9/17/22
to NV Form Ranger Add-on
Hii,
I am using Form ranger for the first time
But it shows Error 404 and its not working.

what could be the issue?

nafees khan

unread,
Sep 17, 2022, 3:54:38 PM9/17/22
to NV Form Ranger Add-on
succeeded in installing, but now it says ' drive.google.com refused to connect.  '

Joseph Schmidt

unread,
Sep 17, 2022, 8:08:23 PM9/17/22
to nv-form-ra...@googlegroups.com
Are you signed onto more than one account?  Try incognito window in Chrome.
Reply all
Reply to author
Forward
0 new messages