About Ksenia1

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 · 06-01-2023

Hi everyone,I have a sort of shopping App where employees can order hardware. Once they collected all items in their shopping basket and hit the button "Order All" the status of every single item in the table changes to "requested" and an email will ...

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

sonal_sheetal's Bio

Badges Ksenia1 Earned

Recent Activity

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

Send only one email triggered by several updates

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