NV Form Ranger Add-on

Contact owners and managers

1–30 of 821

See example for duplicate items in the list. Read the posts starting at the above link. Google made a change and any duplicates will cause the update to fail.

=sort(unique(arrayformula(trim(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:B," "," ")," "," ")," "," ")))),1,true) will locate and remove any duplicates.

Welcome to the Form Ranger Community forum!

Before posting a new question, please use the search tool to check past discussions!

If you are reporting a bug or error, please strive for as much clarity and detail as possible, include screenshots when applicable.

This tool is free and maintained by a very small team at an educational non-profit. We rely on this community to help diffuse the support load, so if you see an issue you can help with, please do so. Thank you!

0 selected

Heal Torture Talk, … Henry Kain6

Apr 27

Form not autopopulating after submission

BEST ECSTACY MOLLY ON DECK CLICK ON OUR TELEGRAM LINK TO PLACE AND ORDER WITH US THANKS https://t.me/

unread,

Form not autopopulating after submission

BEST ECSTACY MOLLY ON DECK CLICK ON OUR TELEGRAM LINK TO PLACE AND ORDER WITH US THANKS https://t.me/

Apr 27

Apr 23

Form Ranger not populating

Never mind figured it out. Had some duplicates. On Tuesday, April 23, 2024 at 3:02:53 PM UTC-6 Sam

unread,

Form Ranger not populating

Never mind figured it out. Had some duplicates. On Tuesday, April 23, 2024 at 3:02:53 PM UTC-6 Sam

Apr 23

Basheer Khan CMINC

Apr 23

Re: [ Form Ranger Google Group] Abridged summary of nv-form-ranger-add-on@googlegroups.com - 3 updates in 2 topics

Hello, This is Basheer Khan from Cognitive Minds Inc. This mail is regarding a hot-list of my

unread,

Re: [ Form Ranger Google Group] Abridged summary of nv-form-ranger-add-on@googlegroups.com - 3 updates in 2 topics

Hello, This is Basheer Khan from Cognitive Minds Inc. This mail is regarding a hot-list of my

Apr 23

Basheer Khan CMINC

Apr 22

Re: [ Form Ranger Google Group] Abridged summary of nv-form-ranger-add-on@googlegroups.com - 1 update in 1 topic

Hello, This is Basheer Khan from Cognitive Minds Inc. This mail is regarding a hot-list of my

unread,

Re: [ Form Ranger Google Group] Abridged summary of nv-form-ranger-add-on@googlegroups.com - 1 update in 1 topic

Hello, This is Basheer Khan from Cognitive Minds Inc. This mail is regarding a hot-list of my

Apr 22

David Knapp, Joseph Schmidt3

Apr 22

Form Ranger without update: does form code change?

Hi, Joe, Thanks! I had the feeling I might be using the wrong tool. David tel: +66 (0) 83 277 5459 ‼️

unread,

Form Ranger without update: does form code change?

Hi, Joe, Thanks! I had the feeling I might be using the wrong tool. David tel: +66 (0) 83 277 5459 ‼️

Apr 22

Apr 22

Incomplete question list

Hi! Today Form Ranger started omitting more than half my form's questions from the Question List,

unread,

Incomplete question list

Hi! Today Form Ranger started omitting more than half my form's questions from the Question List,

Apr 22

Apr 22

No data In column after question populated

Hi! After several hours work on a fairly complex form yesterday, I suddenly saw that most multiple-

unread,

No data In column after question populated

Hi! After several hours work on a fairly complex form yesterday, I suddenly saw that most multiple-

Apr 22

WCM ADMINISTRATION, Joseph Schmidt2

Apr 20

See see how formranger sees the list. Google will not update if there are duplicates. That is the

unread,

See see how formranger sees the list. Google will not update if there are duplicates. That is the

Apr 20

Steve VanGorder, Joseph Schmidt2

Apr 19

One of my list is not showing

Try this Find duplicates for Formranger. Duplicates are the most common problem. This tool with

unread,

One of my list is not showing

Try this Find duplicates for Formranger. Duplicates are the most common problem. This tool with

Apr 19

Steve VanGorder, Joseph Schmidt3

Apr 18

Form ranger wont start.

Thank you@ On Thursday, April 18, 2024 at 3:04:44 PM UTC-4 Joseph Schmidt wrote: Try and incognito

unread,

Form ranger wont start.

Thank you@ On Thursday, April 18, 2024 at 3:04:44 PM UTC-4 Joseph Schmidt wrote: Try and incognito

Apr 18

Alejandra Bohorquez, Joseph Schmidt3

Apr 11

No me funciona correctaemnte la validacion

Muchas gracias !!! si tenia 1 no me habia dado cuenta, gracias El jueves, 11 de abril de 2024 a las

unread,

No me funciona correctaemnte la validacion

Muchas gracias !!! si tenia 1 no me habia dado cuenta, gracias El jueves, 11 de abril de 2024 a las

Apr 11

Cristopher Capitani, … Cristopher Capitani3

Apr 9

Form Ranger has stopped syncing.

No, each item is different Il giorno lunedì 8 aprile 2024 alle 18:24:50 UTC+2 Joseph Schmidt ha

unread,

Form Ranger has stopped syncing.

No, each item is different Il giorno lunedì 8 aprile 2024 alle 18:24:50 UTC+2 Joseph Schmidt ha

Apr 9

Megan Benay, Joseph Schmidt2

Apr 3

Does Form Ranger Only Work for Forms with One Question?

I think it should work on more than one question. On Wed, Apr 3, 2024, 4:48 PM Megan Benay <mbenay

unread,

Does Form Ranger Only Work for Forms with One Question?

I think it should work on more than one question. On Wed, Apr 3, 2024, 4:48 PM Megan Benay <mbenay

