Run merge on trigger for same data

36 views
Skip to first unread message

Ross Webb

unread,
Jul 12, 2019, 10:01:18 PM7/12/19
to NV Autocrat Add-on
I have data submitted through a google form. I would like to do a merge once a month that includes data that has been previously merged.
Is it possible to bypass the status condition - i.e. run regardless of status of a record?

Joseph Schmidt

unread,
Jul 12, 2019, 10:21:41 PM7/12/19
to nv-autocr...@googlegroups.com
Autocrat will only merge rows that are empty in the status column.  You can write a script to erase the status data or manually delete the data once a month.



On Fri, Jul 12, 2019 at 10:01 PM Ross Webb <rnl...@gmail.com> wrote:
I have data submitted through a google form. I would like to do a merge once a month that includes data that has been previously merged.
Is it possible to bypass the status condition - i.e. run regardless of status of a record?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/732e7594-a328-44a4-8a25-a88f98114e4c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ross Webb

unread,
Jul 12, 2019, 11:14:28 PM7/12/19
to NV Autocrat Add-on
Thanks for the truth(!), Joe. Appreciate that.
Would it be worth asking that a switch to turn this behaviour off be added as a new feature, or wouldn't that make sense? It makes sense to me fo my application! But maybe it is just as easy to make a script that erases the status data as soon as it's written. I should try to put my hand to it!

Ross


On Saturday, July 13, 2019 at 12:21:41 PM UTC+10, Joseph Schmidt wrote:
Autocrat will only merge rows that are empty in the status column.  You can write a script to erase the status data or manually delete the data once a month.



On Fri, Jul 12, 2019 at 10:01 PM Ross Webb <rnl...@gmail.com> wrote:
I have data submitted through a google form. I would like to do a merge once a month that includes data that has been previously merged.
Is it possible to bypass the status condition - i.e. run regardless of status of a record?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add-on+unsub...@googlegroups.com.

Joseph Schmidt

unread,
Jul 13, 2019, 11:11:38 AM7/13/19
to nv-autocr...@googlegroups.com
Ross,

I think this video should help.  Clear status columns
On Fri, Jul 12, 2019 at 11:14 PM Ross Webb <rnl...@gmail.com> wrote:
Thanks for the truth(!), Joe. Appreciate that.
Would it be worth asking that a switch to turn this behaviour off be added as a new feature, or wouldn't that make sense? It makes sense to me fo my application! But maybe it is just as easy to make a script that erases the status data as soon as it's written. I should try to put my hand to it!

Ross

On Saturday, July 13, 2019 at 12:21:41 PM UTC+10, Joseph Schmidt wrote:
Autocrat will only merge rows that are empty in the status column.  You can write a script to erase the status data or manually delete the data once a month.



On Fri, Jul 12, 2019 at 10:01 PM Ross Webb <rnl...@gmail.com> wrote:
I have data submitted through a google form. I would like to do a merge once a month that includes data that has been previously merged.
Is it possible to bypass the status condition - i.e. run regardless of status of a record?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/8b1ab085-0bb3-47a2-b970-92bfa59cc846%40googlegroups.com.

Ross & Lyndal Webb

unread,
Jul 14, 2019, 5:48:04 AM7/14/19
to nv-autocr...@googlegroups.com
Thanks Joe,
I'd already seen your video and was thinking it would be my starting point!
Ross


Check out Bible Translation in Vanuatu


To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQmA4ndhWTYM7z2cc4dniDDNTjYouyuEVWySetNNUWvBQ%40mail.gmail.com.

Ramiro Valencia

unread,
Jul 14, 2019, 9:21:28 AM7/14/19
to nv-autocr...@googlegroups.com
Ya resolvi el problema. Normalmente Tengo dos cuentas de gmail abierta y decidi dejar abierta solo con la cuenta que estoy trabjando y cerré la sesión de la otra cuenta y empezó a funcionar

Gracia a Todos por su apoyo

Libre de virus. www.avast.com

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CADgcd5dXj8Yr5gY-78HHHmmeXv_5Q_Np58QmZTJ07egBqbWPSw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Libre de virus. www.avast.com
Reply all
Reply to author
Forward
0 new messages