Create a new calendar from scratch, or linked to your own FileMaker file in about 5 minutes.
This video and the accompanying instructions walk you through the steps to put a soSIMPLE Calendar into your own FileMaker database, or a brand new one. Most of the time, you’ll already have your database set up with events and these basic fields, so the first couple of steps may be unnecessary. We do recommend starting from scratch (by clicking the “New” button), rather than reverse engineering what we’ve done in our example solution. This is because we provide instructional information along the way helping you integrate into your file as quickly as possible.
1. Create (or identify) the required 5-6 fields
Your new calendar requires five fields. You can name them whatever you’d like. We usually recommend starting with the basic five or six fields before adding more customization so that you can see your calendar working smoothly before adding too many layers of customization. The required fields are:
- Date Start (date)
- Date End, if you have events that extend past one day (date)
- Time Start (time)
- Time End (time)
- Event Description (text)
- ID – sequential or random unique id for each event record (text or number)
2. Create (or identify) a layout and add required fields to the layout.
The calendar can only “see” fields and value lists that are on your specified layout. We recommend having a specific layout for the soSIMPLE Data Source, that only includes the fields you’ll need, but to get started you can choose an existing layout that contains the required fields.
We include a “Resume Script” button in our example to accommodate a “Pause” step in the soSIMPLE Calendar Actions script.
3. Upload your file to your FileMaker Server
Server-Powered calendars require FileMaker Server to run. If you haven’t already, make sure you’ve installed soSIMPLE Calendar on your FileMaker Server. Then you can upload your own calendar file and soSIMPLE Calendar Settings to the server, if it isn’t already hosted on the server.
4. Open soSIMPLE Calendar Settings file on the server and click “New”
Choose “Open Remote” and open “soSIMPLE Calendar Settings.” As soon as it opens, you’ll be looking at the calendar setup window. The upper left of the calendar setup window lists existing calendars. Click “New” at the bottom of the list to create a new calendar. This opens the “New Calendar Wizard” and will walk you through the steps to set up your calendar.
- The first window lets you name your calendar – this is for your identification within the settings file.
- Choose “I will be using this calendar with FileMaker Server” – this enables our Server-Powered mode.
- Choose “Client-Side Scripting” – this sets you up to use the calendar within FileMaker Pro or FileMaker Go.
- Click “Next” in the wizard.
5. Pick a database you’d like to use – or set up a new one.
Since this is the first time you’re adding this particular data source to soSIMPLE Calendar Settings, it won’t show up as an option yet. Choose “Set up new FileMaker file” to go to the next step.
6. Set up your database
- “Open a Database” – Click “Open a Database” button to open the file you created. This is required for the next step.
- Verify that you set up a layout for your required fields, which we did in step 2.
- “Open Calendar Setup” – Open the setup window to tell soSIMPLE where to find the fields you set up in step 1.
- Name your data source – for your own reference inside soSIMPLE Calendar Settings
- FileMaker Database – select your FileMaker database from the dropdown menu.
- Calendar Fields Layout – select the layout where you put your fields in step 2.
- Account Name/Password – type in the account name and password that has access to your file. For now, this can be a regular user. You can tighten security later by creating a specific account for this purpose.
- Map the fields you defined in step 1, by selecting the corresponding field names in each row.
- Start Date
- End Date, if you set one up
- Start Time
- End Time
- Event ID field
- Event Text field
- Script to run on Interaction – this will say “soSIMPLE Action Script” – and will flag an error since we haven’t copied that to our solution yet. Leave that value as it is anyway. We’ll copy that script in a moment.
- Click “OK” to the setup window. You may be flagged with an error for the missing script. You can safely ignore that for now.
- Click “Next” in the wizard.
7. Set up your database (part 2)
- Set up one of your privilege sets with the FM-PHP extended privilege setting.
- Go to your FileMaker file and choose “Manage > Security” from the file menu
- Double-click the account name that you entered in step 6
- Click “Edit” next to the “Privilege Set” for that account.
- Turn on the checkbox next to “FMPHP” extended privilege for that privilege set.
- Click OK and return to the “New Calendar Wizard”
- Turn on the “fmurlscript” extended privilege in all user privilege sets (for FileMaker Pro 16).
- Copy Calendar Script to the Clipboard
- Click this button to copy the core soSIMPLE Calendar Scripts to your clipboard
- Go to your file again, and open Script Manager (FileMaker 12 or 13) or Script Workspace (FileMaker 14+)
- Without opening any scripts, just chose “Paste” from the File menu. This will paste a folder with all the scripts you’ll need for soSIMPLE Calendar. The main one is called “soSIMPLE Calendar Actions.” This script will run automatically every time you double-click or drag anything in the calendar, or drag a blank area to create a new event. This script is completely customizable so you can control how your calendar behaves.
- Click “Done”
8. Your calendar is now showing up within soSIMPLE Calendar Settings.
You’re using the default settings for the calendar, which you can adjust later. For users who aren’t using the U.S. standard date (mm/dd/yyyy), please see this article.
9. Use in FileMaker Pro/Go
Click “Use in FileMaker Pro/Go” to use this calendar in your own solution.
- Open My File – if it’s not still open, open it again
- Copy Calendar Scripts – if you just did this in step 7, you can skip this step.
- Copy Web Viewer Object to the Clipboard
- Click this button to copy the web viewer object to your clipboard.
- Go to your solution and create a new standard form layout.
- Paste the web viewer onto the layout
- The web viewer is hardcoded with the address to your calendar
- It’s set up with the name “web_calendar” so your scripts can reference it
- It’s anchored to all four sides so it will expand with your layout
- There’s also a “refresh” button pasted in that calls a utility script to refresh your calendar.
10. Enter browse mode, and you will have a fully functioning calendar integrated into your solution.
Your calendar will display all the events in your file. Double-clicking an event will open the layout you created in your solution. Dragging an empty area will open a new event using your layout. You can now adjust the calendar to your specific needs:
- Adjust the soSIMPLE Action Script to customize the behavior of double-clicking and dragging within the calendar.
- Change the Layout of your calendar in soSIMPLE Calendar Settings to add additional calendar views
- Change the Theme in soSIMPLE Calendar Settings to change the font, color, or other visual aspects of your calendar.
- Change the Options in soSIMPLE Calendar Settings to tweak specific settings in the calendar.
- Any changes made to settings in soSIMPLE Calendar Settings will immediately apply to the calendar in your solution. Just click “Refresh” to see the changes.