Skip 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.

List calculation in field help needed by someone smarter than me.

Featured Replies

I have a text field that has a "list" calculation set up in it. It works great - however to make the data show up in this new field i need to recheck a check box to have any content initially show up.

My question is: Can I "refresh" these boxes so that they have the list info put into that field?

I have 30,000 records so i'd prefer not to do them one by one.

  • Author

Here's the calculation I am using.

List ( za__bulletEnglish01_p;za__bulletEnglish02_p;za__bulletEnglish03_p;za__bulletEnglish04_p;za__bulletEnglish05_p;za__bulletEnglish06_p;za__bulletEnglish07_p;za__bulletEnglish08_p;za__bulletEnglish09_p;za__bulletEnglish10_p;za__bulletEnglish11_p;za__bulletEnglish12_p;za__bulletEnglish13_p;za__bulletEnglish14_p)

One further thought is that it would be ideal if i could add a bullet after the end of each return so the items would show up like:

I tried adding a &"•" before each field but it is looking for a (

Could I write a script that would select those boxes with checks, uncheck them and have filemmaker keep track and recheck them?

The fields listed above only get content when the other fields are checked

Seem that me that you may need to change your structure. Once you have repeating types of fields such as za__bulletEnglish01_p, 2, 3, etc you really should be looking into a related table.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.