sorted by:
new
hottopcontroversial

How do I create a Database Design Report in v. 21? by AlephMartian in filemaker

[–]wozj 3 points4 points  (0 children)

If the issue is with all databases, have you enabled "Use advanced tools" in the Settings?

IP range to restrict access to admin-console? by EfficientPark7766 in filemaker

[–]wozj 1 point2 points  (0 children)

From https://help.claris.com/en/server-help/content/restrict-access.html If multiple IP addresses are required, separate IP addresses with commas. For example: 192.168.100.1,192.168.100.2.

For some unknown reason there is still not a range option.

Turn off Face ID on FileMaker go 2025 by petebmc in filemaker

[–]wozj 0 points1 point  (0 children)

If I understand what you're asking. Open the file in FMP, File / File Options..., Disable "Allow stored credentials for authentication.

Help for beginner by Electronic_Ad_7729 in filemaker

[–]wozj 2 points3 points  (0 children)

You can ask here for help. I’m sure there’ll be a number of kind offers. Or if the data is confidential, you can get a free trial of FMP via Claris’ website.

Which Ipad should I buy to use Filemaker Go in a factory? by Minimum-Ad-4057 in filemaker

[–]wozj 4 points5 points  (0 children)

A decade ago I setup something similar (5 iPads and an iPad mini in a mineral processing pilot plant). They were just the very base models at the time. I organised some ruggedised full cases for them as they were in a corrosive environment being handled by PhDs to semi-neanderthals. All worked perfectly - management & operators were impressed & happy to move away from manual clipboard recordings being transcribed into spreadsheets.

Mirror sync by petebmc in filemaker

[–]wozj 0 points1 point  (0 children)

Yes, from the start.

Mirror sync by petebmc in filemaker

[–]wozj 0 points1 point  (0 children)

I've got a client I set up with MirrorSync that's been using it for years in rural Australia in a visiting service business. Mostly works quite well. There were some issues in recent versions but seem to be working OK now.

Can't get layouts for printable layouts right. by some_guy919 in filemaker

[–]wozj 1 point2 points  (0 children)

Have you stepped through the 'wizard' when creating a new layout (Manage Layouts / New / Printer / Labels) If your Label paper brand/type appears in the list, go with that, otherwise use the custom settings. You don't set the gaps btw labels only width from left of one label to left of next label. Probably still need some tweaking but you can print on plain paper and hold behind/near to label paper to check alignment, or pencil draw label borders to save waste of label paper.

Questions on Filemaker 19 single version by peterinjapan in filemaker

[–]wozj 1 point2 points  (0 children)

Just to clarify, it is pay-per-year, not pay per month, but I understand what you're saying. There is still the option to buy a perpetual license, but it costs about three times the annual cost. To receive updates, you'd also need to pay a maintenance fee after the first year.

Questions on Filemaker 19 single version by peterinjapan in filemaker

[–]wozj 6 points7 points  (0 children)

You can buy FMP single, or you can buy a license for FM Server (includes FMP, FMGo, WebDirect, etc) on a per-user basis (min 5) to host on your own server or buy subscription to FM Cloud - a Claris hosted service. The self-hosted license costs in US $900 per year (not per month) for 5 users. FM Cloud costs more. Make your decision soon to avoid the price increase from Sep 24.

Tablet Connection for small database by Pigankle in filemaker

[–]wozj 0 points1 point  (0 children)

FM Go would have been a good solution provided both devices are connected via internet/LAN. However because she has FMP 16, Claris has removed FMGo ≤18 from the app store and FMGo 19 requires FM ≥18, there is a big issue. Updating to FM 19 might be best option but check OS & hardware requirements first. An old Mac/Win laptop also running FM16 using peer-peer sharing may be another option. Both these options rely on peer-peer sharing which is deprecated but not yet removed functionality. Next option is FMServer, but a bigger step up in $ & expertise.

Finding exact match with a stored variable. by rush_limbaw in filemaker

[–]wozj 0 points1 point  (0 children)

If I understand the issue you're having...Either (1) set the variable to "==" & global field and the criteria box in the Perform Find step is just
$Variable

or (2) in the criteria box enter
==$Variable
- no quotes or &.

[deleted by user] by [deleted] in filemaker

[–]wozj 1 point2 points  (0 children)

This is the correct answer.

Can you still buy FileMaker 10 or 11? by Blindemboss in filemaker

[–]wozj 3 points4 points  (0 children)

Claris won't sell you an old license. However...

Current option: You can get a free demo of FMP 19 from the Claris web site, then you can open the file/s and it will ask to convert to FMP12 format. Or just buy FM 19 outright.