Apr 3

Dorrie Bright-Whitson

Mar 25

Easy way to remove duplicates

Google Sheets now has a "Remove Duplicates" function under Data --> Data Cleanup. I was

unread,

Easy way to remove duplicates

Google Sheets now has a "Remove Duplicates" function under Data --> Data Cleanup. I was

Mar 25

Mar 21

not letting me download

neverminddd it began to show up on my form, sorry for the post. Thanks! On Thursday, March 21, 2024

unread,

not letting me download

neverminddd it began to show up on my form, sorry for the post. Thanks! On Thursday, March 21, 2024

Mar 21

Alejandro González Fabila, Joseph Schmidt5

Mar 19

Google Error 403 can't Add new Range or modify existing

I believe the limit is 999 or 1000. In either case, you are over the limit. Joe Schmidt https://www.

unread,

Google Error 403 can't Add new Range or modify existing

I believe the limit is 999 or 1000. In either case, you are over the limit. Joe Schmidt https://www.

Mar 19

Anne Fensie, Joseph Schmidt3

Mar 18

Won't populate from a list created by a function

Ahhh....that makes sense. I removed the ". " and it works! Thanks so much! On Monday, March

unread,

Won't populate from a list created by a function

Ahhh....that makes sense. I removed the ". " and it works! Thanks so much! On Monday, March

Mar 18

Кирилл Ермаков, Joseph Schmidt5

Mar 16

Form doesn't aktivate

Thanks for letting us know. Duplicates have been the most frequent problem. Joe Schmidt https://www.

unread,

Form doesn't aktivate

Thanks for letting us know. Duplicates have been the most frequent problem. Joe Schmidt https://www.

Mar 16

Maxine Wilkie, … Joseph Schmidt4

Mar 14

Form Ranger does not load/update

nv-form-ranger-a...@googlegroups.com Joe Schmidt https://www.youtube.com/c/JoeSchmidt

unread,

Form Ranger does not load/update

nv-form-ranger-a...@googlegroups.com Joe Schmidt https://www.youtube.com/c/JoeSchmidt

Mar 14

Gabriel Santos, Joseph Schmidt7

Mar 6

SUPORTE EM PORTUGUES

How many items are you trying to load? Joe Schmidt https://www.youtube.com/c/JoeSchmidt GLUA.Joe@

unread,

SUPORTE EM PORTUGUES

How many items are you trying to load? Joe Schmidt https://www.youtube.com/c/JoeSchmidt GLUA.Joe@

Mar 6

Gerente Antas, Joseph Schmidt2

Mar 3

Can´t open form ranger

Is the form in a shared drive? I don't believe add-ons that change files work with shared drives.

unread,

Can´t open form ranger

Is the form in a shared drive? I don't believe add-ons that change files work with shared drives.

Mar 3

Vicky Arora, Joseph Schmidt2

Mar 2

Form Ranger stopped working

You need to tell us more about what isn't working. See Find errors in Formmule. for some items

unread,

Form Ranger stopped working

You need to tell us more about what isn't working. See Find errors in Formmule. for some items

Mar 2

Auto Angel, Joseph Schmidt2

Feb 27

It's just stopped working

See Find formmule errors. If that doesn't find the error, tell us more. Does formmule run

unread,

It's just stopped working

See Find formmule errors. If that doesn't find the error, tell us more. Does formmule run

Feb 27

Cristian Ruiz, Joseph Schmidt2

Feb 12

How I could do next? is it possible?

How about a custom URL for each parent that only shows their child? You can modify the prefilled

unread,

How I could do next? is it possible?

How about a custom URL for each parent that only shows their child? You can modify the prefilled

Feb 12

Austin Ritchie, … Joseph Schmidt4

Feb 6

Updating Questions list scrambles

If you have branching for the items in a list, FormRanger will not rebuild the branching when it

unread,

Updating Questions list scrambles

If you have branching for the items in a list, FormRanger will not rebuild the branching when it

Feb 6

Protect Leon GM, Joseph Schmidt5

Feb 3

ScriptError: You do not have permission to access the requested document.

Thanks! El domingo, 17 de diciembre de 2023 a las 14:46:40 UTC-6, glua...@gmail.com escribió: I don

unread,

ScriptError: You do not have permission to access the requested document.

Thanks! El domingo, 17 de diciembre de 2023 a las 14:46:40 UTC-6, glua...@gmail.com escribió: I don

Feb 3

Bethany Heid, Joseph Schmidt2

Jan 27

Formranger just reads the list. You can do anything you want to change the list. If you have

unread,

Formranger just reads the list. You can do anything you want to change the list. If you have

Jan 27

Galo Leroux, Joseph Schmidt2

Jan 22

Form Ranger not working

The usual cause is duplicates in the list. Have you tried the unique function? Have you tried using a

unread,

Form Ranger not working

The usual cause is duplicates in the list. Have you tried the unique function? Have you tried using a

Jan 22

Mis Samyak Creations, Joseph Schmidt2

Jan 16

Form ranger not showing value in kinked google sheet

I'm not sure I understand. When you look at the form, it has the correct entries but when you

unread,

Form ranger not showing value in kinked google sheet

I'm not sure I understand. When you look at the form, it has the correct entries but when you

Jan 16

Amin.Ahmed, … Joseph Schmidt6

Jan 16

drop down issue

Have you looked at flubaroo add-on? It allows feedback. On Tue, Jan 16, 2024, 6:28 AM David & Pan

unread,

drop down issue

Have you looked at flubaroo add-on? It allows feedback. On Tue, Jan 16, 2024, 6:28 AM David & Pan

Jan 16

Search

Clear search

Close search

Google apps

Main menu