manatee Posted June 3, 2008 Share Posted June 3, 2008 I am having trouble figuring out how to count records in a portal that have a "checked" box. I have a check box field called "reserve" in a related table record shown in a portal. I need to be able to count how many of the records in the portal (related table) are checked and show that total in the main record. I have come up short so far. Thank you for any ideas. Link to comment Share on other sites More sharing options...
mr_vodka Posted June 3, 2008 Share Posted June 3, 2008 Instead of using a value list with the string "reserved", you can just have a value list with a value of 1. Then use this for your checkbox. There a numerous reasons why I prefer this boolean method instead of the standard checkbox, but obviously your issue is one of them. A simple summary field will total the checkboxes. Link to comment Share on other sites More sharing options...
manatee Posted June 3, 2008 Author Share Posted June 3, 2008 Thank you for the prompt reply. I currently have the value list as a "1" and agree with your suggestion for this. I guess where I am stumped is how to create a summary field for a count in another table. Essentially I need to count how many "1's" were check in another table. Hope I am making sense. Link to comment Share on other sites More sharing options...
mr_vodka Posted June 4, 2008 Share Posted June 4, 2008 Create a new field with a type of summary ( types such as number, text, calculation, etc ) in the child table. Then you can put that summary field next to the portal on the parent layout. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5802 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 accountSign in
Already have an account? Sign in here.
Sign In Now