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.

Featured Replies

I have flag fields for types of student financial aid

Students::Pellgrant

Students::Staffordloan

Students::Plusloan

How can I write:

Set Variable [$aidtype; "Pellgrant"]

Enter Find Mode []

Set field [students::$aidtype; 1] // to find records where Students:Pellgrant = true

Perform Find []

How can I write:

Set Variable [$aidtype; "Pellgrant"]

...

Where will the string "Pellgrant" come from?

  • Author

It would hard coded, one of five or so field sets I would find and process with one script.

I think I've found what I wanted:

Set Variable [$aidtype; Value: "pellgrant"]

Enter Find Mode[]

Set Field By Name ["Students::" & $aidtype; 1]

Perform Find []

If you think there's a neater way than looping thru five changes of this variable, I'd like to know.

I am afraid I don't follow you: if it's hard-coded, why not hard-code the target field instead?

My approach would be to have a single field in Students, with an AidTypeID, and a table of AidTypes. If the Student can have more than one aid type, then you need a join table btw Students and AidTypes (storing StudentID and AidTypeID). You would find in the join table for AidTypeID and gtrr match found to Students.

You shouldn't break Aid Type into separate flag fields.

Create an account or sign in to comment

Important Information

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

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.