svalenti

I am trying to figure out how to use the PHP Site Assistant to create a site that I can host the php files on a separate web server from the Filemaker server. Which of the files created by the PHP Site Assistant contains the address for the Filemaker Server?

Sumary fields in portals are the only way I know to display info from multiple relationships on the same page. I guess I should have mentioned that the original problem needed to include multiple relationships. Is there a way to create 1 summary report when I need to display results from 4 completely separate relationships? None of the relationships share the same parent table.

Thank for your quick response. I though of that, but I needed it more "Live". I actually solved my problem. Sometimes just posting the question helps me think! I used 2 fields 1 calculation field: rating_calc_10 Unstored, = If ( clients_consultant_assigned::rating = "10" ; "1" ; "" ) Then a summary field: count_rating_10 = Total of rating_calc_10 I just use the summary fields in the related portal and they dynamically update if I adjust the person the lead is assigned to or the date range. Works great!

I'm looking for a way to count records that meet a certain criteria. I have a field (rating) that uses numbers 7 - 10 to identify the motivation of clients. I need a summary type field that will display a found count of all the client records that have a rating = 7, another field that counts rating = 8, etc.. I'd prefer to do this without creating a relationship for each summary field.

Length() works perfectly. Thanx!

I am looking for a way to calculate the size of a picture placed in a container field. Needs to be expressed in bytes.

The 2 Constrain Found Set steps produce no results. I get the "No Records Found" dialog even though there are records that meet the criteria.

Using Version 7. I have a table with 3 types of clients (Inquiries, Transitions & Clients). Some of these are inactive. I need to make a script that will: 1) Find all the "Inactive" records (using the field: [status]) 2) Omit the records where Status is = to "Inactive" 3) Within this found set, I'd like to find all the records that are "Inquiries" 4) then let the user input any other find criteria using fields on the layout What they should end up with is records that are "Inquiries", not "Inactive" and have a few other perameters that they specify. Thanx in advance for your help.

There used to be a way to make the last blank row of a portal show up at the top of the portal. Does anyone know how?