Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
  • Location
    Thunder Bay ON Canada

FileMaker Experience

  • Skill Level
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Sierra 10.13

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

tbcomputerguy's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. I have an excel sheet that controls bills of ladings for a forestry company. In the example you can see that there is lots going on with this Bill. It has a payperiod, mill, truck that delivered it, etc. I would like setup a database to monitor this. The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers. There are 6 contactors. The percentages in each line are the amount of the volume they performed In the third line there is a value in CT1 only...they get 100% of the volume. I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids. All 6 contractors could be involved in one BOL. Each one of these jobs, cutting, skidding and processing each has their own respective rate of pay as well. I think i need a way to break down each line so that I can produce pay summaries for each of the contractors. I had started this years ago, and thought I asked in a forum, but can't remember where. Nonetheless, they stopped using multiple contractors per load...Now they have returned, so I am back at it. So if this is a repost from years ago I apologize. Thanks in Advance tbcomputerguy
  2. Sorry I mean javascript. Cute cartoon and the eggtimer file is quiet cool...i think that might come in handy. I will have a go at this. Sorry I had to edit this..just thought of something. Would this be implemented with a script trigger attached to a layout or just attached to a button from the nave screen. Thanks again Dave
  3. Ok thanks. I believe the later of the two is beyond my skill level or at least i have not ever used java in filemaker or java at all for that matter. the first I believe you are telling me to do a loop and then on the 60th run them both. So my understanding is, you are saying I can run two timers in one script but not two independent timers in one window. Correct? And could i not open a second window, move it to the background and run the update script. Dave
  4. I have this little app that uses google sheets as its base for the data. When the app starts, it runs a script that downloads via insert from url a google sheet and stores it in a container field. it parses it all out into fields etc. As you can see in the pic, the bottom line in yellow shows the current dance. done by comparing current time against another table via join. This value is derived by a InsertOnTimer script that runs every 15 seconds and flushes the join to keep current dance value at the top. My problem is, when there is a change in the spreadsheet (btw this is the clients choice of storage) I need another timer to run in the background that checks every 15 mins or so and notifies there is an update. I have the update script working seamlessly..about 10 to 15 seconds for 810 records and 7 fields, and can do this update manually as well from the preferences screen. I can't for the life of me get the timer to run to check for updates. I understand 1 window 1 timer. I think it would be nice to notify the users of the change in data. I have tried to used the push notification as well...again works but will not kick because one window one timer. And I have read that the timers are windows based and not layout based.. So thanks in advance. it is late here so if clarification is needed just say so. Dave
  5. Of course it can😀 My question was somewhat rhetorical in nature. I think i should have asked, does anyone know of any such reliable barcode database api that I could try to access and then try to parse the data. Or at least a service that they have had success with? Dave
  6. Is it possible to have filemaker receive a barcode from a scanner (i know it can) and have it lookup the barcode online through an api then parse the data into fields. I am assuming the webdata will probably come in json.
  7. I am pretty sure it is not possible to get the data any other way. They use some special software designed to host dance competitions. It sets up the schedule and spits it out like this in excel format. Then I import it. I suppose I could find and replace the Pipe with even a space. I think they do it to make it easier to see all the participants in that number. Some dances have 25 kids. If they didn't put some sort of delimiter it might become hard to read. If you suggestions by all means. In the mean time i will work on the above. Thanks, Dave
  8. Hi i have a file with approx 800 records. Each record will contain a field called participants. No two records are the same but can contain the same participants...meaning other fields make them unique of course. There are no duplicate dances. But, record one could contain Ann smith, record two and others could contain various records like below. I am given these records as presented. they do the leg work I import it. I believe i have to convert it to a return separated list and then filter it to get the unique records. Seems east for one field but for the whole group seems tricky. evno participants 1 Lydia Wiggins | Susan Barton 2 Susan Barton | Charlotte Watts | Jai Roberts 3 Charlotte Watts | Jai Roberts | Katelyn Parsons 4 Jai Roberts | Katelyn Parsons | Elena Sullivan | Leona Matthews | Bronwyn Ho 5 Katelyn Parsons | Elena Sullivan | Leona Matthews | Bronwyn Ho | Emmanuella Gunn 6 Ruth Stott | Rowena Hammond 7 Harri Hodson | Daisy-Mae Bolton 8 Wilma Heath **Note: the Pipe Separator is how i get the data and how they would like it. Resulting in a unique list as so: Lydia Wiggins Susan Barton Charlotte Watts Jai Roberts Katelyn Parsons Elena Sullivan Leona Matthews Bronwyn Ho Emmanuella Gunn Ruth Stott Rowena Hammond Harri Hodson Daisy-Mae Bolton Wilma Heath
  9. Hi I have explained to them the licencing and that there should be no problems...then they asked what if we charged $2 for the app..what then? I said I would get back to them. So here I am. Any thoughts?
  10. That is exactly what is happening. The user will not change anything. If the host (company) has a change, I suggested using the csv method to update the schedule. Letting them know there is an update could be tricky as not everyone checks their email regularly. And I don't think they can be notified any other way, not without integrating a server. Perhaps i could create a script that would check the checksum value or size of the csv on a host via a timer every 30 mins or so and if it has changed from the original then notify them. then do the update. Thanks Dave
  11. I am doing some work for a local company and we were talking about moving a paper resource to the ipad/iphone/android. All data will be static and for visual purposes only, no access needed to servers. All data is set before hand (schedule of events) and will not change for the most part. They will view/search the data only. Perhaps if there is a change in data then update via csv. I have read lots on that and I am not concerned about that. So my question is, if we produce the static file and send it to the 10-100 people that have fmgo on thier phone, what licencing issues are we facing. If we have to by 100 licences then that is quite costly could potentially send us in different avenue like livecode where it can be produced and packaged for both IOS and Android. Ideally, use filemaker to produce the file and have livecode convert the fmp12 to android version..not tested but looks cool. Thanks, Dave
  12. Ok, firstly not sure which section to put this in. I couldn't pick one so i started here. Admins please move it to an appropriate category if you wish. Anyhow, I was approached by a friend that asked me if this can be done in Filemaker. His plan is to have one master database of inventory that many different vendors will have access to but only to change their or add their own products. Then say in city one we have a store with a pos system (Filemaker). They will manage their own products in that store, but still have access to the master product catalogue if you will, to look up products that one or many vendors may sell. So the POS systems are separate from each other as they are their own store. Yet any of them can access the master database and put in purchase orders to order products from the various sellers. One problem i see is once a store owner orders various products from this master database..i'm told will have about 10000 items, without sending separate purchase orders to each vendor, how on earth will the store owner receive the products they require. I guess i could have it generate a list of items ordered and create purchase orders based on vendorid. as soon as the vendor id changes, create a new one and script emailing it. I guess my question is can something like this be done and would I have to store this master db on the cloud, or just a fm server someplace. Dave
  13. Currently it captures the id when they startup the program then stores it in a $$variable that everytime a record is created it inserts it in a field, but as I am typing this a light went off as a result of your post...of course there is not need for that script. Just everytime i new invoice is perform the calculation. Then just do a report for sales based on the id..correct? Dave
  • Create New...

Important Information

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