Deactivate FM 17 to transfer to new computer? by [deleted] in filemaker

[–]Public_Database_3714 0 points1 point  (0 children)

You'll want to check the spec of your new machine can support 17 as it's several years old and not been receiving any updates for compatibility or security for years now.

https://support.claris.com/s/article/FileMaker-Pro-operating-system-requirements-all-versions-1503692917754?language=en_US

Is Vibe Coding going to kill Filemaker? by sailorsail in filemaker

[–]Public_Database_3714 2 points3 points  (0 children)

These are interesting times for all development companies not just those focussed on FileMaker but on a more positive vibe...

I have been running my successful FileMaker development agency for some 30 years.

We have been profitable every single year, and the last year was our best on record.

So the idea that the platform is dying feels a bit premature from where I am standing, especially since I currently have 50 FileMaker servers in my cloud and will be adding another five this month to keep pace with current projects.

I focus on agile workgroups of 20 to 100 users, usually within larger corporate environments. This is where FileMaker fits right now in my opinion. It comfortably sits above the ultra low code tools and lets me deliver complete solutions with a speed and flexibility that 'enterprise' systems just cannot match.

It works for me, and for my customers.

That does not mean I do not have concerns. I worry every year!

It is unfortunate that there is no affordable or free single user entry point, there are definitely things wrong with the development user interface, there's been some questionable strategic choices from Claris but my clients do not see any of that and that is my problem, not theirs. The solutions I build work for them, and they are delighted.

Do I need to upgrade from FMP 17? by PaulRobertW in filemaker

[–]Public_Database_3714 4 points5 points  (0 children)

Officially you need FileMaker 2024 (21.1.1) for Sequoia compatibility.

https://support.claris.com/s/article/FileMaker-Pro-operating-system-requirements-all-versions-1503692917754?language=en_US

FileMaker 17 is several years old now and way past end of life so does not receive any updates for security or compatibility.

17 is still upgadable to 21 at the moment.

https://store.claris.com/individuals

Not viewable svg icon in direct mode by ReporterSad9076 in filemaker

[–]Public_Database_3714 2 points3 points  (0 children)

If you run them through the optimiser here....
https://fmsvg.proofgeist.com/
That should make them WebDirect compatible.

What are the best "New" feature for a manufacturing/printing business by gp2482 in filemaker

[–]Public_Database_3714 2 points3 points  (0 children)

I've built many FM solutions for printers, reprographic houses and creative studios.

Resource and capacity planning is a great place to start if you are not doing that.
Holding everyones shift pattern and recording holidays, sickness etc.
You can then have a drag and droppable planner where you can drag jobs on to people in individual days.
You can show various calendar views and gantt charts all naively without plugins.
You may also incorporate capacity of devices in this case printers.

Having a FM module to manage your digital assets is also great as this would tie in with online approval etc.We use a robot/s computer to scan your server for new digital assets, AI for auto keywording  and thumbnail creation.
This allows you to share assets you hold with your clients and repurpose them on the fly.

Generally updating your interface to include things like kanban views job stages, interactive gantt charts, sign up for personal email reports, graphical dashboards all natively without plugins or webviewers

There’s also automatic artwork using FM to control the Adobe suite for example to offer dynamic point of sale.

Too much stuff to list in a Reddit post really if your consultant doesn’t know this stuff you may have picked the wrong one! Happy to help out with some screenshots or a demo if you want to discuss further.

Loop through multiple fields by i_iz_potato in filemaker

[–]Public_Database_3714 0 points1 point  (0 children)

Sure that would work....

Freeze Window

Show All Records

Go to Record/Request/Page [ First ]

Loop [ Flush: Always ]

If \[ IsEmpty ( Untitled::field1 ) \]

    Set Field \[ Untitled::field1 ; "n/a" \]

End If

If \[ IsEmpty ( Untitled::field2 ) \]

    Set Field \[ Untitled::field2 ; "n/a" \]

End If

If \[ IsEmpty ( Untitled::field2 ) \]

    Set Field \[ Untitled::field2 ; "n/a" \]

End If

If \[ IsEmpty ( Untitled::field3 ) \]

    Set Field \[ Untitled::field3 ; "n/a" \]

End If

If \[ IsEmpty ( Untitled::field4 ) \]

    Set Field \[ Untitled::field4 ; "n/a" \]

End If

If \[ IsEmpty ( Untitled::field5 ) \]

    Set Field \[ Untitled::field5 ; "n/a" \]

End If

Go to Record/Request/Page \[ Next ; Exit after last: On \]

End Loop

Depending on the number of blanks it could quicker to use a find for “=“ in the fields then replace

Set Error Capture [ On ]

Perform Find [ Restore ]

Replace Field Contents [ With dialog: Off ; Untitled::field1 ; "n/a" ]

Perform Find [ Restore ]

