Jump to content

Gather and combine portal data into single field


This topic is 4388 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Guys,

I have parent file which is related to a child table. The child table has a number of fields but I’m interested in getting the content from the two fields and putting the values into a field which is in the parent table. I thought I could use the list(child::fieldname) function which works, but theres an added twist. The twist is I want to merge duplicate portal entries into one, and that includes the price so for example here:

Portal record says

Item | Price

Red | 20

Blue | 10

Red |20

Red | 20

Green | 40

However I want to store the following in a field within the parent record:

Red 60

Blue 10

Green 40

Hope that makes sense?

Thanks in advance as always

Jalz

Link to comment
Share on other sites

There are several ways - it really depends on what's your purpose here. The simplest way is to summarize the child records by item in the child table itself. Summarizing a portal is not trivial, though it got a bit easier in version 11 - see:

http://fmforums.com/forum/topic/71906-getting-more-out-of-filtered-portals-3unique-values/

To summarize child records in a calculation field you would need to use a custom function.

Link to comment
Share on other sites

There are several ways - it really depends on what's your purpose here. The simplest way is to summarize the child records by item in the child table itself. Summarizing a portal is not trivial, though it got a bit easier in version 11 - see:

http://fmforums.com/forum/topic/71906-getting-more-out-of-filtered-portals-3unique-values/

To summarize child records in a calculation field you would need to use a custom function.

Thanks Comment, think I can work with this :)

Link to comment
Share on other sites

This topic is 4388 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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