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.

Combining multiple fields into one

candreoli
in The Separation Model

Featured Replies

  • Newbies

Hi,

I am trying to take one database which has one ID with multiple records and combine the information of a field in those multiple records into another database into a single record.

example:

Database Contacts has the following fields:

ID

Name

etc...

Database Applications has the following fields

ID

Applications

etc...

Under applications the same ID is a separate record for each application listed. I want to match the application ID to the contact database ID and list all of the applications entries for that name into one field.

How the heck do you do this???

Thank you!! confused.gif[email protected]

You can do it by script and relation from Contacts to Applications.

But why you dont want to use portal for your goal?

  • Author
  • Newbies

Thank you. I have used previous versions and this task use to be much more difficult. Portals was easy.

One more question. When I tried exporting to a .csv the information in the portal was garbled. Any suggestions??

Create an account or sign in to comment

https://fmforums.com/topic/33122-combining-multiple-fields-into-one/
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.