É possível Enviar PDF após 7 dias?
20 views
Skip to first unread message
LUIS OTAVIO
Feb 21, 2025, 1:46:05 PM2/21/25
to NV Autocrat Add-on
Olá Wagner e pessoal, alguém sabe me informar se tem como configurar o autocrat para acionar o gatilho após 7 dias?
posso configurar apenas após 24 horas que é uma opção automática que ele disponibiliza.
Caso alguém consiga me salvar com o passo a passo.
Joseph Schmidt
Feb 21, 2025, 5:44:29 PM2/21/25
to nv-autocr...@googlegroups.com
See Example.
C1 contains ={"send";arrayformula(if(DATEDIF($A$2:$A,today(),"D")=7,"send","no send"))} which calculates exactly 7 days.
D1 contains ={"send if more than 7";arrayformula(if(DATEDIF($A$2:$A,today(),"D")>6,"send","no send"))} which calculator any row greater than 6 days.
Sent the time trigger to run what ever frequency you want. When it runs if will only send the rows that meet the specification.
Make sure you set the calculation in settings.
On Fri, Feb 21, 2025 at 1:46 PM LUIS OTAVIO <luisot...@gmail.com> wrote:
Olá Wagner e pessoal, alguém sabe me informar se tem como configurar o autocrat para acionar o gatilho após 7 dias? posso configurar apenas após 24 horas que é uma opção automática que ele disponibiliza. Caso alguém consiga me salvar com o passo a passo.
--
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 visit https://groups.google.com/d/msgid/nv-autocrat-add-on/5b527476-0bc8-4cb8-bbf8-b4556269b3fcn%40googlegroups.com.
LUIS OTAVIO
Feb 26, 2025, 4:44:39 PM2/26/25
to nv-autocr...@googlegroups.com
Joseph, thanks for responding. Do you know where I go within the autocrat application to do this step by step that you taught me?
so I can enable autocrat to run only every 7 days. Or sending the file in PDF format every 7 days
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQGqwfAmPA8m2BEKbYrXGafHdxZC5JSNgXDfY-33PNRqQ%40mail.gmail.com.
Joseph Schmidt
Feb 26, 2025, 4:58:58 PM2/26/25
to nv-autocr...@googlegroups.com
In this spreadsheet, use the formula in C1 if you want the exact day. Use the formula that is in D1 if you want rows 7 days or older.
Insert a column in your data sheet and copy the formula. You will have to change the formula to match the column containing the date.
I don't think there is a video that explains the example. There is a video on the arrayformula function in my YouTube channel.
Reply all
Reply to author
Forward
0 new messages