1,311
questions
1
vote
0
answers
68
views
Is it possible to run javascript to generate a license number that will be sent with a completed woocommerce order?
I wish to create a license number generator, for a product sold on my Wordpress site, that is identical to the one in my Filemaker (standalone/unserved) database.
The only language common to both web ...
1
vote
1
answer
66
views
Select unrelated in a n:m relationship
I have a typical many-to-many relationship resolved by a join table, as shown here:
For this question the sample data is:
People:
PersonID
Name
P001
Alice
P002
Bob
P003
Carlos
P004
David
...
- 3,058
0
votes
0
answers
27
views
Integrating FileMaker Pro 24 with ServiceM8: How to Handle Email Threading for Client Replies within the job number?
I am developing a FileMaker Pro 24 application that integrates with ServiceM8 to fill gaps in functionality that ServiceM8 does not natively support. One critical need is the ability for emails sent ...
0
votes
1
answer
74
views
Checking if two strings are equal regardless of order
I'm doing this in FileMaker so I'm mostly wanting to know if the theory is okay.
I want to compare two lists (carraige return separated and I want to know if the lists are equal, the lists are allowed ...
- 1,536
1
vote
2
answers
83
views
Is there a way to return to the same tab panel after navigating to another layout?
I'm using Filemaker Pro 19. On one layout, I have a tab control with multiple panels. On each panel, there are buttons with scripts to navigate to another layout and perform a specific search (e.g. ...
2
votes
1
answer
88
views
How to Add SSL Certificate to Outdated CakePHP Website with Apple FileMaker Server?
I'm trying to update an outdated CakePHP website and add an SSL certificate. The website is integrated with an Apple FileMaker server. What steps should I follow to achieve this? Any specific ...
0
votes
0
answers
30
views
Data comparison between records on Filemaker database and website
So I have been tasked to create a program that compares the data on our Filemaker database with that of a website that contains the same set of data and identify discrepancies between the two. Any ...
- 1
0
votes
1
answer
64
views
Trouble parsing XML with XSLT style sheet
I am having trouble importing XML returned by Salesforce Marketing Cloud API into a FileMaker database. I've done this with other XML sets with no issue, but this XML is different than what I have ...
0
votes
1
answer
80
views
Display a specific field value based on a dropdown list field
we are working here with filemaker and i'm getting arround to make it work for my need.
Here are the field i have
Field name "For this year" is a drop down list with a list of 10 year ...
- 1
0
votes
1
answer
65
views
FMP16 - One to many report without using portal
Seeking assistance in creating a one-to-many report in FileMaker Pro 16 without using portals.
I have two tables - the first is 'employees' and the second is 'leaves'. These two tables are related ...
- 351
2
votes
1
answer
69
views
Images in cURL email with HTML not resizing
I am currently trying to send an e-mail with cURL through SMTP. The body is a .txt containing the HTML. The inline attachments (in this case, images) are being inserted by converting them to base64 ...
- 23
0
votes
1
answer
200
views
Piped awk command failing when passed as command to Docker when using docker exec
I'm trying to build a bash shell script to help me monitor the state of a backup schedule in FileMaker Server.
If I run the following bash command in the container shell it works fine
fmsadmin list ...
- 39
0
votes
1
answer
123
views
Error connecting from SQL Server 2016 to Filemaker odbc
I created a linkedserver from SQL Server 2016 to Filemaker database on another server. ODBC driver version in 19.xx.
Using the ODBC driver and DSN, I can see the data from the Filemaker database using ...
- 259
0
votes
2
answers
90
views
Issue with FileMaker Pro Buttons and Creating New Records
I'm tasked with creating a layout that allows users to create a new order. I've written script for this task, however, I can't get it to account for buttons. Neither the "Add_Order_Line" or &...
- 25
0
votes
1
answer
64
views
Is there a way to prevent OnLayoutExit script trigger from triggering when a script changes the layout?
We have a layout in our FileMaker database with an OnLayoutExit script trigger that checks if the user left required fields empty. However, as part of standard use of the layout another script is ...
- 304