Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

Using calculations, are there any way to grab 1 value from diferents related records?

Maybe is a stupid question… but I'm blocked.

To give you an exemple… It's like a Client - Contacts relationship. You have 1 client with 22 contacts. I would like to pick up just the surnames of this related contacts (separated by commas), but in 1 calculation field only (no portals, no print), result= Text.

Any ideas, please, please, please

Posted

The 'ValueListItems' function might be able to do this for you.

Define a value list returning related data from your surnames field.

Then define a calcuation field using the 'ValueListItems' function (have a look at FileMaker help fo syntax). I think it returns a list separated by carriage returns, you could use the substitute function to change the returns to commas if required.

I haven't tested this, but it might get you on your way to a solution.

Posted

Thanks, Surwoop…

but the field that I want to grab is a unstored calc (It's like… in the Clients-Contacts exemple, to get all surnames of 1 clients but only those from the same city, for exemple!!)… so It can't be indexed.

That's why I can not use "Valuelistitems" functions.

Nice try anyway. thanks.

It should be another way to to that, shouldn't it?

(No portals, no scripting… just calculations and relationships)

Posted

No scripts, unstored; the only thing I can think of is FileMaker 8 and a Custom Function using GetNthRecord(field, #).

But I think you're wrong about the "unstored". The value list can be "filtered by" a relationship, using Client AND City (or a global City choice), related values only, from Client. The fields themselves, in their table, are still indexed. ValueListItems() will work.

This topic is 6962 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
×
×
  • Create New...

Important Information

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