Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About rudym88

  • Rank

Profile Information

  • Title
    I.T. Director
  • Industry
  • Gender
  • Location
    All over the world
  • Interests
    Computers, networking, and solving difficult issues

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    Windows 7 64

Recent Profile Visitors

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

  1. Thanks Siroos, How would i do that i am not calling a script from the main popover button Thanks rudy
  2. Hi gurus, I have a layout with a "popover button" which label is "Hold", inside the popover i have a global field for the user to enter a note, there are also two button inside the popover labeled "accept" and "cancel". I then have a script that creates a record in a related table all is working find except that i would like to insert the name of the popover button into a field. I am able use Get ( ActiveLayoutObjectName ) and set the name of the inner button but how would i get the name of the popover button. Thanks Rudy
  3. Good day gurus, As usual seeking some valuable advice. I am currently importing a price list, the source is a tab delimited files, I am doing a one-to-one import and all works perfected. Now the boss is requesting to be able to compare the last imported price with the previous import. What I was thinking was to create an additional table (e.g. import one, import two,) and adding a import date field in order to identify when the import was done. Then create a script to empty the second table, move the records from table one to table two and then importing the new data in table one. Can someone give me some ideas as I feel i am trying to reinvent the wheel Thanks Rudy
  4. Hi gurus, I'm seeking some advice on the best way to accomplish a task. I have a tables with about 110 fields, and i need users to be able to insert data into three fields at a later time via a popover. To accomplish this I am considering two options. Option 1 - place the fields in a popover and have the users populate them with the required data, in the pop over there would be two buttons one to close the popover which would also clear the entries and the other to commit and close the popover. Option 2 - Create global fields and place them on the popover where the users can enter the data and once a "Accept" button is pressed the data is committed and popover closed. The question would be, is using global fields to enter data on an existing record a good practice? Thanks Rudy
  5. thanks for the reply, For this solution I am using FM Pro Advanced. I can't user 16 or 17 as the file is hosted on a Ver 14 server. Thanks
  6. Goo day everyone, My apologies if I am posting in the wrong section. I am having an issue running DDR. First whenever I tried running DDR "HTMP" I would get a message that DDR was missing and required, after researching I created a DDR folder in c:\..extension\English\ folder. After creating the folder I stop getting the DDR missing error. Now I am able to enter a name for the DDR but as it runs I get the following message; "The file "summary.xsl" could not be found and is required to complete this operation "The file "Frames.xsl" could not be found and is required to complete this operation "The file "detail.xsl" could not be found and is required to complete this operation "The file "Toc.xsl" could not be found and is required to complete this operation It does create the individual files but empty. Thinking is my database I have tried creating a clean database but still get the same error. Any help is greatly appreciated. RudyM
  7. Hi all, I am sure this is a simple question for must of you, but for the life of me i have looked at different samples and cannot get it to work. I would like to create a new record from a popover. I started by creating a script with "New Record/Request" step. then i assigned the script to "OnObjectEnter" script trigger to the popover itself, the script does create the new record but the popover does not pop. What I am doing wrong. Yes, once i get this part to work i plan to add over actions e.g. what happens is "cancel" is press, or is the users closes the popover.
  8. Hi gurus, Need some advice, I am putting together a job tracking system for a print-shop and I am running into a dilemma where I need some advice. Our ERP is Sage 100, but unfortunately I have not been able to retrieve data from it using ODBC, it appears File Maker ODBC is not compatible with SAGE as I keep getting an error (it works fine from excel but not filemaker). I am currently exporting all the needed data to various CSV files and importing them into a single filmmaker database with a table for each CSV. some of this tables contain as much as 30K records. my issue is with speed. every time there is a lookup it sometime takes a few seconds. My question is, if I import the data to the main database would the lookup's be any faster. Thanks for any help
  9. Hi guys, I am trying to setup an external connection to Sage 100; From Windows I have configured the "System DSN" and it is able to connect and see 1129 tables. From Filemaker I am able to add the external data source without any issues. But when I go to Manage->Database and try to add table under data source I select the new data source and a popup asks me for a username and password but then it give me the following message "The ODBC data source you have selected is not supported" Can someone guide me on what it is I could be doing wrong.
  10. Good day FM gurus, I am having an issue when importing a "CVS" file into FM. I am receiving a daily file from a PBX, this file is in "CSV", one of the columns contain the start or the call and is formatted "11/9/2016 7:17", but when I do an import into FM it imports its as "2016-11-10 07:44:24", yes the field is formatted as a timestamp. The only way I can get the import to work, is if I open the file in excel and save it at "xlsl" then it will import it as a time stamp. What am I doing wrong.
  11. Good morning, Having absolutely no knowledge on ODBC integration with Filemaker I am seeking help for the community gurus. I put together a database to keep track of printing jobs and so far its working fine for us. The issue I have now is that some of the data we enter in FM comes from out ERP (sage 200 4.3) and I would like to create a lookup that would retrieve this data via ODBC. We use filemaker server and FM 2013 for the end-users. I have the following questions. 1 - do I have to installed the Sage client on the server or do I have to have on each user? 2 - when I configure the ODBC do I configure it on each client or only on the server t retrieve the data from sage? Any pointers to ingrate with Sage would be greatly appreciated. Thanks in advance for your assistance. RudyM
  12. Good morning all, I am trying to insert two portals in a form but, I have followed other samples but for some reason I cant get it to work in my database, I am attaching a sample of what I am doing hopping a guru can tell me what I am doing wrong. In short I have a ticketing system and I want to be able to enter ticket status on one portal but at the same time be able to view the status history in a portal below. Thanks Rudy Portal.fmp12
  13. Thanks for the reply, how about if I want the minutes and seconds. Thanks Rudy
  14. Hello FL gurus, I am trying to create a calculation using the "Timestamp" function but can't get the result I need. I am hopping someone can guide me. I have three two fields and two buttons Start Time (button once press it enters the time in the field using "Set Field" and "Get (Get ( CurrentTimeStamp )" End Time (button once press it enters the time in the field using "Set Field" and "Get (Get ( CurrentTimeStamp )" I also have a calculation field (Start - End) with a result of "timestamp" is if possible to ger a result to show elapsed days and time e.g start 1/1/2016 1:00PM - end 1/1/2016 2:00PM I would like the result to be 0 day and 1 hour e.g start 1/1/2016 1:00PM - end 1/2/2016 2:00PM I would like the result to be 1 day and 1 hour or I am better using two fields one for time and one for date Thanks RudyM
  15. hi all,  I have 3 field (see attached for layout)  field 1 is a checkbox field 2 is a pull down field 3 is a date  field 2 and 3 are placed on top of field 1  the issue I have is the if I place a check on any of the option on field 1 I can no longer select field 2 or 3, if there a way around this?   Thanks RudyM
  • Create New...

Important Information

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