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.

Multiple layouts of large database

Featured Replies

  • Newbies

I am new to Filemaker, which after reading this you will probably realize.  I have a database of about 200 datapoints, obviously too large to put on one layout, I want to spread it across four or five layouts.  My question is how do you do this such that the end user, using an iPad, can enter the data on the first layout screen, swipe to the second and continue data entry, and so on.  I know where the slide control is, and can put it on the layout, but how do you tie the layouts together?

what do you mean by 200 data points? These are all fields in the same table?

 

And...what do you mean by "tie the layouts together?"

 

Please be more specific.

Why don’t you post  a copy of your file so we can get a sense of what you’re trying to accomplish.

 

If you don’t understand how to do this, just follow the steps that you’ll find at this link. ATTACH A FILE

  • Author
  • Newbies

Yes, all of the datapoints are fields in the same table.  All of the fields relate back to one particular item, so thats why they are all in one table.  I don't want the end user to have to do duplicate data entry of at least one unique datapoint on every layout in order to establish a relationship, thats why I created one large table.  I can't fit all of the fields on one layout viewable on the iPad screen, so i thought there must be a way to fill out the first layout, swipe the iPad screen and get to the second layout, fill it out, swipe, and keep going until all 4 layout screens, which is the entire table of information, is filled out.  I just can't figure out how to tell filemaker once the first layout is filled out and the user swipes, go to the second layout screen, etc.

Button on each of the first three screens that just has a "Go To Layout" script step attached to it?

Yes, all of the datapoints are fields in the same table.

 

This is almost certainly a mistake. You should post more details about what your data is really about to make sure, but I believe it's quite clear that you should have a related table for these datapoints, and make each datapoint a separate record there. Then you can use a portal to enter/view the related datapoints. The portal can be scrolled, or filtered to show only a selected group of the related datapoints.

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.