Jump to content

portal summary


kozakoff
 Share

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

Recommended Posts

  • Newbies

Hi,

I'm pretty new to FileMaker, so I hope I can explain my problem. In my database I have portals that contain up to 3 rows. Each row has a "status" field. I'd like to get a summary of one particular value in the field depending weather it is in the first, second or third row. In other words, if the "status" field of the 1st row says "done" and 2nd and 3d rows say something else, I want that to reflect in a separate "master status" field as "done". Same if "done" is in 2nd or in 3d row. Does anyone have an idea if it could be done?

k

Link to comment
Share on other sites

Create a second calculated field in you line items file based upon status:

StatusFlag (calculation, number) =

If (Status = "Done", 1, 0) <--- this could just say Status = "Done" and will work, it just looks confusing. The equation alone results in a boolean 1 or 0.

In your main file with the portal, create a field:

MasterStatus (calculation, text) =

If (Sum(PortalRelationship::Status Flag) > 0, "Done", "")

"PortalRelationship" is whatever the relationship name for your portal is.

-bd

Link to comment
Share on other sites

This topic is 7378 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.