Jump to content

Search the Community

Showing results for tags 'evaluate'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 4 results

  1. 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. Jim 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 [ ] End If 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 ] End If Commit Records/Requests [ Skip data entry validation; No dialog ]
  2. I'm a little confused and can't figure out how to capture a script step that has a calculation using an the "Evaluate" function with an invalid argument. For example if I pass an argument that is not quoted and does not represent a valid field name. In case I'm not describing this clearly you can check out the example file. Thanks Error.fmp12.zip
  3. Friends, I have had it for today... can't seem to get it right... I'm writing an Excel sheet using the MBS plugin. The plugin let's me set FORMATS so I can underline or center cells etc. For every FORMAT I declare a variabel i.e. that gets a value from the plugin $$Format1 = 89 $$Format2 = 90 I pull data from FMPro and 'filling' up an Excel Template with field values. Some of these field's need formatting. Since all data is dynamic, my script needs to handle this accordingly. I 'build' the excel sheet row-by-row, therefore pulling data from FMPro, row-by-row. A VARIABLE is handeling the data in the LOOP...The variable content looks like: "7" & "|" & "FM08_SAMPLE::ID_NUMERIC" & "|" & "FORMAT1" & "¶" & "8" & "|" & "FM08_SAMPLE::FM08_Sample_date" & "|" & "FORMAT2" & "¶" & "9" & "|" & "FM08_CUSTOMER::COMPANY_NAME" & "|" & "FORMAT1" In the script the data is pulled apart, set to the right CELL and a FORMAT needs to be applied. Now, here's my question, I need to have this function filled: MBS( "XL.Sheet.CellWriteText"; $$MBS; 0; ROW ;COLUMN; VALUE; FORMAT) Where format of course should not be "FORMAT1" but "89"... I tried things like: Let ( [ STRING = GetValue ( $$D ; $$Tel ); COLUMN = Middle ( STRING ; 1 ;Position ( STRING ; "|" ; 1 ; 1 )-1) ; WLENGTE = Position ( STRING ; "|" ; 1 ; 2 )- Position ( STRING ; "|" ; 1 ; 1 ) - 1; WAARDE = GetField (Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 1 )+1 ; WLENGTE)); FORMAT = Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 2 )+1 ; 10); VAR = "Let ( $$" & FORMAT & "; ")" ] ; MBS( "XL.Sheet.CellWriteText"; $$MBS; 0; $$R ;COLUMN; WAARDE; Evalueren(VAR) ) ) But It does not work... where do I go wrong?? Thanks, Jeroen
  4. Hey Gang; just was wondering why would you use the "Evaluate function in this " Case ( Get ( SortState ) = 0 or Get ( SortState ) = 2; Evaluate ( "Let ( " & ~sortVarIndicator & " = " & Quote ( "" ) & "; False )"); ~isSameSortField and Get ( SortState ); Evaluate ( "Let ( " & ~sortVarIndicator & " = " & Quote ( ~sortIndicator ) & "; True )"); instead of only just using the let ( ) function. - sometimes i dont know why i should use Evaluate & just Let () . can someone explain? -ian
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.