Jump to content

Search the Community

Showing results for tags 'case'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris 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 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 10 results

  1. Hello, I'm have an issue sending emails via SMTP Server using a calculation field in the "To:" field. When I use the calc my outgoing emails are filtered as spam by the hosting service. If I put the Email Field in the SMTP To: emails are sent successfully. Here is the setup: I have a Parent Table with the fields Email_Parent1, Email_Parent2, Email_Parent3 and a related SuperParent_Email. Parents can opt-out/in of mailings by selecting flag_P{1-3}_Mailings. I'm trying to to get the field Email_List output to look like this: Email_Parent1@mydomain.com; Email
  2. Hello, I have a Case calculation that does not return what I expect wd1 = width of image in container1 , ht1 = height of image in container1 wd2 = width of image in container2 , ht2 = height of image in container2 A script would open up a popup window sized to the parameters of the image in the container. This is how it starts: Set Variable [ $contfield; Value:Get ( ScriptParameter ) ] //which is the name of container1 or 2 which it gets correctly Set Variable [ $ht; Value:Case ( $contfield = Untitled::container1; Untitled::ht1; $contfield = Untitled::container2;
  3. I have a calculated field that is based on the following. Now I want to add this: If ( LABEL = "Eloquence" ; Case ( ANTAL I ALBUM = 1 ; "79,50" ; ANTAL I ALBUM = 2 ; "149,50" ; ANTAL I ALBUM = 3 ; "219,50" ; ANTAL I ALBUM = 4 ; "219,50" ; "Mangler kalk"); Where and how do I put it in? I have tried almost everything, but I keep getting error messages. --- Current definition --- If ( GENRE = "Klassisk" or GENRE = "Jul" or GENRE = "Jazz" or GE
  4. Hi, After the weekend races and all the results are imported into FM, I mark (now by hand) the “Key Races”. I’ll find each horse who either won or finished 2nd. As in this screen shot of Cherry Summer you can see he won his last race on Oct 3. (1) Then I mark the preceding race. (now I’m using a ‘K’, but I intend to change it to a number — different problem). The point is to show which race produced winners. The screenshot shows I have put a 'K' in Cherry Summer's race on may 31 and changed the 4 to a 5. Then I find matching records for RaceID (31may15tok5) on the record I just tagged,
  5. Hi there, I have a field which needs to return a value based on the contents of other fields around it, so I'm using a CASE statement to achieve this. Nice and simple, write it once and forget about it. Case (Code = 1 ; "Income Band A" ; Code = 2 ; "Income Band B") I want to add something to the CASE statement which evaluates another field based on text contents, so I have tried to use the POSITION command in the CASE statement to make this work, but no luck so far. Here's what I have: Case (Code = 1 ; "Income Band A" ; Code = 2 ; "Income Band B"; Position (Description;"TOURIST";1;1) =
  6. I have a need for a lot of cross tab calculations and have referred to the FM 13 Advanced Training Series, lesson 38 which covers this. I've used it for a while now but it's brutal in that you need to create two calculations for each individual 'cell' you wish to display: One calculation tells Filemaker what should be summarised, usually via a CASE statement. The other is the Summary field itself which appears on the layout. I tend to require 10, sometimes more columns which are based on date fields from an overall record list of 70000 so far. Is there not a better way of doing the cross
  7. Hello! I have a list of attributes in a field that are displayed as a checkbox set. Thus, multiple selections can be made for this field. I have updated my value list for this checkbox set in order to refine it for my current needs. The value list change 1) collapses the value list to provide fewer options that someone could select (eliminates vague values leaving only the more precise ones) and 2) updates the wording of the value list to eliminate confusion. I now want to update the responses to this field by using Replace Field Contents: that is, replace entries that were recorded using t
  8. I'm new to filemaker pro advanced 13 and encountered some problems with the case function. I have to following function: Case ( Product ID = Order Book_Test::ProductID ; Case ( Order Book_Test::Eformat = "Date&Price" ; Case ( Order Book_Test::Date = ( Get (CurrentDate)); Count ( Order Book_Test::Eformat)))) my problem is that filemaker stops at the first true Case. However, I need filemaker to validate all Cases and based on this result to execute the Count function. How can i solve this issue? Thanks Sam
  9. Hello, I don't know if anybody can help me but I'm trying to specify a field to replace the value based upon a variety of parameters specifically for States. For example I attempted to do an if statement to turn the word of the state into the abbreviation " if( Upper(Self="ALABAMA");"AL"; if(Upper(Self="ALASKA");"AK"; if(Upper(Self="AMERICAN SAMOA");"AS"; if(Upper(Self="ARIZONA");"AZ"; " and so on. I also tried: Case( Upper(Self="ALABAMA"); "AL"; Upper(Self="ALASKA"); "AK"; Upper(Self="AMERICAN SAMOA");
  10. Hi Everyone, I am trying get the ABCD to work. Is there any way to categorize the "0" to read any letter instead of a number? Part number ex: is SR18.1111 (yes this is a real image name). Case ( IMAGE_NAME ≥ 6000 ; 6000; IMAGE_NAME ≥ 5000 ; 5000; IMAGE_NAME ≥ 4000 ; 4000; IMAGE_NAME ≥ 3000 ; 3000; IMAGE_NAME ≥ 2000 ; 2000; IMAGE_NAME ≥ 1000 ; 1000; IMAGE_NAME ≤ 999 ; "0000"; IMAGE_NAME ≤ 0 ; "ABCD"; ) EX: if it's a part number under 999 then the directory should be 0000 but if it's over 1000 but under 2000 then it should be 1000. etc 2filemaker.zip
  • Create New...

Important Information

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