By Jim Gill
This is probably one of those questions which separates me from people that make money as developers and those that don't (that would be me). I have a simple script that compares two variables. The variables are populated with text (Peoples Names). Basically, if the the two variables are TRUE (the variables are equal) I want to stop the script. Despite the two variables being equal - the IF continues. I have noted when I use the same numbers to populate the variables - the script works as expected. Please tell me Filemaker is smart enough to evaluate text in variables. Below is the my script and attached is a screenshot of my debugging efforts.
As always - thank you to the people here which share your wisdom - a big reason I love Filemaker so much.
IWP: IWP: Bunk Choice Select
#This script allows WebD users to select bunkmates for the coming summer.
#List All Chosen Names
Set Variable [ $BR_List; Value:List ( BRE__BUNKSREQUEST_tog::Bunk Request Choice 1;BRE__BUNKSREQUEST_tog::Bunk Request
Choice 2;BRE__BUNKSREQUEST_tog::Bunk Request Choice 3;BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 ) ]
Set Variable [ $BunkRequest; Value:Agegroup_Names_List::Name_Full ]
Set Variable [ $BR_Check; Value:FilterValues ( $BR_List ; $BunkRequest ) ]
#IF check to see if the names has already been selected
If [ $BunkRequest = $BR_Check ]
Show Custom Dialog [ Title: "No Duplicates"; Message: "You have already chosen this person. Please give us FOUR differnt names!
Thanks!"; Default Button: “OK”, Commit: “Yes” ]
Exit Script [ ]
If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4; $BunkRequest ]
[ Skip data entry validation; No dialog ]
I am still very amateur on Filemaker so i hope my question does make any sense.
I am trying to write a script that would basically import order information from an email and convert it, first in a new account (if the customer does not exist) and later create a Sale Order. So far, I have managed to do that, but the problem i find is when trying to convert the sale order into an invoice. Since this order comes from our webshop when we receive the email means it is paid, so my aim is that when creating the invoice from the Sale order, this would be marked as paid and set the amount due to zero.
This would sound a very easy task, but since our solution incorporates a payments module to manage the payment of an invoice, when i try to incorporate the payment entry within my script, there is when all the trouble starts. For some reason, it gets lost in its way when runnig the script and returns a partial payment all the time. The weirdest thing is thet if I run the script on debug mode, then all works perfectly, so my guess is that the issue may be related to the speed of the script.
So, is there any recomendation as for where to put a pause script step so the script will work also when run automatically?
I have tried every possible combination of long script, shorter with other scripts inside, perform script on server... and all the time something is wrong ;(
Thanks a lot for any insight thst would help us move forward, since we have been trying to solve this for a week already.
For an inventory management database, I'd like my main screen to be able to accept pulls from three related databases:
- Serialized (valuable tools, which I track and want back - the paintbrush);
- Replenishable (cheap tools that I buy by the yard and if one gets left behind I don't care - the paint-mix sticks);
- Perishable (disposable tools that are left on the job site - the paint).
These will handle their related requests differently. The serialized I'll be tracking properly to make sure we keep track; the latter two I'm looking for more like a system of 'tick marks' to help me know what we use on job sites.
We print our barcodes. For ease of use, I'd like staff to scan into a single field in an interface that is smart enough to do the right thing based on a key digit in the barcode. So when I scan barcode 'S1234', my db knows to move it to the Serialized relation field; when I scan 'P1234,' it knows we're in Perishables.
Looking for the elegant approach. My thought is that that central hot field (Scan_Here) will, when entered, store a variable and trigger a script built within the context of the related table, but I'm sometimes prone to reinventing wheels and doing stuff the long way, so I'm asking for suggestions / examples.
By JH Howland
I have created an "opener" file called "OpenMP" that is located on the Windows Desktop. Also, a global variable for the directory where the FMP14 files are located called "$$marinaDir" = "MarinaPro v17".
When activated the launcher opens but does not open the target file using the following file path, "filewin:/C:/$$marinaDir/Marina.fmp12." However if I substitute with the following, "filewin:/C:/MarinaPro v17/Marina.fmp12"; all is good.
The script elements follow:
Set Variable [$$marinaDir; Value: "MarinaPro v17"]
Open File ["Marina"] (Marina File Path: filewin:/C:/$$marinaDir/Marina.fmp12)
What am I missing?
I am having a tough time getting the set field by name script step to work and hoping someone can help me with this.
I have a file of sales transactions over many years. I have a related file for customers. The customer file has counters for how many times a customer visits each year, how many suits, sportcoats, etc. they buy each year ( visits_2017, visits_2016, visits_2015, suit_count_2017, suit_count_2016, suit_count_2015 and so forth). I would like my script to evaluate the year of the transaction in sales and update the appropriate counter in customers.
I have been unsuccessful in defining a variable and set field by name combination to accomplish this task. Any recommendations?
Who Viewed the Topic