form ranger not updating the dropdown options from assigned range and also not allowing adding a new range

[Accounts Achiredo]

Dear team 

form ranger not updating the dropdown options from assigned range and also not allowing adding a new range.

In my form the question my contact verified is not getting update from ranger. 

similar questions are : Purpose & vendor details(sec 3)

and few others that are not getting updated

my user key : AEMJz5yTfCbAqEH0JCm/D82bvWuk3P2uIkEUNfRlPuIbDUTxxUZ/f516OqGgWlnJRLG8EfMYB3D+

[Joseph Schmidt]

Did you see the note in the description of the group.  Google has made a change and will not allow duplicates in the data.

Send a message if the information in the note doesn't help.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
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/04b0038e-d7fa-4481-b1c2-912365a0fcd1n%40googlegroups.com.

[Accounts Achiredo]

Thank you For guidance.. I could resolve the error! 

For others who facing error and might get helped from my explanation of solution: 

 where-ever you have used form range and in your form(edit mode) the range(example SHEET 1 : ColA: ) is not getting listed or has disappeared. 

STEP 1 : go to your google sheet from where you are populating  (my example SHEET 1)

STEP 2: Go to your col/range of range( COLA in my example)

STEP 3: Select the range data and paste in your laptop excel

STEP 4: Sort it 

STEP 5: Either eyeball the duplicate or write formular '=A1=A2' in next col

STEP 6: copy the formula to end of your data 

STEP 7: all the cells where you see TRUE as value ... these are your duplicate enteries... you have remove/rename these enteries in ur google sheet to handle the form range issue problem.  

[Joseph Schmidt]

A workable solution but if you read through the comments, there is a Google solution using the Unique function.  The advantage being that if a duplicate gets added by mistake, the unique function will find and remove.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/32ad48b8-2fb2-473a-92d0-e68d428a1a8fn%40googlegroups.com.