Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Slogan
    are we there yet?

Breezer's Achievements


Collaborator (7/14)

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

Recent Badges



  1. if you have a field called "CreationDate" which is the day the orders are entered, you could do this for the "DateSold" field: Case ( DayOfWeek(CreationDate)=2; CreationDate-3; CreationDate-1)
  2. try what I had suggested, ie, adding a new field for manual overide, if this field is empty, calc uses user input, otherwise it will use whatever you have input in the overide field.
  3. Welocme to the FMForums...without knowing exacly why you would want to do that, you can use "Auto-enter calculation." You could, however, have an overide field, so that if the overide field is empty, use the calculation, otherwise use the value in the field. For example: field_c = if (isempty(field_z);field_a*field_b;field_z) where field_z is the overide and whatever you input in field z will be the value.
  4. Assuming the PO# is in the "Productnumber" field and the ID is a unique not empty field, you could create a self relationship based on "Productnumber" Then, make the field "Total_Locations" a calculation such as Total_Location = count(Location_self::ID)
  5. This looks great. Has anyone done this for Windows?
  6. Go to Mikhail Edoshin's Weblog where he describes the method of bypassing the IWP screen and using your own. http://edoshin.skeletonkey.com/2006/12/how_to_bypass_t.html
  7. I couldn't get the PHPSA to generate a site that has passwords so I enabled the guest account and PHPSA llowed me to generate the pages. Now the issue is, how do I set the generated pages with a custom login/logout so that when a user logs in, they can view or edit only their records based on the login credentials? What I envision is a home.php page that will be used as the logger, then propagate this through the other pages. Thank you.
  8. I would recommend starting with FileMaker since it is more user friendly and you can achieve most of your regular office automation in less time than Access. The report in question seems to be a 'juiced-up' report from the included templates that come with FileMaker so, lucky for you(John Mc), you can get going from day one. The template name is "Expense Report." I agree with comment that this type of reporting could well be done using sub-summaries, but that doesn't seem to be the consensus over at FileMaker, Inc. The template used one of my 'pet peeve'... go ahead, take a guess.... WE WILL HAVE THE ANSWER AFTER A BRIEF COMMERCIAL BREAK...
  9. If [PatternCount (Get ( PrivilegeSetName ); "UserPrivilegeSet") > 0 or Position (Get ( ExtendedPrivileges ); "fmiwp";1;1) > 0] Go To Layout ["Main"] else Go To Layout ["Menu"]
  10. If (Position (Get ( ExtendedPrivileges ); "fmiwp";1;1) > 0) Go To Layout "Main" Else Go To Layout "Menu"
  11. Verify your file references by going to File > Manage External data Sources > Make sure the paths are correct, it could be looking at your original data source. If that looks okay, try File Save As clone. The
  12. You probably need to base your relationship "Pay By Check" to a stored calculation field to capture the transaction month: transaction_month = MonthName(payment_date) Then use this field "transaction_month" for the relationship key.
  13. A few questions for you before trying to help. We need to know: 1. Do you already have a layout for generating the labels? If not, start with that. 2. Are these mailing labels or some other type of labels? If mailing labels, FileMaker has a wizard to help you with that. 3. Do you have a way of distinguishing your users, for example, sales dept, customer service, etc. This will be key in properly navigating or finding relevant data in what you termed as "for people whose have specific data in certain fields." Once we know the answer to the above, we'll gladly help you. Welcome to the Forum.
  14. Remove the check mark in the field control behavior from "Allow field to be entered in browse mode" and also do the same for Find mode.
  15. Breezer


    It is quite possible, infact there' plenty of threads addressing this issue: Follow these links: http://fmforums.com/forum/showtopic.php?tid/192202/post/276524/hl/filter/fromsearch/1/#276524 You can also be creative and use a drop-down list by using comment's suggestion from this post: http://fmforums.com/forum/showtopic.php?tid/193018/post/280309/hl//fromsearch/1/#280309 Portal_Filter.zip
  • Create New...

Important Information

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