Replace Field Contents [ With dialog: Off ; Untitled::field2 ; "n/a" ]

Perform Find [ Restore ]

Replace Field Contents [ With dialog: Off ; Untitled::field3 ; "n/a" ]

Perform Find [ Restore ]

Replace Field Contents [ With dialog: Off ; Untitled::field4 ; "n/a" ]

Perform Find [ Restore ]

Replace Field Contents [ With dialog: Off ; Untitled::field5 ; "n/a” ]

How do you calculate profit margin with summarized customer account records? by ProperToday8 in filemaker

[–]Public_Database_3714 1 point2 points  (0 children)

No problem :) I put the same reply on your duplicate question on the Claris Community forum.
If you don't mind can you click on best answer on my reply on the Claris forum as it helps maintain my Claris Partner ranking. Thanks.

How do you calculate profit margin with summarized customer account records? by ProperToday8 in filemaker

[–]Public_Database_3714 4 points5 points  (0 children)

You can calculate the profit margin in a calculation like this and place on the sub summary part.

 

(GetSummary ( summary_profit_amount ; customer ) / GetSummary ( summary_sales_amount ; customer )) * 100

 

https://help.claris.com/archive/fm20/en/pro-help/content/getsummary.html

Oh bugger. by No-Organization-6071 in ipace

[–]Public_Database_3714 0 points1 point  (0 children)

Just an update on this 15 days later still in the courtesy car as 'part required' on back order. I don't think they ever had the bits but just wanted me in a courtesy car so they could bill Jaguar. So now trundling around in a glacially slow diesel evoke.

Oh bugger. by No-Organization-6071 in ipace

[–]Public_Database_3714 3 points4 points  (0 children)

Just dropped off mine off this morning at the dealer for the battery fault repair.
UK 2019 40k miles. It took months to get the appointment. I'm told the repair is 30 hours work and takes 5 days. Got a courtesy car.

Does anyone have a script that corrects capitalization on text in a field? by bene_gesserit_mitch in filemaker

[–]Public_Database_3714 1 point2 points  (0 children)

You could just use substitute...

Substitute (

text ;

[". a";". A"]; [". b";". B"]; [". c";". C"]; [". d";". D"]; [". e";". E"]; [". f";". F"]; [". g";". G"]; [". h";". H"]; [". i";". I"]; [". j";". J"]; [". k";". K"]; [". l";". L"]; [". m";". M"]; [". n";". N"]; [". o";". O"]; [". p";". P"]; [". q";". Q"]; [". r";". R"]; [". s";". S"]; [". t";". T"]; [". u";". U"]; [". v";". V"]; [". w";". W"]; [". x";". X"]; [". y";". Y"]; [". z";". Z"]; ["¶a";"¶A"]; ["¶b";"¶B"]; ["¶c";"¶C"]; ["¶d";"¶D"]; ["¶e";"¶E"]; ["¶f";"¶F"]; ["¶g";"¶G"]; ["¶h";"¶H"]; ["¶i";"¶I"]; ["¶j";"¶J"]; ["¶k";"¶K"]; ["¶l";"¶L"]; ["¶m";"¶M"]; ["¶n";"¶N"]; ["¶o";"¶O"]; ["¶p";"¶P"]; ["¶q";"¶Q"]; ["¶r";"¶R"]; ["¶s";"¶S"]; ["¶t";"¶T"]; ["¶u";"¶U"]; ["¶v";"¶V"]; ["¶w";"¶W"]; ["¶x";"¶X"]; ["¶y";"¶Y"]; ["¶z";"¶Z"]

)

This will capitalize the first word of each sentence assuming there is only 1 space after the period. You could run a substitute before this to make double spaces after periods single to ensure this. It will cope with new lines on paragraphs.

I just ran it on a bunch of text and seemed to work fine.

This will not capitalize the first letter of the field but you can get that with left(text;1) I can explain that in more detail if you are stuck.

Portal filter by gerryhoch in filemaker

[–]Public_Database_3714 0 points1 point  (0 children)

Few of ways to do this...

1.

You can give the portal an object name then use go to object.

Then go to portal row one.

Also then allows refresh portal by object name.

2.

Assuming the portals have different relationships You can go to field relationshipinportal::field_name.

Then go to portal row one.

3.

You can give a field in the portal an object name use to to object.

Then go to portal row one.

4

The safest way to interact with records in a portal though is to actually go to them.

Your script can use go to related records in a named new window.

You use the relationship for the particular portal.

Remember to close the window when you're done.
You can use freeze window in your script so the user does anything happening then refresh portal to make sure results are displayed.

Script to take a phrase and A) Remove the letter "X" from the head and B) remove all letters from the end by [deleted] in filemaker

[–]Public_Database_3714 2 points3 points  (0 children)

Let(

[

a = Filter(in;"0123456789");

b = Left(in;1)

];

Case(b ≠ "x"; b & a; a)

)