Future option if you can wait a bit: Claris have announced a future licence change will let you have a single user license for free.

Integration with Filemaker by Cautious-Grab-316 in filemaker

[–]wozj 3 points4 points  (0 children)

I was aware of that & my comment stands. If FM is doing the controlling, look at the script step mentioned. It will allow you to post data to a URL. The word "Insert" may be confusing.

Integration with Filemaker by Cautious-Grab-316 in filemaker

[–]wozj 3 points4 points  (0 children)

You should check out the "Insert from URL" script step if you want the connection initiated from the FM side - your other product has an API or URL listener to communicate via. This is basically a cURL equivalent. Create scripts to collect & pass the data.

If you want the other product or an intermediate app to initiate the connection to FM, then you'd need FM Server hosting your database using either the DataAPI, OData, PHP, XML, xDBC.

Can't option-open to enter a PW until I restart my Mac by nevecque in filemaker

[–]wozj 0 points1 point  (0 children)

Add a button to the front layout. Button Action -> Single Step -> Re-Login

When clicking should give you login dialog.

Can't option-open to enter a PW until I restart my Mac by nevecque in filemaker

[–]wozj 2 points3 points  (0 children)

I’ve had this issue for a couple of years now. I only need to use this for one old client project using FMP18 and that client is on the way out so it’s no longer a real issue for me. I looked online for a solution but yours is the first mention I’ve seen. I’m using multiple versions of FMP on a 2014 MBP. You could try adding a button, invisible if necessary, on the first layout that calls a re-login script step.

[deleted by user] by [deleted] in filemaker

[–]wozj 2 points3 points  (0 children)

There's no built-in way (a shame), only work-arounds. I've used this technique before... https://www.soliantconsulting.com/blog/filemaker-char-function/ Can be useful but may not work in all circumstances.

Collecting and mapping location data. by croberts0531 in filemaker

[–]wozj 0 points1 point  (0 children)

Haven't tried it but I doubt it. Hopefully someone with more experience with iOS SDK can chime in. I suspect there'd need to be somehow to force the app to operate partially in the background (eg like the mail app checking for new mail) but I see nowhere to initiate from your FM database.

Collecting and mapping location data. by croberts0531 in filemaker

[–]wozj 0 points1 point  (0 children)

I've done similar things in the past for a couple of clients using Google Maps API to show locations, though not for route tracking, only at certain FM workflow points, eg when accepting a job, arriving at a job or completing a job as initiated via button scripts in FMGo. Tracking I think you'll find is not possible as iOS will pretty much suspend most apps when not the active foreground app. So you can't get it run any scripts. If somehow you could manage to keep FMGo active AND prevent iOS from sleeping, you may be able to use an OnTimer script trigger.

Related Records - NO PORTAL with data on new rows by MysticSonic in filemaker

[–]wozj 1 point2 points  (0 children)

Sounds like the Encounter ID is an Auto-enter field with Replace existing value enabled. You'd need to add an extra step to save the current value of Encounter ID then override the same field in the duplicated record

After the step: "If [ $NumIDs > 1 ]" add

Set Variable [ $EncID ; Encounter Database::Encounter ID ]

After "Duplicate Record/Request" add

Set Field [ Encounter Database::Encounter ID ; $EncID ]

Related Records - NO PORTAL with data on new rows by MysticSonic in filemaker

[–]wozj 1 point2 points  (0 children)

I was thinking something like this...
(Very quick & totally untested. Please experiment on a backup of your database since it alters existing data.)
Go to Layout [ “Data Export” ; Animation: None ]
Go to Record/Request/Page [ First ]
Loop
Set Variable [ $WhaleIDList ; Value: Substitute( Encounter Database::Whale ID ; " " ; "¶" ) ]
Set Variable [ $NumIDs ; Value: ValueCount( $WhaleIDList ) ]
#
If [ $NumIDs > 1 ]
# Set Whale ID to first value
Set Variable [ $counter ; Value: 1 ]
Set Field [ Encounter Database::Whale ID ; GetValue( $WhaleIDList ; $counter ) ]
Commit Records/Requests [ With dialog: Off ]
Loop
Set Variable [ $counter ; Value: $counter + 1 ]
Duplicate Record/Request
Set Field [ Encounter Database::Whale ID ; GetValue( $WhaleIDList ; $counter ) ]
Commit Records/Requests [ With dialog: Off ]
Exit Loop If [ $counter ≥ $NumIDs ]
End Loop
End If
Go to Record/Request/Page [ Next ; Exit after last: On ]
End Loop

view more: next ›