CRAZY CALENDAR HACK: Add Events Directly to a Timeslot, Pre-Fill Date/Time

[GreenFlux (GreenFluxLLC)]

Hold on to your apps, this one is gonna get a little weird.

The default calendar view doesn’t provide a way to pick a timeslot when opening the form.

I came up with a hack using a new table that contains only one sheet column for the hour, and 7 virtual columns for the day of the week.

From there, I have a table view that shows related events to every Hour, pulling only events from This Week (Slice).

Then, I created 7 Edit actions, 7 Add actions, and 7 group actions and linked them to 7 more virtual columns!

Here’s the result:

Crazy Calendar Hack.mov (video)

[LeventK (Levent Kulacoglu)]

Outstanding work @GreenFlux, congrats brutha!

[Grant_Stead]

Bad ass!
I love it.

@Martin_Pace I wonder if we could do something like this for our resource management… One heck of an input hack.

[Fabian (Fabian Weller wAPPlabor)]

Awesome hack thank you @GreenFlux.
And thanks for the reminder, to not forget the 5 mile run

[adiboo_adib]

Nice, have you a solution to add a pdf file on google calendar event?

[GreenFlux (GreenFluxLLC)]

You could add the file URL to the bottom of the [Description], and use a Virtual Column (Type=File) with a formula to parse out the URL.

Or you could add a new table for Files, and add a Virtual Column (Type=Ref) to the Calendar table to relate them.

I guess it would depend on who is adding the file, and when. Do you want to attach a file to the calendar invite, or store your own file for reference and have it linked to a calendar row?

[adiboo_adib]

Thank for you reply
i need to store my own files and linked to a calendar row.

[GreenFlux (GreenFluxLLC)]

@adiboo_adib

i need to store my own files and linked to a calendar row.

Ok, if the other attendees do not need access to the file, I wouldn’t store the link in the description.

Try adding another table to store the files, and add a Virtual Column (Type=Ref) that relates it back to your calendar table.

Then, as you’re entering a file, the Ref column should give you a list of Calendar events to link it. This will create a Related Files (REF_ROWS Virtual Column) in your calendar table that will show all the files assigned to each calendar event.

[adiboo_adib]

Can you show me an exemple please if you can.
thanks

[Giuseppe_Nugara]

Congratulations @GreenFlux! Great Work !

[GreenFlux (GreenFluxLLC)]

@adiboo_adib

Nice, have you a solution to add a pdf file on google calendar event?

@adiboo_adib

Can you show me an exemple please if you can.

1. Add table for File(s)

• [Key] (auto-generated, hidden)
• [Event] (Ref to Calendar table)
• [Attachment] (File)
• [Note] (Long Text)

2. Enable Is_Part_Of for Ref

3. Add Related Files to Calendar Detail view

[Rafael_ANEIC-PY (Rafael Almeida)]

Amazing work, thank you for sharing it with us.

[adiboo_adib]

Thank you for the exemple, i have a problem as you see

[GreenFlux (GreenFluxLLC)]

Does the ‘Primary’ calendar table have a column called Row ID?

If so, try setting that as the Key, and unselect the Key checkbox for RowNumber.

[adiboo_adib]

Work great now thanks
Can you tell where can i chage this text

[GreenFlux (GreenFluxLLC)]

@adiboo_adib

Can you tell where can i chage this text

That is the default ‘Description’ text for related records. You can change it inside the Column Settings.

Click the pencil to expand 'Related Convocations` and scroll down to Display.

[adiboo_adib]

Thank you work great

[TyAlevizos]

WOW!

[Ratatosk]

WOW INDEED!!!

[Mike_T (Mike Thome)]

Do you have to limit to This Week? I’m considering setting up something similar but I have only 2 time slots per day but I want the user to see a month view and be able to select the time slot to initiate the action.

Great work!

Ignore me…I just rewatched the video and realized that it’s a table view and not an actual calendar view. Brilliant by the way and i need to look into how you formatted all the backgrounds, etc.