Search the Community
Showing results for tags 'case'.
Found 10 results
-
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 h...
-
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 im...
-
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 ; "2...
-
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...
-
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 th...
-
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 Fil... -
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 fewe... -
pc Problems with Case function
samuel@felfel.ch posted a topic in Calculation Engine (Define Fields)
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:... -
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"... -
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_N...
