We updated the server the past two days, you should see some speed performance of our site.

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. Btw your middlewords approach should have worked even without the substitution. This does depend on the separator though. I’m not sure, but if the string is seen as a number field and you have periods then it may not see then as separate words. Happy to be corrected on that.
  2. I think the OP wants the make three new fields, not a string. For the original question converting the period to a list with substitute is correct. Using getvalue function is the simplest way the separate in their own fields.
  3. Mac/Windows container field issue

    If I can say your request was rather long winded but I think I got the gist. You need a calculation field. One of the get functions returns a number representing the operating system of the user. If you use a case or if statement you can give each operating system it’s own string. You may have some perculiarities which need refining but this might get you started Hope that helps
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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.
  9. 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.
  10. 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
  11. 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.
  12. 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
  13. 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.
  14. 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.
  15. 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

Important Information

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