Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender

McG's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Gents Thanks for your help on this matter. The task is part of a high school assignment which is unlike any students have been presented with before. I'll look at seeing how your solutions can be utilised to make things easier for the the students.
  2. Min. roster is the numeric field that shows the minimum amount of players on a team. It's the value that we are comparing the number of players against. I haven't done the search in the teams table (where I could put a simple count function of all the related players in the teams table) because I do not want to count all the players. There is an additional criteria (let's say that players have to be either a Guard or a Small Forward). If I can do it in the teams table I would, but isolating the players who are part of a specific team and are also are either a Guard or a Small Forward is my area of difficulty.
  3. Results of a sort in a layout with 14 records displays the following: Team, Division, Min. Roster, Team Members Bulls, A, 3, 5 Eels, B, 2, 4 Sharks, A, 3, 2 Hornets, A, 3, 3 Team members is a summary field (sorted on team field) which counts the items in the sub-summary. I now want to display only the records where the team members is < min. roster (in this case the Sharks information woth 2 being less that the required 3). I've used a calculation involving GetSummary function to display "Yes' or "No' to show who has a full roster. Of course, then doing a search for "No" produces no results because the summary field value is not retained once the search is invoked. So. How do I search to find the appropriate information here? All help much appreciated.
  4. Database contains a container field. I want a script that exports the field content to a desktop folder as a jpeg. I have this working on my test machine just fine. However, if I go to another machine on the network it won't work because it's trying to look for the folder on the desktop of the machine I created the script on. So how do I set the file path so that a new folder will be created on the desktop of the logged in user regardless of the machine they use? This is the relative filepath I'm using: filewin:/C:/Users/sjhmcgivernj1/Desktop/S6 as S1 or S3/$test1.jpg Thanks John
  5. I have to teach pupils about field types - specifically text, numbers, data, time, graphics, calculated, link and boolean. This is the terminology I must work with. Boolean I'll just make a text field and apply a little validation. The one issue then is the link field type. How would one do this? Thanks John
  6. I have a field set as a checkbox list (5 rows high in the layout display). On another layout, I want to use only the chosen options from the checkbox list, but I want to display them in a single line separated by a comma and a space (I'm pushed for space in the new layout). The field will be displayed as an edit box in the new layout. So, assume the list below from original layout containing checkbox: A B C D E Options A, B and E are chosen. In the new layout, I require: A, B, E Any help much appreciated. John
  7. I assume nobody has a clue what I'm on about here. I'd hoped someone would say, "oh yeah, that happened to me. Here's how to fix it. Dead easy". Or not. If anyone has any ideas, do clue me in as I am mighty frustrated with this little issue. Thanks.
  8. I have a table in a database recording exam marks which links to a table of user details. Currently, all fields in the marks table are displaying ? and cannot be clicked upon. Doing a search in a field does returns the relevant data, but it is meaningless as again all values display ?. Adding a new record in the table works just fine, and previously the records contained all displayed fine. Is there any simple way of fixing this problem? I have tried deleting the relationship and re-establishing but to no avail. Thanks.
  9. Thanks Barbara, I have it all functioning perfectly now. I did have a solution before which used much of what you suggest, but I had many layers of extra (unnecessary) complex also included. No more! Thanks again.
  10. I want to have users log into database with user id, and they are then presented with their own record which they can edit. My way of doing this is rather convoluted, and I always thought it would be something straightforward using get(accountname). However, get(accountname) returns the account who created the record (which is always done by Admin), and not the user logged on. Is this correct? I attempted a script that checked whether user id matched get(accountname), but always got no match. So. is there a variation of the get command (or something else) that allows me to find the user logged on and not the user who created the account? Thanks for any help (using FMP10A).
  11. Thanks very much gents. I've seen Set Error On many times in scripts and never saw the point to it. I do now. Problem solved.
  12. Have a script that (or hopefully will have) that performs a search automatically on user opening a file. If their user name and current date already exist in a particular field, then the script goes to that record, which they will then amend. If the search returns no results then a new record is created. How do I get a script step to say, "if no records found do x" and also how do I get the the dialogue for no records match this set to NOT appear. Thanks.
  13. I have a field currently set as a checkbox set (values such as maths, English, art, PE etc). Assume the options maths and art are chosen. I want to create a script that examines this field and if it finds a specific text string (maths), then a new record is created in the appropriate related table. Right now my script will only work if a single option is chosen (maths only say), because I am simply using “if field = art”. I need “if field CONTAINS art”. Any ideas?
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.