ContributionsMost RecentMost LikesSolutionsRe: Row Counter Thanks everyone. I use QB at my golf course for a zillion things including event scoring. In this case, I was scoring a high school tournament in which we had to identify the low overall golfer (easy), and also the low four golfers from each school, calculate the sum of their four scores, then rank against the other schools. My app has two tables. Parent is the list of schools, child is the list of competitors and where the hole scores are tabulated. I wanted Quickbase to identify the four low players for each school on the child table and then I'd simply have a summary field on the parent table to tabulate each schools (4 person) team total then sort on this counter total and report. I couldn't automate the task, so I simply added a checkbox to the scoring table, sorted the scores by school and gross score (with a tie breaking methodology) and checked the check box for the first four scores of each school. So the summary simply counted the check marks from each school. Simple with my small data set. But it drives me crazy I can write a formula in an excel spreadsheet to automate this exact task in minutes, but on Quickbase, it's so complicated. Jeff ------------------------------ Jeff Rogerson ------------------------------ Row Counter Can anyone council me if it is possible to create a report formula to count and display the row number in a report? (I know Quickbase counts the number of records in a report, but can this counter be accessed?) ------------------------------ Jeff Rogerson ------------------------------ Re: Can I Grab Summary Data From A Report Group Column And Apply To It To Another Table? Thanks Mark, so I am going to make the summary table on the employee list table, correct? This app is the redevelopment of an older app I am no longer using, and the employee table is the only table that pre-existed this project, so other than using it to supply employee data, never thought to include it as part of the numerical process. Thanks again, you are always so helpful. Jeff ------------------------------ Jeff Rogerson ------------------------------ Can I Grab Summary Data From A Report Group Column And Apply To It To Another Table? Hi, I have an app that contains four related tables. One of the common relationships amongst all of the tables is a list of employees. One of the tables generates a report that groups the employees to create a summary report of numerical data generating a total for each employee. Here is my problem. I want to use the report generated group value for each employee from the grouped field in another table, but can't figure out the methodology to do it? I know I can generate a summary field in the parent table, but this is a total of all records (of all employees). I want to break this down to collect or calculate the total for each individual employee and apply it to existing fields using the same employees as it appears in the child table. Anyone have any idea? Thanks Jeff ------------------------------ Jeff Rogerson ------------------------------ Re: Displaying a report outside Quickbase Did you ever receive a reply or come up with a method to post the report on your website outside of the Quickbase framework? I am looking to to the same. Jeff ------------------------------ Jeff Rogerson ------------------------------ Re: Exact Forms Thanks Mark, Take care, Jeff ------------------------------ Jeff Rogerson ------------------------------ Re: Exact Forms Turns out I was using an out of date template. Have since got the updated template. But now I find the form only accesses and displays the field values if I turn the app tokens off..... ------------------------------ Jeff Rogerson ------------------------------ Exact Forms Hi, Is it still possible to create an exact form? Is the template supported. I kept an old template on my desktop, but after clicking on Add-On, I can't seem to sign on to Quickbase, just get a mismatch error? Jeff ------------------------------ Jeff Rogerson ------------------------------ Re: Simple Form Rule Will Not WorkGood point, and it achieves the same thing, but eliminates the possibilty of someone filling in for player two and three, registering only two players, but circumventing the requirement. Thanks, Jeff ------------------------------ Jeff Rogerson ------------------------------ Re: Simple Form Rule Will Not WorkTurns out that using a formula field to trigger a message is the problem...... So, as suggested we simply set up the third field name as a required field (and as most people complete forms in the order they appear on the screen, until someone realizes that field is the golden ticket, it should work). I guess I should mark the problem as solved, plus I learned something. Thanks all. Jeff ------------------------------ Jeff Rogerson ------------------------------