Jump to content

bruceiow

Members
  • Content Count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bruceiow

  • Rank
    member
  1. bruceiow

    Report filtering woes

    Hi All, I am having issues with a report that I am trying to create. I have a report up and running and showing almost what I want, but a date constraint I have put on is just not working!! Here is my ERD: The basic crack is that I want to show a report of USERS, with a portal containing their JOURNEYS. I have built my report with the USER table as the basis, with a portal based on the CLAIM table, showing Journey::fromId , Journey::toId and "date" from CLAIM. The report is nearly complete, but the date script doesn't work: Enter Find Mode [] Set Field [Claim::date; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate] Perform Find[] This script is fired ok when the report loads, but I get records displayed on the portal that are not within the date range I have specified. Can anyone help me get this report finished please. Many thanks
  2. Hi All, I am reaching a crossroads where I need WebDirect and need to move from my shared host. Ideally I would like a VPS solution. I am an MSDN subscriber and was wondering if I can use a Azure VM to host my FM server and WebDirect environment? Has anyone done this with any success? If not what are the best options for me? Many thanks
  3. bruceiow

    report design advice

    Hi All, I am after a bit of advice on how I might be able to format my report a bit better. I have built a report based on a table and have a portal that then displays all related records. The report works fine in 50% of cases. The scenarios where it doesn't work is where the amount of related records exceeds the amount of rows shown by the portal. A scroll bar is displayed to the end user and the records can be seen by scrolling but this report is designed for printing. Some records will have 1 related record, some may have 50. I need to find a way of catering for both of those senarios on one report. Can anyone help, I feel that the portal is a great form tool but maybe not so useful on the reporting side of things. Many thanks
  4. Hi All, Am I going crazy or is there no way to sort data displayed on a popup menu? I have a popup menu that takes its data from a value list. The value list looks at a table in my FM solution and uses the ID field, also displays from the name field and has "show only values from second field" checked. This gives me a great list. However, my client has asked for custom ordering - we have a new field in the table called "display order", my clients will go in and give each record in the table a numeric value and then want the popup list ordered by that rather than the default ordering. Is this possible?! Many thanks
  5. Thanks guys - privilege sets get the unanimous vote of confidence! I will read up and implement.
  6. Hi All, My account on the web console only has "status", "activity" and "schedules". No one here knows of a master password that has any privileges above this account. I cannot seem to do anything other than view. What I am trying to do is setup a new schedule. Is there a standard master password that is set by default with FM server that I can try? Many thanks
  7. Hi All, I have a FM database that has a generic login. The system is used by ipad users mostly, and accessed from FilemakerGO without a prompt for user login. There is one layout on there that everyone should be able to access and one that should be security limited. Is it possible to limit access to layouts by logged in user? If so can I flash up the login box from a button click and check that the credentials entered have the relevant permissions to view that layout? Many thanks
  8. Hi All, I am storing files in container fields (held in the DB) and was wondering if it was possible to set a row level click event to open the file held within the container. To Explain: I have a layout that is set to show continuous rows. Each of those rows has a container, most with a PDF held in it. My Ipad users should be able to click anywhere in that row to open the file held in the container. I have seen script examples where a path is set to a temp location and the file written out to that like a cached item. I was wondering if that approach is viable on the ipad?? Many thanks
  9. Hi All, I have a container field that I want to expand to allow powerpoint files. Is it possible to display the content on my layout in the same way that a PDF shows? currently all I see is a thumb of the file type rather than the content of the file itself. Many thanks
  10. no - My date range was from 12th Jan 15 to 13th Jan 15
  11. Hi All, I have written a date search script to perform a search on a field called submittedDate. (this is a date field in a table called claim). I have a layout based on a table called person. Person is linked to Claim, claim.id = person.claimId. I have also created an unrelated table with globalstartdate and globalenddate fields. I have created a layout based on this unrelated table and put two date pickers on that view and a button. The button runs a script that does the following: Go to Layout ["MyClaimLayout"] Enter Find Mode[] Set Field [claim::submittedDate; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate] Set Field [claim::commital;0] Perform Find[] I run this and the between dates just isn't filtering. I have chosen 12/01/2015 to 13/01/2015 as my date range and a row from 01/01/2015 appears . Have i done something wrong here? Many thanks
  12. LaRetta - That has hit the nail on the head. Thank you :-)
  13. HI all, I have a table called "locations". That table has an (int) ID (string) Location Name and (int) valid. I am using that table as the basis for a couple of popup menu "values from" lists. I can't see anywhere in FM the option to create a custom value list. What I need to do is for one of the popup menus, only include values where the valid field = 1. in SQL terms it would be select * from locations where valid = 1. Other popup lists on there will need all of the rows, regardless of their valid setting. As far as I can see, there is only the ability to include ALL rows of a table or a custom list of hard-typed values. Many thanks
  14. bruceiow

    filtering records on a layout

    thanks for the help so far - Ok I guess what what I was angling at was asking if it is possible to have two controls on my form that are unbound that can form the basis of my search. I cant see why I would need to create a global fields for two controls that are effectively orphan. (i.e. they don't need to bind to anything because they are just allowing a value to be selected and then for that value to be parsed as a query parameter). Based on doughemi's answer I am guessing this is against the relationship based and tightly bound principles of FM. Which is fair enough lol. I will give the global fields a go. thank you for the suggestion. One further thing if I may, can I add any logic to say that if any row on the main table my layout relates to has NO rows returned in the one portal included on the layout, omit it from displaying. Many thanks
×

Important Information

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