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

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.

In one of my layouts, I have the property code set #1 in the tab order, but unlike other layouts, when I do a find, it selects another field.  Any ideas?  And, yes, the Find Mode is selected in the Inspector.  In Browse mode, it is in Table View if that makes a difference.

Hi

I have one table with fields for COSTCENTRE and ANNUALBUDGET.
The table has 7 records

I have another table with fields for COSTCENTRE, ACTUAL and TOTALACTUAL (which is a summary of the ACTUAL)
There are many records in this table

I want a report that shows the COSTCENTRE, its BUDGET and the total of all the transactions for that cost centre on the same line.
I would also like to see the variance between the BUDGET and the TOTALACTUAL
How do I do this?

The tables are related through the COSTCENTRE fieldKHub-for-EE.fmp12

Many thanks

Michael

filemaker pro 14 "save as pdf "
I created a layout with some labels and fields and tried to save it as PDF.I didnt used any scripts.But when i saved it as PDF,the field widths are getting reduced by few points.It is showing difference in widths in A4 size paper after i print the pdf.
Can anyone help me out of this problem.Thanks in advance.

Is there an easy way to put a portal scroll on the left side instead of the right?  Don't see an option for it in portal settings.

Trying to separate out addresses and cities that have been placed in the same field with only a space to separate them.  I've captured many street abbreviations, but how would I capture the address for something like 100 Hwy 16 Los Angeles?  I attempted to put a Find wildcard of ** like you see below to capture a two-digit number, but it didn't work.  Are there any wildcards that can be used in a calculation field?

PatternCount ( SuperMarketsList::Address; "Hwy ") = 1;
Left ( SuperMarketsList::Address ; Position ( SuperMarketsList::Address ; "Hwy ** "; "" ; 1 ) + 2 ) ;

I had a problem with import records function.In script i given arrange by option as"custom import order".But after running script for 1 time,when i'm trying to run for 2nd time,the option is reverted to "last order".Can't we fix this problem??.I searched everywhere,but i didn't found the solution.
Can anyone help me in this situation.

I've checked the version of FM and downloaded the exactly version corresponding updated from http://www.filemaker.com/support/downloads/ running the downloaded exe file as administrator on Windows 10.

I consistently get an installer message saying..

The upgrade patch cannot be installed by the Windows Installer service because the program to be  upgraded may be missing
 or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

FM Pro Adv works fine. I updated it to 15.0.4.400 today before running the updater, which I want to get the 32 bit ODBC driver.

It seems to be a Windows installer originated issue - 10 home Version 1703 OS Build 15063.726.  Maybe it can't find the FM install path.

At a dead end, anyone else had this or any ideas how to troubleshoot / workaround ?

Many thanks

The solution that Will gave me to auto start our Leads database so that employees won't have to do a File:OpenRemote, takes a long time after we upgraded from FM15 to 16.  I even recreated the database and created the table, fields, layout, and script from scratch and didn't save time.  The problem is that it takes so long to open (15 seconds?) that people click again and that hangs up FM.  It then never opens.
Start-FMNew.JPG
Start_Script.JPG