-
Welcome To FMForums
Welcome to our community, full of great ideas on developing your FileMaker solutions effectively, or for peer-to-peer support of the FileMaker Platform and related products and services. Please register if you'd like to take part.
-
-
All Activity
This stream auto-updates
- Yesterday
-
Global(s) not writing until several log in attempts
Mr. Ignoramus replied to Mr. Ignoramus's topic in Script Triggers
Wim Decorte, This is all I have, I am just beginning to isolate. I have a "OnStartUp" script that writes information to globals ... as well as other scripts ... this "OnStartUp" script is where I'm going to begin ... I've attached a pic of the global field that I am currently trying to figure out what is going on. When I log in ( USA ), this fields writes every time ... however, when my user logs in ( Dubai ) ... it doesn't ? It takes several attempts ????? Any Ideas. It's the same script the second "LogIn". It's my "On Start Up" script. Anyway, any suggestion I would be grateful. Thank you. -
Global(s) not writing until several log in attempts
Wim Decorte replied to Mr. Ignoramus's topic in Script Triggers
We'll need a lot more detail about what the script does, how it is triggered and so on. -
Your runtime users can produce a PDF by printing and selecting (manually) the option to print to PDF. If you want to automate it for them, you will have to use a plugin or OS-level scripting. See also: https://fmforums.com/topic/98652-save-as-versus-print/?do=findComment&comment=448649
-
Hi pomilpetan, I don't think that this has changed, but it used to be that you couldn't create a PDF in a RunTime because of the license between Apple and Adobe. From the online help Compatibility http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Fsave-records-as-pdf.html As I understand it, Apple pays a royalty for each Application it issues, and there is no way to track those products that are listed as No. FileMaker Pro Yes FileMaker Server No FileMaker Go Partial Custom Web Publishing No FileMaker WebDirect No Runtime solution No Lee
-
Good morning everyone I created a database runtime solution with FileMaker Pro 15 advanced. The program must export the contents of a form in PDF format. In a solution that runs under FileMaker I could use the command "Save as PDF" but this command does not work in a runtime solution. Could someone tell me how I could make this function? thank you so much.
-
HI, Need some help / wisdom ... I, the solution provider never have a "Global" issues as being stated below ... I have a solution that some, not all of the solution global fields are not populating when the script writes to them ? A client had to move their DB to another server and upon upload, soon afterward, I was getting notification from the client that some of the solutions safety conditions were triggering messages where certain events won't happen ... upon further investigation, I've discovered that the "Users" global fields were not writing when the script would write to it ????? The user, after several "Log In's" attempts would get successful field entry for example like their global "Location ID and Location Name" fields. Any idea what would cause this ????? and only after several log in attempts would we / user be successful in their globals writing. Contacting the server was unsuccessful, they responded that they are only "Servers" not "Developers" sorry .... hmmm ? So, any insight to this issue would be grateful. Tom
-
I don't know if it would help anyone, but it's taken me a little while to work out how to use GetLayoutObjectAttribute - it didn't come up in my FileMaker book :-/ Here's the expression that worked. PKinPickClientPortal is the object name of the pk field in the portal. GetLayoutObjectAttribute ( "PKinPickClientPortal" ; "content" ) ="" Many thanks comment!!!
-
Thanks loads, comment. Sorry to take so long to reply - I'm on holiday with the family, and writing this database for my wife as light relief from drinking beer and swimming! I'll see if I can make that work - it's not something I've tried before. Very cunning though!! :-) Cheers, Mike Of course - that makes lots of sense!
-
Last year I posted a couple articles on the topic of virtual list reporting (part 1 and part 2), a.k.a. VLR. Today we’re going to look at some additional things you can do with VLR, and to avoid a lot of repetition, this article will assume the reader is familiar with the material covered in […] View the full article
- Last week
-
Running Filemaker Pro 11 and Filemaker Pro 11 Advanced under Windows 10 in compatibility mode for Windows 7. A customer has purchased a new HP LaserJet MSP426FPW that would not print reports from a filemaker solution I call MarinaPro. Everything works well on other customers Windows 10 computers connected to several different but older HP LaserJet printers. I found that the "Print" commands (Restore & No Dialog is set) within virtually all my associated scripts were set to a an HP LaserJet 4L printer I used at one time when creating solutions and that was moved to the trash heap several years ago. By clicking the print options "Specify" button, I had to select the current default printer and then I could print the reports. If you do not specify an output destination before saving the script or if the specified printer cannot be found when the script executes, the output from the script step is sent to the user’s default printer. I would have thought that "Print" should have found the "Current Default Printer". Any way to assure that it happens through scripting? In checking the available printers by opening Filemaker printer Setup, I can see several printers in the list that are no longer connected to the computer. Is there any way to clear or update the list of connected printers?
-
I presume QBXML is an XML file (there is very little one can learn about it by Googling it or 'quickbooks xml'). If so, you can import it as you would any XML file - with the help of an XSLT stylesheet to transform the document into Filemaker's own FMPXMLRESULT grammar. I am afraid that without seeing an example of the input file or its schema that's about all I can say.
-
I am currently using QuickBooks online. I have two years of data in quick books online, that I would like to import into FileMaker. Once done I will be canceling Quickbooks online. So my challenge is to get all my data from QuickBooks and imported into my invoice solution. So QuickBooks says they will let you download your data, but it comes as QBXML file, which I can't seem to figure a way to import and have all the things I need. Any suggestions. Clarence
-
Okay, then please explain what exactly do you mean by a "checklist", what is it used for and why is it necessary to recreate it periodically. Usually you create something in a database only when something new was created in real life. A mere passage of time is not a good reason to make any changes. Please leave that to the forum moderators.
-
Thank so much for the reply. The N/A was just an option. That's pretty much how I have my tables set. The problem I'm having is recreating the checklist for the same equipment. i will move the thread to design structure. Thanks.
-
I am afraid not. You have posted this under Interface Design, but it looks to me like a question about database structure. Based on the parts that I did understand, I would say that you need to have a Sites table and an Equipment table, related by SiteID. Possibly a third table for types of equipment. Then - I would think - comes a table of Issues, which would be linked to Equipment by Equipment ID: Sites -< Equipment -< Issues This is based on the assumption then whenever a piece of equipment develops an issue, a record in the Issues table would be created. Once the issue has been solved, the record would closed (e.g by entering a date into a ClosedDate field). But this doesn't fit your description of preparing a weekly checklist, or having a N/A value (indicating what?).
-
I hope Iv come to the right place. Im hoping someone can help me. I'm trying to make a solution where different warehouses have different types of equipment. What I want to do is for each site to create a list of equipment on site. Then create a checklist which will be done weekly for each of the equipment. For example one site may have: forklift, sweeper, trolley jack 1, trolley jack 2 etc. Once the list is created, create a check list for the list of equipment. The check list can be as simple as: Ok, N/A, Issue. Once the checklist is completed, I need to be able to create another checklist with the same equipment list. I hope this makes sense. If someone can point me in the right direction that would be great.
-
I have yet to come across a means of customizing the WebDirect login screen for a database, despite searching for every relevant term I can think of. Does none exist? None at all?
-
Come to think of it, that's not entirely true. Suppose you add a field that cannot be empty (such as ClientID) into the portal and give it an object name. You could then use the GetLayoutObjectAttribute() function to get the object's content - and hide the portal when it's empty.
-
Are there any examples of this tables & scripts functioning in the wild? Would like to push pull this data.
-
This is not going to be simple - and I am afraid it might turn out to be slow too (these two often go together). In a nutshell, portal filtering works at layout level - and you have no access to its results except by viewing them on screen. So your plan to use the results of portal filtering in order to show or hide the portal cannot work. You will have to replicate those results using another method. And that method will have to test each and every record in the Clients (?) table for the conditions stated in your portal filtering formula. This could be done using a custom recursive function or ExecuteSQL(). Or even a script triggered by modification of one of the global fields. The simplest one to implement would probably be to add an unstored calculation field to the Clients table to do the PatternCounts, and look at the aggregate result from the context of Shift. You could also switch the portal filtering to use the same field and eliminate at least some of the duplication. You don't really need those fields: just use the x relational operator with any two fields (or even no fields at all).
-
[ANN]Productive Computing Releases Exchange Manipulator Server Edition Plug-in for Exchange Web Services
Productive Computing, Inc. posted a topic in FileMaker Product & Service Announcements
San Diego, CA - July 21, 2017 - Productive Computing, Inc., a Platinum member of the FileMaker® Business Alliance, is proud to announce the release of the Exchange Manipulator SE (Server Edition) plug-in for Exchange Web Services. This server-side plug-in connects FileMaker directly to Microsoft Exchange Web Services, allowing users to push and pull Contact, Calendar, Task, Mail and Note data from an Exchange mailbox or with public and shared folders in an Exchange environment. "By utilizing FileMaker Server and “perform script on server” to handle the processing, users can shuffle data back and forth to Exchange using FileMaker Pro, Go, or WebDirect. Server-side plug-ins allow users to truly capitalize on FileMaker's platform versatility and flexible deployment for their apps. For the first time ever, FileMaker Server can talk directly to an Exchange server (without requiring Outlook) and you can queue up dozens of requests to process in the background in seconds." Marc Larochelle, Chief Executive Officer, Productive Computing, Inc. The Exchange Manipulator SE plug-in is confirmed compatible with FileMaker Server 14-16, Windows Server 2012 and 2016, Microsoft Exchange Server 2013 and 2016, and Microsoft 365 Hosted Exchange. This release also features new client and server-side demo files and a new Developer's Guide, Functions Guide, and Migration Guide for assistance integrating the plug-in. Scripting changes are required for those interested in migrating from using Outlook Manipulator to using Exchange Manipulator SE. Key features of Exchange Manipulator SE: · Import and parse emails from Exchange into FileMaker to create a complete archive of all email correspondence · Send plain text or HTML formatted emails with multiple attachments from FileMaker · Having your FileMaker data in Exchange allows all Exchange connected devices access to that data · Send official Exchange meeting requests and cancellations directly from FileMaker · Accept, decline, and tentatively accept meeting Exchange invitations · Push or pull tasks and notes between FileMaker and Exchange · Set due dates for tasks and mark tasks as complete · Get and set contact images · Push and pull information from any device using FileMaker Pro, Go, and WebDirect · Send email "On Behalf of" or "From" another user in the Exchange environment · Save messages as .eml files (allows you to archive your email in a FileMaker container or elsewhere) · Send official Exchange meeting requests to required and optional attendees · Set reminder rules to utilize the pop-up reminders within your chosen calendar application Benefits of a Server license include: · Added convenience of installing the server plug-in on one machine · Unlimited users on one server · Ability to automatically update changes to users' Exchange mailboxes using FileMaker Server's scripting engine · Communicate directly to Exchange without requiring Outlook · Communicate directly to any Exchange mailbox The Exchange Manipulator SE plug-in is available for an annual price of $3,000 for a Server license. The Server license includes a free copy of the client-side plug-in for development and authentication purposes. For more information on the Exchange Manipulator SE plug-in and to download a demo, visit www.exchangemanipulator.com or call 760-510-1200. FileMaker Pro Support and Plug-in Integration: Do you have database enhancements you would like to have programmed? Want help getting a plug-in professionally installed into your FileMaker solution? We can help! The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today. About Productive Computing, Inc. Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms. Productive Computing, Inc. also produces Core4 CRM and Core5 Starter Edition, two off-the-shelf productivity solutions designed to automate your workflow, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third party applications including Outlook, QuickBooks, Apple Contacts and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners. In addition, Productive Computing, Inc. is a full-service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4, Core5, or Vessel Service Solutions under a SaaS (Software as a Service) pricing model. Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected Platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance Partner of the Year award. Productive Computing, Inc. 950 Boardwalk, Suite 205 San Marcos, CA 92078 www.ProductiveComputing.com sales@productivecomputing.com (760) 510-1200 Press Contacts: Productive Computing, Inc. Keith Larochelle (760) 510-1200 # # # --------------------------------------------------- -
Many thank for your suggestion
-
How to use a global variable within a calcualtion field
Wim Decorte replied to docasar's topic in Calculation Engine (Define Fields)
This piece does not sound right. I would probably want to keep all the inquiries and set the price statically through a script instead of relying on calculated fields. Any calculations can be done in the script and the result stored. -
Hi comment, Many thanks for replying - sorry to be unclear again.. the filtering expression is: PatternCount ( Client_for_ShiftMenu::First Name ; Shift::gFirstName ) or PatternCount ( Client_for_ShiftMenu::Surname ; Shift::gSurname ) or ( Shift::gSurname = "" and Shift::gFirstName ="" ) The relationship is through a global field in both tables set to "1" - so everything shows before the filtering expression narrows it down. I have used a search global before to search using a relationship, but really like the PatternCount method and would prefer it if possible. Have I covered all my areas of confusion? Cheers!!
-
If you want to place the totals in a fixed position relative to the bottom of the page, then you must use the footer part for this. But that will only work if the entire invoice fits on a single page.
-
-
-
Who's Online 0 Members, 0 Anonymous, 71 Guests (See full list)
There are no registered users currently online
-
Who Was Online
31 Users were Online in the Last 24 Hours
- LosTraxx
- sparker
- BruceR
- Michelle Logan
- Lee Smith
- Wim Decorte
- Steve Martino
- hussamf
- bishop7262
- Frogeye
- doughemi
- Jonathan Hogle
- FMDuck
- randall riggs
- Mr. Ignoramus
- Mike Duncan
- rwoods
- Rick Whitelaw
- David Wikström
- pomilpetan
- jjfk27
- dpwilton
- normanicus
- David Zakary
- MikeKD
- Josh Ormond
- temp007
- Al Quimby
- melmitts707
- LaRetta
- Ocean West
-
Blog Entries
-
-
-
