# [Samples] Calendar

## Recommended Posts

### Calendar

View File

I created this solution because I wanted to have each day as a record.

The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days.

It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs.

After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job.

Any idea or contribution to make it better is welcomed.

Thank you, Toni

• Submitter
• Submitted
02/22/2018
• Category
• FM Version
12

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Similar Content

• By kigmaker
Hello,
I would like to use UUIDdecimal CF for the taskID rather than an auto-enter Serial Number. However I get Integer Notation like this:
2.25640703445567e+37, rather than a number like this:
22564070344556677882256407034455667788.
I have toyed with other implementations of FullCalendar and have gotten it to work, but the related libraries were different versions and I can't recall how I solved the same problem then.
How can I solve this?
Example
{
"allDay" : false,
"color" : "#FF0000",
"end" : "2018-05-30T23:00:00**TIMEZONE**",
"id" : 9,
"start" : "2018-05-30T21:00:00**TIMEZONE**",
},
{
"allDay" : false,
"color" : "#E69138",
"end" : "2018-06-01T23:30:00**TIMEZONE**",
"id" : 2.25640703445567e+37,
"start" : "2018-06-01T22:30:00**TIMEZONE**",
}

• Saving Millions with FileMaker - FMSP 5.1 New Calendar - March 2018 - FileMaker Training
https://youtu.be/WYuFrKvELz4
The Basic version of FMSP has the new calendar.
If you are looking for the PayPal integration, you need FMSP Enhanced.  If you have our complete training bundle or have purchased our Pro 16 video training, you should get an email about this.  If you have not received that email, then please email us at support@rcconsulting.com
http://bit.ly/2m9KRQV
Get up to speed with the FileMaker Pro 16 Video Training Course!
Top Rated Course by FileMaker Expert, Richard Carlton.
http://learningfilemaker.com/fmpro16.php
Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
The course is 50 hours of video content!
Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers.
He has offices in California, Nevada, and Texas.
Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
http://www.rcconsulting.com/
FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos
Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16
Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing
Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data

Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
http://learningfilemaker.com/FIAS.html
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review
Use FileMaker to create an app with the FileMaker Training Series
FileMaker Pro is a cross-platform relational database application from FileMaker Inc.
Comment, Like & Share Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
#FMSP5.1
#MakingMillions
#FileMakerPro16Training
#FileMakerPro16Videos
#FileMaker
#FileMaker Experts
• By Toni
I created this solution because I wanted to have each day as a record.
The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days.
It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs.
After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job.
Any idea or contribution to make it better is welcomed.
Thank you, Toni
×
×
• Create New...