new to form mule

[Joe Sanders]

A fellow Google Admin recommended I check out Form Mue to acomplish what I a trying to do, but I cant seem to figure out how to keep this from emailing every single person that has already been emailed already.  Let me explain my scenario.

The Librarian has a form that students can fill out reuesting she print things for them.

She has a column in that Spreadsheet that has a drop down with only one selection "Ready". What she wants, is when she changes that row, for that student to "Ready" the student should get an email saying their document has been printed and is ready for pickup.  I have it setup and it works, as long as you use the form mule "Preview and send all" button... however, if you then mark another line as "ready" and run the form again, it emails both people. If you have 4 marked ready, it emails all four, even if they have all been emailed already. 

It would be great if their was logic built in that stops it from emailing anyone that has already been emailed.  Is this possible with Form Mule?

[Bart van Dalfsen]

Hi Joe,

FormMule (FM) created a couple of columns, and one of those contains the send status (=reply from the mailserver).

Look for in row 1 of your FormResponse-tab for the header 'Template 1 - Send Status' (or your more specific template name).

Now, for every cell in this column where LEN()>0 you will probably see the reply or error of the server.

However, if you put something in the cells of the Send Status column(s) yourself (like: 'Completed: request processed')

you will prevent FM the hard way not to sent any mails for this old record for this specific template.

However, the more elegant approach is come up with some clear conditions which much be met before you allow FM to sent anything at all.

Add another column to be labeled as  'Template 1 - Send Condition'

As requests older than say three weeks - which should therefor not be mailed about anymore - you could setup an ARRAYFORMULA() to automate the calculation to match the condition for each record:

=ARRAYFORMULA(   IF( ROW(A:A)=1, "Template 1 - Send Condition', IF( LEN(A:A)=0, "", 

...and from there you test the amount of DAYS(A:A) for the record...

IF( DAYS(A:A) > 21, FALSE, DAYS(A:A) )

or something like that...

...and use the column as the conditional for the specific template in FM.

And yes, if you can think of more conditions to 'harden' your solution...

...create more columns with a test to the records to which the requrement has to meet.

I hope this make some sense to you ;)

Cheers, Bart

Op za 2 sep. 2023 04:29 schreef 'Joe Sanders' via NV Form Mule Add-on <nv-form-m...@googlegroups.com>:

This message (and any associated files) may contain confidential and/or privileged information. If you are not the intended recipient or authorized to receive this for the intended recipient, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by sending a reply email and delete this message. Thank you for your cooperation.

--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/88e45b80-a10b-45d5-a84a-b05e94127209n%40googlegroups.com.

[Bart van Dalfsen]

Hi Joe,

When I wrote my previous reply I was a little in a hurry...

...you might already caught the " and ' error in my ARRAYFORMULA() proposal...

...and the incomplete parameters for DAYS() which should have been like:

...     DAYS( TODAY(), A:A) > 21    ....   

When DAYS() calculates an equal/smaller number than 21 you should get the output from DAYS( TODAY(), A:A) +1    which starts with 1 (the first day) upto 22 which are all threated as a TRUE() and gives FM the go ahead to mail if Send status is still empty.

Do you get where it's going?

Cheers from The Netherlands,  Bart

Op za 2 sep. 2023 08:28 schreef Bart van Dalfsen <bart.van...@gmail.com>:

Hi Joe,

FormMule (FM) created a couple of columns, and one of those contains the send status (=reply from the mailserver).

Look for in row 1 of your FormResponse-tab for the header 'Template 1 - Send Status' (or your more specific template name).

Now, for every cell in this column where LEN()>0 you will probably see the reply or error of the server.

However, if you put something in the cells of the Send Status column(s) yourself (like: 'Completed: request processed')

you will prevent FM the hard way not to sent any mails for this old record for this specific template.

However, the more elegant approach is come up with some clear conditions which much be met before you allow FM to sent anything at all.

Add another column to be labeled as  'Template 1 - Send Condition'

As requests older than say three weeks - which should therefor not be mailed about anymore - you could setup an ARRAYFORMULA() to automate the calculation to match the condition for each record:

=ARRAYFORMULA(   IF( ROW(A:A)=1, "Template 1 - Send Condition", IF( LEN(A:A)=0, "", 

...and from there you test the amount of DAYS(A:A) for the record...

IF( DAYS(TODAY(), A:A) > 21, FALSE, DAYS(TODAY(), A:A) +1)

[Joseph Schmidt]

FormMule creates a status column for each merge template.  FormMule should put a status message for the rows sent.

There should be a filter to only send for rows with "ready" in the appropriate column.

FormMule will not send a message if there is something in the status column.  

Are you sure it is resending?  Look at the information to see what time the message is sent.

Joe Schmidt

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

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt