Forum Discussion
MarkShnier__You
3 years agoQrew Legend
No Problem
Make a Combined Text Summary field on the Relationship where 1 Grant Awards has many Grant Contacts.
Then to make it look nicer, make a formula text field in Grant Awards like this so they list in a tidy vertical list.
SearchAndReplace(ToText([Combined Text Summary Grant Contacts])," ; ", "\n")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Make a Combined Text Summary field on the Relationship where 1 Grant Awards has many Grant Contacts.
Then to make it look nicer, make a formula text field in Grant Awards like this so they list in a tidy vertical list.
SearchAndReplace(ToText([Combined Text Summary Grant Contacts])," ; ", "\n")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- BethanyHudson3 years agoQrew TraineeThanks!But what if I need more than just one field? I need to be able to show the Vendor, Budget, Expenses, etc. for each of the listed contracts. Is that possible?--Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368
- MarkShnier__You3 years agoQrew LegendI miss read your original post that I thought you were talking about contacts and not contRacts.
but still "np",
Just make a formula text field down on the child table to concatenate all your fields into a single field and rol them up.
But you may want to reconsider your approach and instead just make the report off the Contracts table and lookup any fields you need from Grants down to Contracts. It would be pretty straightforward to roll up a few text fields but once you start trying to roll up numeric field and label what they are just starting to get pretty messy.
I think what you really want as a report of contracts showing certain columns from the grants.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- BethanyHudson3 years agoQrew TraineeI've tried a few different times that way but no luck. I'm able to get a few important fields rolled into the report (- field), but is there a way to have that field linked to the Related Contracts shown?--Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368