Formranger stopped working

[Ricky Romer Cannon]

So I have used formranger before, I created an autoupdating list on the response sheet that will feed back into the form. It was working fine then suddenly stopped populating new items in the list. I checked the connections and rechecked formranger within the form options and it seems to be seeing everything properly but those updates do not port over to the actual options in the form. It sees the changes and the preview add those items but saving them does nothing.

Thoughts? Bugs?

[Ricky Romer Cannon]

Never mind. I understand what was happening. Thanks!

[Nelson the Seagull Cafe Ltd.]

What were you doing wrong? I am having the same problem and i feel daft

[Joseph Schmidt]

The most likely problem is duplicates in the data. Two rows that have a space in them that is a duplicate. Two rows with nothing in them is not a duplicate loving being null so he's a check out your formulas working as it actually setting the data to a value or to blank.

--
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/4db18d5c-5532-4b46-a569-5da5fb4418bdn%40googlegroups.com.

[Richard Romer Cannon]

Check the top of the comment forum, it looks like there was a limitation with the formula I used but there is one posted at the top of the forum that avoids that limitation. 

This is what I used to pull new entries to repopulate the dropdown in sequential submissions:

=sort(unique(arrayformula(trim(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE('Form Responses 1'!F2:F," "," ")," "," ")," "," ")))),1,true)

Where "Form Responses 1'!F2:F" is the column which that particular item is being pulled from in the form response sheet.

On Sun, Jul 9, 2023, 3:13 PM Nelson the Seagull Cafe Ltd. <in...@nelsontheseagull.com> wrote:

--
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/rnmrf-EsHeE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-form-ranger-a...@googlegroups.com.

[Joseph Schmidt]

It has been a long time since I wrote that formula, but my memory is that if you just use the unique function by itself, it will not give the same result that Google expects when it's trying to fill a question to a Google question. I believe the formula's job is to get rid of any embedded double blanks.

When you're feeling a table, it would make sense to always make the entries be alphabetic so it'll be easier for the person trying to use the form to find the leprosy that they want.

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/CALu5D0h1pTxWE2%3Do6Ewr9M0KEY_Ui%2BBPUECh6-w1x1Erp%2ByAZg%40mail.gmail.com.

[Александр Прямоносов]

Same problem. Checked by adding one element at a time. Reached line 330, then it does not load.

среда, 12 июля 2023 г. в 03:55:42 UTC+3, Joseph Schmidt:

[Joseph Schmidt]

Google made a change and for a long time, FormRanger cannot update a question if the list contains a duplicate.

That is the issue 99.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 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/0b6ef0a5-9958-4984-b101-bfc6a70dba3dn%40googlegroups.com.