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 to copy portal data in field?

Kip
in Portals

Featured Replies

Hi portal wizards,

I have two databases connected to eachother: "related projects" and "all projects" with a relationship called "projectid", matching the field "projectid" from "related projects" with the field "projectid" from "all projects".

In the database "related projects" I have created a portal that (in case of a match) displays the related records in the following related fields:

code artist title

BONJA-001 james bond the secret filemaker tricks

BONJA-002 james bond the secret revealed

I am searching for hours now for a way to copy all data (or per row) displayed in the portal into another field making it possible to do other things with it)

In the field the data should be separated by a tab which would result in:

BONJA-001 james bond the secret filemaker tricks

BONJA-002 james bond the secret revealed

Can someone help me please. I think I am overlooking something, but I can

Hi Thomas, good to see you again. laugh.gif

It would probably be easiest in the main file to

Set Field [text, ""]

Go To Related Records [show only related, allproj]

Perform Script [sub-scripts, External]

Refresh Window

In the related file, the external script would be

Go to Record/Request/Page [First]

Loop

Set Field [relproj::text, relproj::text & Code & " " & artist & " " & title & "

  • Author

Hi man!

Good to see you again too! Your solution works like a charm. Thanks very much.

Create an account or sign in to comment

https://fmforums.com/topic/23788-how-to-copy-portal-data-in-field/
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.