Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Filemaker won't let me enter setfields correctly

Featured Replies

in Filemaker 12 I could enter multiple types of fields with set Field, but in FM13, the menu does not let me enter say

set field schedule::project[ id_project; $ProjectId]

it either demands I create a calculation (and making idproject = $projectid, does NOT work)

and the calculation button stops me with saying " expecting other command "

this is really iritating as I wish to be able to just directly edit scripts without having to go through popups.

 

So my Question then remains, how do i fix this poor behavior?

 

There is no change.

 

You're doing something incorrectly.

post-62898-0-67196300-1427126573_thumb.p

post-62898-0-49074500-1427126581_thumb.p

post-62898-0-63024600-1427126591_thumb.p

set field schedule::project[ id_project; $ProjectId]

 

As Bruce says, you have something wrong and it looks like you are trying to put the information in the repetition section instead of opening the calculation dialog and putting it there ... indicated by the square brackets after the field name.

  • Author

Thanks, The pictures helped immensely.

 

Now, I have a different problem. I want to script an availability system

 

First, if a person has been selected for an event, they are marked unavailable for events in the same time slot, with an estimated time

Then when a person schedules in advance they are out, the system will date compare against their out and return dates.

Thirdly, I want a script that will Filter out "staff" by their "Crewcode" but the crewcodes are selected from a text field, ie, if my code is YV, and the next person's is JD and another is EB, the Crewlist has JD YV EB. I want it to show every event from the Crewlist,  I know it's a find function, but What formula should i use for the global filter?

Start a new thread on that question.

Please start a new thread for every separate question you have.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.