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

greetings,

is it possible to (based on a script) colour certain records in a portal. ie. if name = "Pall" make this record print out blue and if name = "Jim" print this record in red. cheers!

No need for a script. Make a calculation field in the related file that uses a Case function to select the desired background colour. The background colours themselves need to be coloured images in container fields (one of the few instances where repeating fields are very useful).

pmusaev,

There are lots of ideas here about this and related things. You might be able to search for some of them...

I started typing, and Vaught beat me ; ) but I'd say if you have various people that you're color-coding, set up (if you don't already have) a file with one record for each person. Add a container field to hold a swatch of each person's color. You should paste the smallest possible swatch so as not to waste memory and processing time, since FileMaker can auto-stretch a graphic.

Then set up a relation between each main record and the record corresponding to the person in question. Now you can put the field with the color swatch into any records that tap this relationship. To use the swatch behind a portal row, you'll actually want to use a calc field in the file that's shown in the portal. So, if your portal shows visits by these various people, have each visit record use the relationship to fill a calc field (container type) with the color swatch.

To fill the row with the color swatch, make sure to stretch the container field to fill the whole area, use the Format>Graphic menu to tell the field to reduce/enlarge to fill available area, without maintaining original proportions, and send the field to the back layer.

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.