Add an event to the day of calendar view

Hello

Can i add an event to the day it is in the calendar view?

Example: Open Calendar ... go to December 18, and click add and the event takes place that day?

Details:

I go to a day of my choice in the calendar view (default view day) and if I want to add an event on that day, when I do the ADD action it does not assume the day it is on.

Another question, is it possible in the calendar view (default view day) when clicking on the time to add an event and assume the desired day and time?

Example: Dec 18   ->   Add an event 2pmcalendar1.jpgcalendar2.jpg

@Aurelien 

Thank you

Solved Solved
0 1 148
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

Hi @JoaquimReis 


@JoaquimReis wrote:

I go to a day of my choice in the calendar view (default view day) and if I want to add an event on that day, when I do the ADD action it does not assume the day it is on.


There is no relation between what you see and the add button, unfortunately.

You may approach the calendar view as a simple display view.


@JoaquimReis wrote:

Another question, is it possible in the calendar view (default view day) when clicking on the time to add an event and assume the desired day and time?


This is possible. You will need to use an expression in the INITIAL VALUE field of the [time] column.

For example:

SWITCH(WEEKDAY([date])
  1,"01:00:00",
  2,"02:00:00",
  3,"03:00:00",
  "05:00:00"
)

 For reference:

SWITCH() - AppSheet Help

WEEKDAY() - AppSheet Help

Define app formulas and initial values - AppSheet Help

Date and time expressions - AppSheet Help

The notions of TIME and DURATION and how to use in... - Google Cloud Community

 

View solution in original post

1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @JoaquimReis 


@JoaquimReis wrote:

I go to a day of my choice in the calendar view (default view day) and if I want to add an event on that day, when I do the ADD action it does not assume the day it is on.


There is no relation between what you see and the add button, unfortunately.

You may approach the calendar view as a simple display view.


@JoaquimReis wrote:

Another question, is it possible in the calendar view (default view day) when clicking on the time to add an event and assume the desired day and time?


This is possible. You will need to use an expression in the INITIAL VALUE field of the [time] column.

For example:

SWITCH(WEEKDAY([date])
  1,"01:00:00",
  2,"02:00:00",
  3,"03:00:00",
  "05:00:00"
)

 For reference:

SWITCH() - AppSheet Help

WEEKDAY() - AppSheet Help

Define app formulas and initial values - AppSheet Help

Date and time expressions - AppSheet Help

The notions of TIME and DURATION and how to use in... - Google Cloud Community

 

Top Labels in this Space