Jump to content

Nuos

Members
  • Content Count

    58
  • Joined

  • Last visited

Community Reputation

2 Neutral

1 Follower

About Nuos

  • Rank
    Developer

Profile Information

  • Title
    Psychologist, Developer
  • Industry
    Psychology
  • Gender
    Male
  • Location
    Canada

Contact Methods

  • Website URL
    http://www.humanedevelopment.com

Recent Profile Visitors

2,528 profile views
  1. Hi Nuos

    I've just seen a post by yourself on a topic about charting and you sounded like you really now your stuff! So I thought I'd be direct and ask you for help with a charting problem I have. I hope you don't mind. 

    Firstly I'm fairly new to filemaker. We have just upgraded to 15, run a server (FMS 15) and FM pro (15). 

    My problem is this...

    We have a record for each pupil (we are a small independent school) for each week to record their effort in each class (6 per day). So each record stores Monday lesson 1, Monday lesson 2 etc, Tuesday lesson 1 etc etc. It has a total and average also. This bit is fine, all works. 

    I have made a layout that sorts all records by week commencing and then by score (descending order) with sub summaries that includes the average score for all pupils for that week. Again works really well. 

    The chart I want to produce is a line chart that shows effort score averages over the weeks. I can get this for individual pupils, I can even get for pupils is a certain category such as male/female but what I really want is to be able to have multiple groups on one line chart so that we can compare.  

    My thinking on this is that I create the instances of the effort score table for each group (male, female, free school meals etc) each one filtered so that the average in the summary field only applies to that group. Then create a line graph that uses a new series based on each instance of average score in the table. BUT, I think I need a table that I can use as the layout source that doesn't use one of the existing instances or else the data is not accurate. So I kind of need a middle table to base the layout on that can then be related to  each instance of effort scores to display the data accurately. 

    Gosh I do hope this makes sense.  

    I would really appreciate your help on this as its been a big issue for me for some time. Once I crack this I can then use the same principle for other data we have. 

    Thank you.

     

    Joe

  2. I was encouraged by Jeremy to report here that I have independently verified this is the case. A few things I have learned. A Mirror Sync requires 1 (ONE!) connection to FMserver. Even for multiple users. You do need multiple seats with 360works though. B You have to have the application run as full admin (a data entry default does not work) even though Mirror Sync signs in as Admin - one compiled the user security setting is not changed. C ******* its fast! Im playing with install on timer to see if I can trigger Mirror Sync to run in the background once user has minimized the app. On open and On close scripts do not run very often under FIAS so strategizing sync will be necessary as user are now use to it "just happening". Im thrilled. Luck to all
  3. I'll let 360works respond officially, but uploading a file will often take hours if not days depending on it size. Might resolve if you check back in after a few days.
  4. I have rolled it out. Speeds are good with 30 tables being sunk. Round trip is about 30 seconds on wan and 20 seconds on lan. Managing errors is an on going issue. Getting a pescy field is not modifiable error that I can't figure out yet. Had to modify it some to allow table by table pull and push for debugging purposes. Also modified to resolve 504 errors where es_record_UUID has a different unique record I'd used on my system. But speed is ok
  5. Nuos

    one to one Tuition

    Message me.
  6. Nuos

    Preventing user collisions

    Ya thats about right. Just make sure you set the flag to off at the end of the script. Also, make sure the user is on the same field that the flag is set on - as it is not global (and cannot be). Make sure when you check the flag that that user is taken to the right layout and the right record. Let me know how it works ...
  7. Nuos

    Labels

    On any layout you can display a field or just the text of a field in a text object. I would use the later for every field in the labels screen. You can do this by adding a text object, the then go to insert >> merge field. You can also merge "get" variables. So in the container text object it would read "container: <<container number>> of {{foundcount}}". you can send me the file and I can show you what I mean if you need
  8. Nuos

    Preventing user collisions

    I can think of a few things to try. First, set a flag field. Make sure it NOT global. Befor the import script starts doing anything serious have it check the flag. If "on" exit script else set to on end if. The he second would be to not actually use a temp table. Rather collect the data into a global variable, format the data to display nicely, go to a layout set to display the global variable. When user confirms, import the data in the variable by looping through the records. The second method works well with SQL and would be the method I would use. But it is a more advanced method. Let me know what you decided to do
  9. Nuos

    Lets talk About FileMaker Development

    I am attempting to launch a new filemaker podcast (see humanedevelopment.com). After playing around, I realized that the show formate needed some interviews. But Im finding it hard to find people to interview as I live in a very rural and remote part of Northern Canada where FileMaker developers (pro to noob) are hard to find. So heres the pitch. I want to interview you. Yup. You. About how you got into Filemaker, the solution you're working on, the challenges you've encountered and how you overcame them. I am hoping to get the full range on developer - from the roped in employee, the weekend/weeknight warrior to the pro developer. Message me and lets chat about it. Marcus
  10. So It's fixed ... guess how It's stupid easy A real d'Oh Reboot the client computer ... FileMaker funniness.
  11. I am trying to get FileMaker to extract the content of the inbox in mail. The code works on my computer but on my clients it has an issue. The code sets cell "g_Email_Inbox" and when I query that cell from applescript it returns its contents but within FileMaker on my client's machine NaDa. It displays as empty and any scripts within filemaker see the field as empty. I have attached the script for your use. Both new up to date machines. Client is running FM13 while I'm on 14. I will confirm that is not the issue but I suspect it is not. Really need so thoughts on this ... Im stumped Mail GetMessages.scpt
  12. Nuos

    Lets talk About FileMaker Development

    Agreed. Hoping it goes well
  13. Nuos

    Lets talk About FileMaker Development

    No I didn't. What time does it start and how does it work? Any interest in participating in the podcast?
  14. Hey FM Devs I am starting a new Filemaker Podcast. Its been rattling in my mind for some time. Its called Filemaker Developer Journal. I want it to be a repository of development discussion and ideas. In this light, I thought it would be fun to discuss various solutions we have created, the process of creating them, challenges and how they were overcome. If you have a solution you would like featured, please let me know. Private message me and we can talk more off line - or mention it here. Or check out the podcast which will launch soon. http://www.humanedevelopment.com/filemaker-developer-journal/ Cheers, Marcus
×

Important Information

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