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.

Simple Portal needed

JD2775
in Relationships

Featured Replies

Hi guys,

I need to create a layout that when one field is populated with a value, the other values populate automatically based off of the value. The process is the user will front load data via Excel, with about 10 columns of data. One of the fields is "SIID". What I want is a layout that has all the field boxes blank, and when the user enters a specific SIID the rest of the fields populate with the related data. I am guessing a portal is the way to go here, but currently I only have one table. How should I work this? Thanks

First of all I'd import all the Excel data into a table in FMP, with the SIID field unique so that duplicates cannot be created. Create a relationship between this table and the other one based on the SIID field.

In the other table, select the SIID field and display the related fields, or use auto-enters or lookups to copy the data into the other table.

A portal is only needed to display multiple related records.

  • Author

Thanks Vaughan. What is the "other table" though? This data (6 fields) will be imported into a single table. What fields should be in the other table? The SIID would be a unique 9 digit number, so no problems there.

Also, I should probably add...

In this layout after a SIID is populated, 5 other fields would populate automatically but I would also have a 6th field, a date/timestamp field that would need to be entered at that time. The rest of the data (Fields 1-5) are just for visual verification but are not to be edited, or the records altered in any way. Only the 6th field would get data put into it (which obviously has no data in it, until manually entering a date/timestamp)

Hope that makes sense.

SIID entered

Field1-Field5 (related data pops up, can not be edited)

Field6 (date/time field entered at that time)

EDIT***** Nevermind I figured it out, I wasnt thinking about this clearly. Table1 would have all the uploaded data which wouldnt be touched, Table2 would have 6 fields of data, (1 SIID, 4 lookup fields based off SIID, and 1` Date field). Then when I want to combine all the data together I would have a report of Table1 with an additional ::Date/Time field from Table2 brought in. Got it

Create an account or sign in to comment

https://fmforums.com/topic/80874-simple-portal-needed/
Go to topic listing

Important Information

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

I accept

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.