FormRanger works for me. Examples

[Joe Schmidt]

FYI,

I have helped several people and others have reported that FormRanger does not work with duplicate entries in the table.  This is likely a Google change.  It makes sense in that why would you want two entries that said exactly the same thing.

I created an example with two different methods of preventing duplicates. The form has two questions do demonstrate the differences.

The form and spreadsheet can be found at FormRanger example files

You can submit a form at submit a form  Feel free to submit a form and then open the form to see the changes.  I have set the limit to one per item and there are 51 items so you should be able to experiment a little before there are none.

This form is set with a branch to an administrator section which allows the administrator to submit a form after changes to the tables and have the form update immediately.  

Thanks to Valerie for helping me test.

You should be able to view the files and make copies if you would like.

If someone has a different issue with FormRanger, let me know.

[Belinda Henson]

This helps. It looks like I have my formulas right. I feel like it is on the Form side and not the sheets side. The Revised name changes in Sheets, but no on the form.

[Lloyd Johnson]

this is a very bad explanation of the duplicate problem. needs a clear way to fix the issue

[Joe Schmidt]

I have updated the formulas to include the Trim and Substitute Functions.  

The formula in C2 should eliminate multiple spaces between words and extra spaces before or after the text.  

=unique(arrayformula(trim(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:B," "," ")," "," ")," "," ")))) or

=sort(unique(arrayformula(trim(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:B," "," ")," "," ")," "," ")))),1,true) for sorted results.  This would be for names, etc.

The only thing that needs changing is the B2:B to point to the correct column.

A big thank-you to all who helped identify the issues and solving the issue.

Let me know if you find any issues or have additional questions.

[TIO Farms]

Could you simply let us know where to put what and get this done :)

[Joseph Schmidt]

You need to insert a column and insert the formula in row 2. Place your title in row 1.

If you read the message in the description of the group and look at the example spreadsheet, you should find enough information.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to a topic in the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-form-ranger-add-on/8hvp98oImww/unsubscribe.
To unsubscribe from this group and all its topics, 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/4fa377ac-a779-48c9-bd22-e5ee6c621680n%40googlegroups.com.