About Ksenia1

Ksenia1

Dear community,In my Google Docs template I have positioned my logos in the header. However, when I create a PDF from it, anarchy reigns and my logos are everywhere but where they should be. I tried to demonstrate it with these screenshots where each...

Ksenia1

Hey there,I am looking for a method to automatically send notifications to users 10 minutes before their appointment (saved in a DateTime column).My idea was to create 6 Bots with the event type scheduled -> Minute of the hour every 10 Minutes (0; 10...

Ksenia1 · 02-27-2024

Hi there,In my App I am scheduling appointments. For each appointment a new row is added to the table "Appointment" with the status "new". Depending on the value in my column "Type" (being a Ref column to another table, not directly to my recipient l...

Ksenia1 · 09-20-2023

Hi there,I have a huge table with at least 200 columns for a questionnaire. Some of these columns are placeholders for Show -> Page_Header columns. As the names of these Page_Headers might change (and not only these), I would like to avoid doing monk...

Ksenia1 · 06-05-2023

Is it possible to empty the value of my (ref) column if the column after is being filled?My "Material" column has a valid if formula: ISBLANK([Material_man]) but instead I want the chosen value in "Material" to be emptied if the user filled the colum...

Ksenia1

This is a great idea @Aurelien, thank you for elaborating! As @Alyssa_QREW pointed out in the post below, I am a bit concerned about the mentioned delay that may/will appear in the wait step leading to the notification being sent out too late.

Ksenia1

Thank you for pointing this out @Alyssa_QREW! I changed my filter condition toAND(TOTALMINUTES([Appointment] - now()) >= 10, TOTALMINUTES([Appointment] - NOW()) < 20)

Ksenia1 · 02-28-2024

Thank you @AleksiAlkio for your help!

Ksenia1 · 02-27-2024

Thanks, it's almost complete! I just fail to get the Start & End formula together:<><>...unfortunately doesn't give me a result in the email body.Though, if I put the expression into a virtual column, it shows the result I want to have.Of course I ca...

Ksenia1 · 02-27-2024

No direct relationship, no. [Type].[Vehicle].[Recipient] would be the expression to get the information being in Table "Appointment"

My Stats

Dileep1's Bio

Badges Ksenia1 Earned

Recent Activity

Logos in Google Docs template are misaligned in created PDF

Send notification 10 minutes before appointment

Send one email with information on several rows and to different recipients

Automatically change column names, maintained in another table (avoiding monkey tasks)

Empty value if other column isnotblank

Re: Send notification 10 minutes before appointment

Re: Send notification 10 minutes before appointment

Re: Send one email with information on several rows and to different recipients

Re: Send one email with information on several rows and to different recipients

Re: Send one email with information on several rows and to different recipients