Jump to content

Aussie John

  • Content count

  • Joined

  • Last visited

  • Days Won


Aussie John last won the day on February 20 2015

Aussie John had the most liked content!

Community Reputation

6 Neutral

About Aussie John

  • Rank
    wanna be master

Profile Information

  • Industry
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified
  1. Help with generating a list

    Some progress - I have managed to get a list of occupied slots for a given duration of class - but there are a lot of extra numbers at the end of each line. (totally stumped). To get that far I added an extra field into the DB (Slots) and have reattached the file. Here is an example of the result, Any help is most appreciated. RESULT 14.51212512130121251213512125121301212512 14.012125121301212512 13.51212512 13.012 12.5 12 This is the function: SessionSlots (StartasNumber ;Slots ; SlotDur ) Case ( Slots >1 ; SessionSlots (StartasNumber+Slotdur & "¶" & StartasNumber; Slots - 1 ; Slotdur) ; StartasNumber ) Where; StartasNumber = the Class start SlotDur = 1/2 hour (the available timetable start points at 1/2 hour intervals) Slots = Duration of the class/slotDur Test.fmp12
  2. Help with generating a list

    Hi Lee - that is sort of what I am after but the axis would be switched. Here is a screen shot of what I am after. If I can get the custom function to work I think I can achieve my aim using a related table and conditional formatting. The table of times lots ( screenshot) would be referenced to the Custom Function in the actual timetable (previously attached file.) Also the timetabling is actually quite complex as more than one class can occupy the space at the same time, hence the two sectors in the 9:30 and 10:00 time slots. cheers John
  3. Help with generating a list

    Been beavering away but still not getting it to work. - I have attached a file to assist. The Field with the custom function is "SlotList", SessionSlots(StartasNumber,DurationasNumber) Let([ Slot=.5]; //Slot length Case(DurationAsNumber>0;SessionSlots(StartAsNumber+Slot ;DurationAsNumber-slot);StartAsNumber) ) Test.fmp12
  4. I have a list of timetable line items with a start time and a duration. The classes can vary in length and the available time slots are 30mins. What I am trying to do is create a graphic view of this using conditional formatting. I have a separate table with records for each time slot. For my method to work the graphic table needs to relate to the timetable table and the problem is the timetable only has a record for the start of the class. I thought I could create a field in the timetable which lists the time slots booked via a recursive custom function. My attempts are failing and this is my code. Let([ start=(Timetable check all::Start); //start time dur=Timetable check all::Dur; //Duration SL=30*60]; //30min slot length start & "¶" & Case(dur>0;session(start+SL;dur-SL)) ) Any help appreciated. Cheers John
  5. Flagging records for later retrieval

    I thought it might be that but I think what I wanted to do is not so possible. Thanks very much anyway.
  6. Web viewer of Google maps not the same as browser

    My previous post resolved by issue. ?force=tt makes google run in full mode. Maybe your circumstances are different.
  7. Hello all - I think this is more complex than it seems. I have a table of rooms with variations criteria to describe it. Actually it is a lot of rooms (a university). I would like the user to be able to save a suite of rooms ideally with a flag field so a further search is by the flag only. This found set would be a "project" where the data can be analysed. Where it is getting difficult is the ability to have multiple projects, each with a Name for reference and reporting. Ideally I would like a portal which shows the full list of projects projects - say up to 10 options and a check box which acts as the search flag. My thoughts are I need three tables - ROOM Table>>>{=room ID=}>>>Flag table (used for searches) and a Name table For support I have added a file flagged rooms.fmp12
  8. Reporting a string of child relationships

    Thanks - I have decided to report by rooms and have a separate report for equipment. Not ideal but probably the best.
  9. Web viewer of Google maps not the same as browser

    That is odd as I have it on my iPad now and I don't see the lighting bolt (and the full features are still missing - e.g. plane) I think I have solved the issue - use ?force=tt at then of the URL
  10. Web viewer of Google maps not the same as browser

    Interesting - Im using Mac Sierra and FM 16 advanced. if I click the lightning bolt I only get a popup message " - You're in Lite mode Your browser version may not support the full Google Maps. Learn more" API is probably outside my level of competence.
  11. Web viewer of Google maps not the same as browser

    Thanks Steve that is the reason. Unfortunately I don't seem to be able to force the viewer into full mode and the lighting bolt doesn't give that option either. Must be a limitation of the viewer.
  12. Web viewer of Google maps not the same as browser

    My default browser is Safari. I do have chrome installed but the web image looks the same on both browsers
  13. Hello I have a personal travel itinerary database where I can view destinations and travel routes using the web viewer. I notice that when use maps.google.com.au the web viewer is different to the one I see in safari (Mac OS Sierra). Key features of the Bowser version are not available including a tab button to hide the destination information and additional travel options such as Plane. Anyone have any ideas why this is happening and better still if it can be corrected. For convenience I have attached a file showing examples. Thanks webviewer test.fmp12.zip
  14. Can't upload new solution to server

    It was to do with password protected files; under database server>> security>>Require Password-Protected Databases probably not your issue but it did catch me on a couple of files.
  15. Can't upload new solution to server

    There is a new v16 security option that can be unchecked in the admin console which will prevent uploads

Important Information

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