Solved

Insert a calculated Field between "  "

Posted on 2011-02-25
6
410 Views
Last Modified: 2012-05-11
Hi
I need have a calculated field inserted to form part of the result of the text .
IE.I need to have the result read..."Contract Due to expire in 4 (Days left before Contract Expires)Days"
The example below not giving me this .The Function works without the GeatasText(Days..etc
Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date );"";
Days Left before contract Expires<10;"Contract Due to Expire in;(GetasText(Days Left before contract Expires))";
)
Thanks
0
Comment
Question by:Krisraychris
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:North2Alaska
ID: 34981162
Try this:
Let (
  [
    ~NumDays = Get ( CurrentDate ) - ( Get ( CurrentDate ) - 4 ) ;   // Replace with Contract end Date
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (
    // IsEmpty ( Contract end Date ) ; ""
    ~NumDays < 10 ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
    ""
  )
)

It will produce:  Contract Due to Expire in 4 Days
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 34981186
I forgot to mention to change ( Get ( CurrentDate ) - 4 ) to Contract end Date and to remove the // in the case statement.
0
 

Author Comment

by:Krisraychris
ID: 35004415
Thanks for your reply.
I have made some changes to your idea and it looks ok for now.I woudl be pleased to know if you think this is ok.

Case(  Contract end Date-Get(CurrentDate)>=0;Contract end Date-Get(CurrentDate);Contract end Date-Get(CurrentDate)<0;"")

Let (
  [
    ~NumDays =    Days Left before contract Expires;    
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date )
      ; "";
    (~NumDays < 10)  and (~NumDays >1) ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
   
   ~NumDays >=10 ; "Contract Active" ;~NumDays =0 ; "Contract Expired " ;""))
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Krisraychris
ID: 35004432
DaysLeftBeforeContractExpires :
Case(  Contract end Date-Get(CurrentDate)>=0;Contract end Date-Get(CurrentDate);Contract end Date-Get(CurrentDate)<0;"")

AlertToRenew:Let (
  [
    ~NumDays =    Days Left before contract Expires;    
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date )
      ; "";
    (~NumDays < 10)  and (~NumDays >1) ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
   
   ~NumDays >=10 ; "Contract Active" ;~NumDays =0 ; "Contract Expired " ;""))
0
 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 35005841
Looks good.  The only thing you might consider is the condition for "Contract Expired".  You may want to change "~NumDays =0" to "~NumDays <= 0".  The thinking is once the  number of days until the contract expires goes to zero or negative it should always read "Contract Expired " 
0
 

Author Comment

by:Krisraychris
ID: 35006292
Perfect...Thank you.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question