We help IT Professionals succeed at work.

FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Hi

I have a calculation field that, needs to parse another field.

Currently it runs like this:

I
f ( Middle(mimg_FileName;10;3)="Q9 " ; 
      "documento de identificação frente"  ;
      Case 
      ( 
         Middle(mimg_FileName;14;7) = "FotoMil" ; 
            "fotografia de militante";  
         Middle(mimg_FileName;14;9) = "AssinaMil" ; 
            "assinatura de militante";  
         Middle(mimg_FileName;14;7) = "Canhoto" ; 
            "canhoto";  
         Middle(mimg_FileName;14;12) = "AssinaTestem" ; 
            "assinatura de testemunha";  
         Middle(mimg_FileName;14;10) = "AssinaResp" ; 
            "assinatura de testemunha";  
         Middle(mimg_FileName;10;3) = "Q11" ; 
            "documento de identificação frente";  
         Middle(mimg_FileName;14;11) = "AssinatResp" ; 
            "assinatura de responsável";  
       "--" 
       ) 
   )

Open in new window


Now In need to improve it and make it a bit more complex. The problem I have is that, depending on having previously identified a "Q9", Q10 has 2 meanings, "A" or "B", so the calculation should run like this:

$$type = "" 
if ( Middle(mimg_FileName;10;3)="Q9 " ; 
      ["documento de identificação frente" ;  let $$type =("A")];
      Case 
       ( 
         $$type= "A";
          if (Middle(mimg_FileName;10;3) = "Q10" ;   "documento de identificação frente";  
[indent]    Case 
      ( 
         Middle(mimg_FileName;14;7) = "FotoMil" ; 
            "fotografia de militante";  
         Middle(mimg_FileName;14;9) = "AssinaMil" ; 
            "assinatura de militante";  
         Middle(mimg_FileName;14;7) = "Canhoto" ; 
            "canhoto";  
         Middle(mimg_FileName;14;12) = "AssinaTestem" ; 
            "assinatura de testemunha";  
         Middle(mimg_FileName;14;10) = "AssinaResp" ; 
            "assinatura de testemunha";  
         Middle(mimg_FileName;10;3) = "Q11" ; 
            "documento de identificação frente";  
         Middle(mimg_FileName;14;11) = "AssinatResp" ; 
            "assinatura de responsável";  
       "--" 
       ) [/indent]
   )

Open in new window



Well sort of (needs to be debugged...

Anyway, the question is: is there a manner in a Filemaker calculation to put sevral instructions as a single one?

any help is appreciated
0
Hi,

I need on my app to add a logo on my layout (Filemaker 18 pro), preferably on the header
How to I do it?

can anyone help?
0
Hi.
On my app, I need to insert a vast number of imagens on the database (in total, around 150,000). The pictures are JPG and they have specific filenames starting with my record ID.

So, I need to go to a specific record "NNNNNNN" on my base table "milBase", get its recordID (named "milHMD",  and, from that, locating file Names starting with "NNNNNNN  Q9", "NNNNNNN Q10" ... and insert them on the respective containers (We have 5 files per record).
Can anyone help me on how to do it?
0
On filemaker import  what is, in this context "perform auto enter options?"
0
Hi,

I am migrating from ms/access to filemaker 18. So, first, I am exporting the base tables to ms/excel and then importing the excel to filemaker.
As I am cleaning up and streamlining the database I first designed the new tables on Filemaker and  then started the import mechanism. But I am a real rookie on Filemaker and it looks that I am not able to complete the import.

The source Table is "tblMMR_base" and the target table is "milBase" (I want only some of the fields). But on the target, the milBase is greyed out and if I select a new Table to ba named the same as the spreadsheet, it will not accept the 1st record as field names, and will import everything

Screenshot-2020-03-28-at-17.54.13.png
can anyone help?
0
Seemed to be fixed for a while, but now two weeks later, the same employee had problems with Wing Dings showing up all over Filemaker again.  We had to reboot her PC as closing and reopening FM didn't even work.  She has FM16, latest revision and 256mb assigned in preferences.

Any other ideas than replacing the arial font?
0
How do you code a Filemaker SMTP email so that the folder path is a hyperlink?
0
Hello Experts
I have created a database in FileMaker Pro to manage musical instruments
There is a table that has 3 fields
- Instrument Type (eg: Guitar, Keyboard...)
- Brand
- Model
I then created a report of this table. It lists all the data BUT I only want this report to include data for which "Instrument Type" is NOT "Guitar".
I don't want to mask the Guitar information (this would leave some blank part) but to exclude it from the report.
How can I do this please?
Thanks
0
portal setupportal layoutdetail layout pageWhen I fill in the Building Code, it repeats for each  building( three times actually, even if there isn't a third Agency). It doesn't make any difference which row I enter the Building code. All three are the same. Is there somewhere that I selected something that "duplicates" the entry of the building code?
0
I set a field and set it to a calculation field and return value is"?" when I am using PC.
Server FM9
Client FM18
0
I'm trying to use a Send Event to create a file from Filemaker.  I was able to do it successfully if I quote the text; however, when trying to add a variable so that it would recognize our Property Code and Work Order#, it doesn't work.  It seems the $FilePath needs to be quoted, but I don't know how to do that in the calc without rendering the variable useless.  Any ideas?  See attached.  capture.JPG
0
I would like to set a text aloud function on FileMaker. is it possible?
0
I need an advice for filemaker file opening script.
I would like to set a launching script when opening a filemaker file and decide a layout, depends on the device type, like laptop vs smartphone.
0
How did you set up PDF Manipulator?  I was able to successfully have it interact once I recreated our PDF document and named the fields.  However, did you copy all the PDF Manipulator tables and fields (see screen print) over into one of your Filemaker files?  I'm looking for a best practice more than one right answer.

ScreenPrint of Tables and Fields
0
Have downloaded PDF Manipulator and went through demo videos, but it doesn't show case of data being inserted from EXISTING Filemaker fields into the pdf.  Or, do I create new fields with the name of the PDF fields and then enter the data?  Trying to avoid double entry.  Tried to get into FM Forums, but having a problem.
0
I would like to compare the text in a field before a checkbox set field is changed (OnObjectEnter) and after it is changed (OnObjectSave) to return what is different.  Is there a function for that?  Can't find it.
0
Boss want Filemaker to be able to export to a pre-existing Fillable form (Bloomberg).  Is that possible or what workaround would you suggest?
0
Have SuperContainer which allows me to drag and drop files on a container field, which creates a file path and stores the file in it.  However, we have some large files that tend to cause a drag on Filemaker, so I want to create a button where I can store "additional files."  Currently, I have about 30 large files I'd like to just dump in a folder on the server and have a button in FM that accesses them.  I'd like this button to EITHER open the folder path or create it if it is not there (opening is easy; the creating is the problem).  

Is there a way in Filemaker or SuperContainer or some other (hopefully free) method to do what I describe?  

Thank you.
0
Hello, I have a FM Pro 15 Advanced Script, which has trouble setting the specified field values, I've a feeling there is a 'Filemaker' way to do it and I've missed out a step or two but unable to so far to glean from forums what that might be. Any pointers much appreciate:

Context: table

Valid Relationship: table = table 7 on Field1, Field2, Field3

Script step that doesn’t work:  Set Field by Name [table 7::field4]; table 7::field4 + 1

Field 4 is number.  I am trying to get the current last record reference number for a document and insert the next number to specified field which is also a number. The calculation will return correct number to dialog assigned  as a variable. But not set to field. No obvious errors popup.
0
In Filemaker Pro 10 , can it be done or does it require a later version?
I want to have a default value in a field that requires a value from a value list.
Field is "Language" default would be English.
In Options for field
I selected Auto-enter and entered English in data box.
for Validation I choose Always validate and
                                          Allow change during data entry
Under Requires: Member of Value list

Most records will be English, so I don't want everyone to have to worry about filing in the field, only those that are other than English.
0
I have a script that enters an employees initials and date into a comments field and forces previous comments to the next row with a hard return.  However, is there a script step where I can have the cursor go back to the beginning or arrow up to the prior row with the initials and date because it is leaving me on the previous line.  I'm experimenting with this method instead of a sub table of comments shown in a portal since I'm in table format.  Thanks.
0
I had this question after viewing Filemaker repeating field problem.

The issue is with Filemaker Repetition fields.  In a Contacts file, I wish to place the entered value of the field "DP"  in the repetition corresponding to the day of the week in the field, "DP Day",  based on the value present in any repetition of the field"Day".    
Three fields:  Field 1. is "DP" ~ a single entered value;  
Field 2 "Day" ~ is a Text [7] repetition field ~ each repetition can contain blank or numbers (1 2 3 4 5 6 7 ) corresponding to the day of the week.
Field 3 "DP Day" ~ is a Text [7] repetition filed ~ contains the value of "DP" in the repetition corresponding to the day of the week.

e.g. If Field 1 -  "DP" ='s 100;  and Field 2 -"Day" contains (blank, 3, 7, blank, blank, blank, 4) in the repetitions; The resulting values in Field 3 - "DP Day" should result in the values (blank, 100, 100, blank, blank, blank, 100)

Looking for the equation that will result in the above solution.

Thanks for any thoughts on this.

Bill Rock
0
I created the following code to open an Excel file and select a particular sheet based on the Property Code that was previously copied into the clipboard.  HOWEVER, it stay minimized and blinking on my bottom toolbar.  I googled and try adding the 3 lines starting with Set MyObj=CreateObject("WScript.Shell, but that had no effect.  Any suggestions to bring it to the forefront and maximized.  Note, I start the whole process from a button in a Filemaker dbase layout so Filemaker is in the forefront and unfortunately remains there.  Thank you.

Dim xlApp, xlWb

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWb = xlApp.Workbooks.Open("N:\EXCEL\Files\SHARED TOOLS\Sales Reports\SALES REPORTS.xlsm")

xlApp.Run "'" & xlWb.Name & "'!SelectSheet"

Set MyObj=CreateObject("WScript.Shell")
myobj.appactivate "Microsoft Excel"
set myobj = nothing

'if the macro takes arguments, use:
'xlApp.Run "'" & xlWb.Name & "'!NameOfMacro", "Arg1", "Arg2", "Arg3"


'xlWb.Close True
Set xlWb = Nothing
'xlApp.Quit
Set xlApp = Nothing
0
Is there still no interactive way to sort a portal?  Last technique I used was to use tabs, duplicate the portal, and sort the portal based on the tab headings, which I have made one per column.
0
Client is using LogMeIn remoting service to access remote computers that are running a clinic app with Filemakerpro as a key component.  Through that arrangement, they are printing locally; in this case, prescriptions.

The LogMeIn system nicely sets up printers that are local to the user and remote to the application (note I've flipped "local" and "remote" here!).
Like this:
User remotes into application computer and runs the application.
User, via the app and remoting software, prints "remotely" (from the app computer) back to the client's computer environment.

The printer in question is networked and working fine.
It shows up on the remote app as a LogMeIn remoted printer.

Here is the problem:
Occasionally, prescriptions won't print at all .. I've been able to deal with that.
However, the next thing is that the prescriptions print off to the right edge off the paper and what is printed is mirrored.

I've fixed this before but it's been so long that I can't even find the solution any longer.
I have enabled Force Bitmap Printing to get the printing to work at all.
Now, my notes say: "will only print prescriptions using Java in order to avoid "mirroring".  I can't find any reference to that.  It's NOT about programming anything with Java I can tell you that!  I'm sure it's a selection but where?

This time I'll write it down... promise.
0

FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Top Experts In
FileMaker Pro
<
Monthly
>