Saved categories for autopopulation not being retained?

120 views
Skip to first unread message

gorf

unread,
Apr 9, 2025, 2:09:37 AMApr 9
to NV Form Ranger Add-on
After setting my questions to be populated, every time I open my form again, some questions will not be marked as populated in the formranger UI, despite being populated. This interferes with my autopopulation settings.

Joseph Schmidt

unread,
Apr 9, 2025, 8:32:27 AMApr 9
to nv-form-ra...@googlegroups.com
There is a tool in the description of the group to find duplicates.  FormRanger will not update if there are duplicates.

Formranger updates the form based on a time or form trigger.  The change happens for the next person to open the form.

If persons A,B, and C open the form at the same time, the form will be updated when any form is submitted.  The remaining folks will still see the form as it was when they opened it.

Formranger isn't very useful when the link to the form is shared in a group setting.  Sharing the link with the class during the class will cause everyone to see the same form.

Let me know if you have any questions.



On Wed, Apr 9, 2025 at 2:09 AM gorf <financei...@gmail.com> wrote:
After setting my questions to be populated, every time I open my form again, some questions will not be marked as populated in the formranger UI, despite being populated. This interferes with my autopopulation settings.

--
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 visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/46c1c1f0-717e-46e0-b235-7c3826521623n%40googlegroups.com.

gorf

unread,
Apr 13, 2025, 9:16:10 PMApr 13
to NV Form Ranger Add-on

This is not regarding duplicates, or parallel form submissions. This is regarding the inconsistency in the "select" functions in the FormRanger UI, when enabling "Select From Range" for any question. The process to replicate my issue is to open the form editor, set all questions to get their values from the relevant ranges from an external sheet (In my case I have roughly 80 questions, in 14 sections with at most 20 options in a question). If, after all questions are scrolled through and the options have visibly been updated, the form editor is closed and reopened, the FormRanger UI when reopened will no longer properly display that all questions have been set to select from their relevant ranges, with the "select" button being toggled off. This raises some doubts about whether the form would still update the options for those questions. I apologize for my lack of clarity in my original inquiry.

gorf

unread,
Apr 13, 2025, 9:18:13 PMApr 13
to NV Form Ranger Add-on
Additionally, while the select is toggled off, the questions retain the previous options as displayed after the initial ranging. However, I am not sure if the options would update still after any changes to the reference sheet.

gorf

unread,
May 28, 2025, 4:34:46 AMMay 28
to NV Form Ranger Add-on
After checking, it seems every time formranger is opened, some questions in the form are selected and properly bound to their corresponding columns, while some are not. It seems random. This disrupts the autopopulation.

Joseph Schmidt

unread,
May 28, 2025, 11:21:19 AMMay 28
to nv-form-ra...@googlegroups.com
Can you share a copy of the form and spreadsheet with me so I can test.  GLUA.JOE @ Gmail.com.

Are you refreshing the screen?  Changes made do not always show unless you refresh the screen.

Please include any documentation that will help me identify the issue.  

See custom script.  



To view this discussion visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/cdba516c-7a8d-4382-bcac-7b4aa3d1ef3an%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages