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.

How is unstored field data accessed?

Featured Replies

To all you Filemaker experts. Here is a technical question that I have been wondering about.

Explaination:

I have two files.

File1: has a field "graphic_og" which is a repeating global container field. It contains different graphics in each repetition of the field.

File2: has an unstored calculation container field "status_ou". The calculation that is evalutated is:

Case(

blah = 1; GetRepetition(File1::graphic_og; 1);

blahblah = 1; GetRepetition(File1::graphic_og; 2);

blahblahblah = 1; GetRepetition(File1::graphic_og; 3);

something = 1; GetRepetition(File1::graphic_og; 4);

"")

So I am displaying a different graphic, from the repetition field, for each record in File2 depending on what is true.

Questions:


  • Where is this calculation evaluated? At the File1 or File2 point?
  • If these two files where separated by a network, LAN or internet, on two different machines, what kind of network traffic will occur?
  • Which would be better to do, have the "graphic_og" field defined in the same file as the "status_ou" cal field or not and have the "graphic_og" defined in a local file where the user is and the cal field in a remote file?

My thoughts:

My first thought was that the remote file contains that cal field and the repeating graphic field. This way less data (graphic image) is sent through the network. The cal is evaluated remotely and graphic sent once to the local user file. Instead of the graphic being sent twice, from user local file to remate file evaluated remotly and then the correct graphic sent back to user.

Am I wrong? Is this all done at the user's local file and so the graphic repeating field should be stored on a local machine file?

Any insight is much welcomed.

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.