Jump to content

mr_vodka

Moderators
  • Content Count

    5,932
  • Joined

  • Last visited

  • Days Won

    21

mr_vodka last won the day on January 19 2017

mr_vodka had the most liked content!

Community Reputation

70 Excellent

2 Followers

About mr_vodka

  • Rank
    Candy is Dandy... But Liquor is Quicker
  • Birthday 08/24/1976

Profile Information

  • Title
    CTO
  • Gender
    Male
  • Location
    NJ

Contact Methods

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

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    17

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Window 7, 8.1, 10

FileMaker Partner

  • Certification
    7
    8
    9
    10
    11
    12
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance

Recent Profile Visitors

9,034 profile views
  1. If someone doesn't have one, it shouldn't be too complex to create one. Perhaps you can even use their music catalog starting template and tweak it if they have still include it.
  2. Haha... How about life, my wife, and the baby. 😵 Totally all those fault. 😁
  3. I agree with exactly as Michael said. I have created colored gantt charts using repeating calculation fields for this type of activity. P.S. BTW Hello Michael, it's been a long time my friend.
  4. Here try to take a look at this sample file. remove.zip
  5. Not sure if I am following properly but if you have a portal based on a table occurrence of studies, as long as there is no specific filter or join criteria that would stop it from not displaying in the portal, it should display when adding to the studies table.
  6. Yes you can use a dialog box. You can use a global field in the custom dialog so that your users can enter the search criteria. Then in your script, you would search "companyABC" in the related field. You can't search for it directly in the facilitiesIDfk field as that seems to only store the key. So if you haven't already create a relationship from facilitiesIDfk to a table occurrence of your facility table. Then have your script search the facility name in that related table.
  7. I'm having a hard time following overall what you are doing based on your previous posts. Perhaps a sample file would be beneficial. As for a particular order for the DISTINCT, if you have a serial ID and ORDER BY that field then it should sort by the order that the records were created. For example using you example... recID fruit 2 - Strawberry 5 - Blueberry 8 - Banana 9 - Banana 13 - Apple 12 - Apple 16 - Apple ExecuteSQL ( "SELECT DISTINCT fruit FROM yourtable ORDER BY recID"; ""; "" ) should work.
  8. I would start by checking under external data sources, what used to be under Define Relationships in fp5 for all your files. Second, if you have never done a conversion from fp5 to fp7 then I would highly recommend you read the documentation on the differences. https://www.filemaker.com/downloads/documentation/fm8_converting_databases.pdf And perhaps this can help you out as well. https://dbservices.com/articles/upgrading-filemaker-pro-part-1-filemaker-conversion/
  9. What happens if Kim creates 10 on her own, Matt 3, and Bill 5? Does Matt keep getting assiged whenever Rose creates a new quote? IOW is the quote being assigned to whoever has the least in the system to distribute evenly or should it just be distributed evenly only by Rose and indepedent of when the others enter in their own quote.
  10. Have you tried doing a gpudate and relogging in from the clients?
  11. It is optional. You can uninstall it, though then you would manually need to add the server IP for your clients.
  12. This error can come up with a user is entering a wrong password / user name combo
  13. I do find it kind of strange that the software puts the title as part of the URL instead of just using a post number as previous versions. Perhaps a few of us can try to somehow reconcile the issue working together.
×
×
  • Create New...

Important Information

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