Form Ranger Not updating after submit

442 views
Skip to first unread message

no-reply UGS

unread,
Dec 16, 2020, 4:17:04 AM12/16/20
to NV Form Ranger Add-on
Hi, I am not getting the updated field after submitting.
How can I increase the frequency or fix this?

Joseph Schmidt

unread,
Dec 16, 2020, 9:42:27 AM12/16/20
to nv-form-ra...@googlegroups.com
Does the form update hourly?  If not, you may have a problem with how FormRanger is set up.  I would turn FM off and then back on to see if that fixes the problem.

Updating on a form submission should be the fastest method.



On Wed, Dec 16, 2020 at 4:17 AM no-reply UGS <no-r...@ugs.com.sg> wrote:
Hi, I am not getting the updated field after submitting.
How can I increase the frequency or fix this?

--
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/7da3d942-ef6d-48a6-888e-7e4cc51e3a22n%40googlegroups.com.

Ang Jia Hao

unread,
Dec 16, 2020, 7:57:34 PM12/16/20
to NV Form Ranger Add-on
Hi Joe,

I am no-reply UGS. Form is updating every hour, but does not update immediately after submit. 

Joseph Schmidt

unread,
Dec 16, 2020, 11:14:18 PM12/16/20
to nv-form-ra...@googlegroups.com
Did FR ever work on FormSubmit?  Is the form or spreadsheet in a shared folder?  Most folks have the information for the form in the same spreadsheet that receives the responses.  I don't know if that is a requirement.

You might want to look at script to update a form. That seems to work.  Read the description below the video.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/a7ff092a-ff38-4bd3-bb81-5bf6642f698cn%40googlegroups.com.

Ang Jia Hao

unread,
Dec 24, 2020, 2:10:46 AM12/24/20
to NV Form Ranger Add-on
Hi Joe,
Thank you for your response.
The Form ranger may not be responsive to form submit as there's a re-calculation occurring at the same time.
Is it possible for me to run a URL that does the "updating" work then redirect to the form?
This will allow a "trigger" before I see the form options.

Joseph Schmidt

unread,
Dec 24, 2020, 8:19:05 AM12/24/20
to nv-form-ra...@googlegroups.com
I'm not aware of anything you can do when using FormMule.  Does FM update on the time trigger?  If not, there might be a problem with the setup.

I'm guessing that if the calculations are taking a long time, it could be a problem.  I don't remember ever seeing it but it is possible.

You could use the script and add a delay.  When you open the spreadsheet, is there a long delay?  I have seen spreadsheets where the number of rows has increased for some strange reason and that is making the calculations take longer.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/97e11b4e-d085-4263-bbd8-27857385252fn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages