Go Premium for a chance to win a PS4. Enter to Win

x

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

I need help building the following JSON using native Filemaker 16 commands

{
    "vehicles" : [
       {
         "vehicle_id": "my_vehicle",
         "start_address": {
             "location_id": "berlin",
             "lon": 13.406,
             "lat": 52.537
         }
       }
    ],
    "services" : [
       {
         "id": "hamburg",
         "name": "visit_hamburg",
         "address": {
           "location_id": "hamburg",
           "lon": 9.999,
           "lat": 53.552
         }
       },
       {
         "id": "munich",
         "name": "visit_munich",
         "address": {
           "location_id": "munich",
           "lon": 11.570,
           "lat": 48.145
         }
       },
       {
         "id": "cologne",
         "name": "visit_cologne",
         "address": {
           "location_id": "cologne",
           "lon": 6.957,
           "lat": 50.936
         }
       },
       {
         "id": "frankfurt",
         "name": "visit_frankfurt",
         "address": {
           "location_id": "frankfurt",
           "lon": 8.670,
           "lat": 50.109
         }
       }
    ]
}

Open in new window

0
Free Tool: ZipGrep
LVL 11
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

I have a layout that is able to display a field that is defined as a calculation in its table. The data displays correctly. I then decided to add three more fields on  my layout using three more fields that were defined as calculations. When navigating through the records, i notice that only one of the four fields on my layout displays the data that is calculated on the table.  It only displays one of the four, not two or three or four, but just any one of the four.
Table A (User Settings) is in relationship with Table B (Device Settings).
The fields in the relationship are two:
ContactID = ContactID
UserLocation = DeviceLocation

All fields are entered in DeviceSettings table.
There is a dropdown on devices that is used to select the employee that is assigned that device.
That device is also entered with a value of either for field DeviceLocation: Local, Remote, etc.
The layout called User Settings is a layout that will house all the devices assigned to a user.
If an employee is at the local site as there work location, the relationship should display all items associated with that employee contact ID and place them in there corresponding field.
I used in the UserSettings table on the four fields the field type as : calculation.
I used the If structure to calculate the field. It works correctly when only one field is on the layout with the calculation field, but the moment i enter other calculated fields on the same layout, it only displays one of the four …
0
The db is for tracking students that take classes, there are diff classes.

CPR/AED
CPR/AED & First Aid
BLS
APLS
PALS

I want to be able to display 2 numbers.

I want to do a cal for the total number of students in each class...
so if there has been 50 CPR/AED classes in 1 year ( 12 months) I would like to get the total of that, one total for each class.

Then I would also want to get a total for each student in each classes, but for each company...
so if I teach the guys from the Coral Gables Fire Dept BLS/ACLS & PALS I want to see how many guys took the BLS and how many took the PALS ect...


so I want something like this...

Total students in one year  = 500
Company CGFD = 300
Company MDFD= 200

CGFD BLS = 250
CGFD ACLS = 125
CGFD PALS = 125
____________________
NDFD BLS =100
MDFD PALS = 100

I need a break down like the above for reports and some of will be on the layout for a quick look to see how many per company so far have taken which class.

If someone can show me how it's done as I have no clue how to string cal (put them together)

Thank you

Respectfully
J.Pineiro
0
I need a custom function for filmmaker that will create an EAN 13 string of 13 digits, with the 13 digit being the checksum from a 12 digit input.
0
Here's what I'm working with...

$FindInvoiceRecord = $FMInvoices->newFindCommand('Data Entry (XGA)');
$FindInvoiceRecord->addFindCriterion('InvoiceNumber', $InvoiceNumber);
$FindInvoiceRecord->setScript('wa_CommitRecord');
$FindInvoiceRecordResult = $FindInvoiceRecord->execute();
$FoundRecords = $FindInvoiceRecordResult->getRecords();

$FMInvoiceRecordID = $FoundRecords[0]->getField('zRecordID');
$OriginalInvoiceNotes = $FoundRecords[0]->getField('InternalNotes');

Open in new window


This works fine and loads my data as expected from the FileMaker record.  Then i'm trying to update the record...

$InvoiceUpdateData = array('InternalNotes' => $NewInvoiceNotes);
$InvoiceUpdateRecord = $FoundRecords[0]->newEditCommand('Data Entry (XGA)', $FMInvoiceRecordID, $InvoiceUpdateData);
$InvoiceUpdateRecordResult = $InvoiceUpdateRecord->execute();

Open in new window


But this is telling me that newEditCommand() method is not found..??  Any information on what I'm doing wrong here would be greatly appreciated.  Thanks!
0
Hi,

I need to make a Filemaker Pro application that will match a value in a table just like the following Excel formula:

=INDEX($B$3:$F$7,MATCH($A$11,$A$3:$A$7,1),MATCH($B$11,$B$2:$F$2,1))

I also included the Excel example.

Tariff_v1.0_2.xlsx

Thanks for all your help :)

Cheers,
Rene
0
We've been running filmmaker 14 with web direct for about a year with minimal issues, all of a sudden users on the web direct are getting the error message Database not available on all databases which are only three.  Even the sample database gives the same error message.  This happens whether it is an external source (computer outside of the office) or internal computer, the regular FM Pro application works fine but the web direct gives that error.  There are no periods in the filename as I have seen in some issues and can't seem to figure this one out.
Even did it on the server that is hosting it and you can see the error message.fm1.jpgfm2.jpg
Any troubleshooting suggestions?

Thanks
0
I created a layout based on a table (People). There are two global date fields in the table that I placed on the layout. When I go into Find Mode I can not enter any thing into those two fields.
Can it be done, if so how?
0

Would like to contact the person who helped David Aaron's with his freezer issues in April, 2006.

I am not able to view the solution that was provided.

I am having similar issues with my current setup and was hoping this solution would also assist me.

Thx!  J
0
Hi experts,

I have a FM solution hosted on a Windows Server. All scripts performed on the server are suddenly responding slow. There are currently only 4 scripts called to perform on the server. All independent of each other and responsible for totally different tasks.

Everything was working fine until yesterday when I imported 30K records into 3 tables. I personally don't think the import has anything to do with it as none of the scripts instructed to perform on the server touch the 3 tables or the records imported. If I go to the layouts for those tables on the client side, all 30K records load/display just fine. Even if I set an empty script to be performed on the server and wait til completion, it still has a significant delay....

I restarted the server, just to rule that out but same issue. There is enough space and RAM as well.

Any suggestions?

Thanks in advance.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Dear experts

I want to open a database from a script and the name of the database is only known at runtime.
What I found on google and what i tried did not work and i don't know why.

According to google, in the the script I

1) set a text variable $filename to contain the name of the database like DatabaseA
2) use the command open file "extDB" to open the database

in external data source management i have defined extDB as a of type FileMaker and the path ist file:$filename

When I run the script the error is 'can not open file "$filename.fmp12" (not found)'. It seems that the variable is not resolved but the name of the variable is used as the name of the file.

This is on a Mac (10.11).

Any help is highly appreciated!

Roger
0
Dear experts

I hope to find help with a problem I haven't seen or heard of before.

I have a user in my Win2012R2 AD - let's call her DOM\Alice - with a Win10 client. Alice's roaming profile folder on the client is "split" into
C:\users\alice\...  and C:\users\alice.DOM\. By "split" I mean most of the profile's subfolders (documents, download, etc., and also NTUSER.DAT) are in C:\users\alice but  the desktop folder is in c:\users\alice.DOM. There is only one user dom\alice in the list of profiles, no local user.

When the roaming profile is synced, only the content from c:\users\alice ist copied to the server into alice.V5  but not the Desktop folder in c:\users\alice.DOM.
My Documents, Videos, Pictures and Music folders are redirected.
It is possible that the problem started when the user upgraded from win7 to win10 (not verified yet.)

Is it best to use the "move folder" option from the context menu of the "Desktop" icon in Windows Explorer to fix things?
Other options?

Thanks a lot.

Roger
0
Does anyone know of a solution for fixing the Reader DC print dialog box locking up when printing a PDF from a web window using FileMaker Pro 14/ Runtime and Windows 10? It worked fine until upgrading to Windows 10. When the print dialog comes up nothing can be clicked on unless you minimize the FileMaker app first
0
WHen I into my admin console and try to close a database with no one connect to that database it seems to be doing nothing.

What is causing this and what would be the command line to save for example close rabbit.fmp12 ?
0
I added fully qualified ssl certificates to my remove fms14 server and rebooted the server.
When the server came back up no one is able to connect to their fmp12 files.

What do I need to do to fix this ?
0
We have a commission report I am trying to put together. The problem I run into is that we calculate commission on the job as a whole versus separate calculations for the base job, then another calculation for the first change order etc.  I have been able to create a report that has each base job and change order listed.(each one is a separate record with the Job# as the common denominator. ) I can list and sort by salesperson and job# but my total is where the problem is.  Since some individual records wishin the jobs are calculated at different rates 16% vs 14%, the totals are way off.   Is there a way to add up just the GetSummary fields by Salesperson?
0
The problem is opening a pdf file for view with filemaker go when the pdf is in a container that is an external open type container.  

Set variable [$output; Value:Get(TemporaryPath) & "sample.pdf"]
Export Field Contents [Chart Records::document; "$output"; Automatically open]


This just brings up "loading web..." and eventually fails.
A solution would be most welcome.
-Mark
0
My filemaker application which has the ui separated from the data.  I would like to be able to locate all graphics in the application.

How can i do this ?
0
I am seeing same error on FM 13 pro - on find operation - on the layout which don't have any conditional formatting.What  could be the other reason to see such error ?
0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Trying to create a value list that displays only active products being used by a patient.
We have our patients table, medications table, products table.
The medications table house all current and previous medications that patient was using, such as product ID, contact ID, active or inactive status, and other miscellaneous information.
The products table houses all the information for a specific product, such as product ID, description, brand name, dosage strength, etc.
The patients table houses data such as, patient ID, contact ID, active status, etc.
On the patients layout, when products are added to a patient either it be an Rx or Ancillary product it would be placed in in a portal called Patients_Medications_Rx or Patients_medications_Ancillary, etc.
That would display the history of products that patient has used and is using. The same time there is a field that the user selects as if it is active or an inactive product.
When our user goes to make a delivery form from patients layout, the user would select from the Rx or Ancillary portion of the delivery form the products that patient is using. The problem is that it displays all the products including the "inactive" products.
I was trying to creat a value list that would only display the "Active" products per specific category of products such as "Ancillary, OTC, Rx, etc.

Assistance in this would be greatly appreciated.
0
We have some users who change data on records and then do not recall what the previous data was and at times leave it blank or enter inaccurate data. What we would like is to have the capability to track and keep history of users and times when certain fields were modified.  We would like these to go to a separate table. This table would document the previous data and the newly created data for comparison in the future. It will also document the name of the layout, table, and field.
Is there a function or script already established for such a request?
If not, is it possible to get some insight on what would be the best practice in building one?
0
Filemaker Pro 12 question

I am a high school teacher and I’m looking into the possibility of a correlation existing between calendar age and academic perfomance at our semestered school.

I set up a FMP db with one table and all the fields in that one table.

I have four fields:

1) Month_of_Birth (radio buttons: 01 -12)
2) Student_Mark (#)
3) Level (radio buttons: D, P, IB, L)
4) Semester (radio buttons: 02, 06, 07)

I would like to calculate averages based on this data. I assume I need to use a calculation field, but I am at a loss as how to proceed.

For example, I'd like to calculate the average mark for those born from Jan to Jul (inclusive), who are Levels "D" and "IB", in semesters "02" and "06".

Obviously, I'd like also to calculate the average mark for those born from Aug to Dec (inclusive), who are a Level "P", in semester "02" as well as other combinations and permutations.

I figure I'd be able to modify the code if I could get something for the first one.

Any ideas on how to write a calculation for this? Or do I need something else?

Thank you for your time.

Alex Crane
1
I have having difficulties trying to get my drop-down lists to display the accurate data instead of all the data.
I am trying to use pop-up menu for drop down list.
I have a "products" table, inside that table I have "brand name", "Product type", "item type", and " variety type", those are just some of the fields.
We have issues with employees entering multiple records in products and we need to curtail this.
Also, when we do finds, there are always inaccurate data.
What we are trying to accomplish is that when a user enters a new product, that some of the information be conditional drop-down menus.
For instance, I have a drop-down menu called "Item Type", such entries include: syringes, bandAids, gauze, catheters, etc.
This portion works correctly, it is joined to the "products" table by unique field "__kp_ItemType_ID" from "ItemType" table to "_kf_ItemType_ID" in the "Products" table.
Then from the "ItemType" table, there is a table joined to it called "ItemTypeVariety", it is joined in relationship by unique field "__kp_ItemType_ID" from "ItemType" table to "_kf_ItemType_ID" in the "ItemTypeVariety" table.
I tried to create a pop-up menu to display only the "itemTypeVarieties". associated with the "itemType"
For example, bandAids ("Item Type") can have "itemTypeVarieties" of : children, medicated, sports, etc.
The way it is suppose to work is when a new bandAid is entered into the system, they would select "Band-Aid" and then select from the variety of children,…
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
>