Jump to content
Sign in to follow this  
Qam Qam

Count Down Timer

Recommended Posts

Hello everyone ,

this is my 1st post in this helpful website 

thank you guys ive learned a lot 

 

iam working on recruiting software for my office 

its simple 

my issue now that i want to set simple days count down timer 

for example if my client requested his procedure finish in 60 days or 90 days 

i want to know left days in a list so i can give pioirty 

so i used the following 

GetAsNumber ( Contract_End_Date - Get ( CurrentDate ) )      

which appears in the remaining days filed 

it worked fine for me 

the issue is 

it remains  frozen , next day its the same value like yesterday 

 

sorry for my bad English '

 

please help me 

thank you 

2018-04-07_22-17-26.png

Share this post


Link to post
Share on other sites

your calculation value must be "un-stored" this way it will always evaluate to the current value. Choose storage options

 

Screen Shot 2018-04-07 at 1.25.09 PM.png

 

  • Thanks 1

Share this post


Link to post
Share on other sites

thank you very mch sir for replaying 

i have the below mentioned options in the storage 

what do i choose 

2018-04-08_12-26-09.png

Share this post


Link to post
Share on other sites

Your field must be a CALCULATION field, the storage options are then available at the bottom of the calculation definition.

 You have defined a NUMBER field with Auto-enter options and so your data is STORED. This means the field will not re-evaluate and will hold the initial value unless "Contract_End_Date" is changed.

Share this post


Link to post
Share on other sites

thank you very much sir for replaying 

is this the correct  way 

 

2018-04-08_18-37-37.png

2018-04-08_18-37-47.png

Share this post


Link to post
Share on other sites

Just subtract the two days to result in number of days.  

ContractEndDate - Get(CurrentDate) 

The result will be a positive number as long as the contract date is a future date you may want to add logic if you want it not to show a negative number if the contract is expired.

There are also many Custom Functions that can also help if you need to calculate for business days etc  http://www.briandunning.com/filemaker-custom-functions/list.php you can search for dates or count etc. 

 

Share this post


Link to post
Share on other sites

Hi Qam Qam and welcome to the FM Forums,

The link provided by Ocean West is an excellent resource. If you do a search for Date you will get 331 hits.

The Custom Functions site, http://www.fmfunctions.com/functions.php is another good resource with 28 dates.

I made a quick and dirty file that shows your calculation with a positive number, and I added some Conditional Formatting. There are two other count fields showing Inclusive Dates and and Work Days instead of straight date plus.

HTH

Lee

 

Count Down Timer.fmp12

Share this post


Link to post
Share on other sites

Yes, your field definition now looks correct.

Share this post


Link to post
Share on other sites
On 4/12/2018 at 5:57 AM, Lee Smith said:

Hi Qam Qam and welcome to the FM Forums,

The link provided by Ocean West is an excellent resource. If you do a search for Date you will get 331 hits.

The Custom Functions site, http://www.fmfunctions.com/functions.php is another good resource with 28 dates.

I made a quick and dirty file that shows your calculation with a positive number, and I added some Conditional Formatting. There are two other count fields showing Inclusive Dates and and Work Days instead of straight date plus.

HTH

Lee

 

Count Down Timer.fmp12

thank you very much this is very helpful 

On 4/12/2018 at 11:51 AM, IdealData said:

Yes, your field definition now looks correct.

thank you

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By "... you mean these fans?"
      Mr. Ignoramus
      We have a solution in Canada where we moved the db from a hosting company to a LAN ( customers building ) They are using a Mac OS machine running FileMaker 16 server.
      We access the FM 16 server via apple's remote access, having trouble locating where we would put the index.html and php files for our web form that we used when we were hosting on an outside hosting company.  The hosting company put the html/php file in the folder that designated our account number. 
      My question is this ... where would we put the two web files; index.html (form) and the .php (create record in FM) file on the FM 16 server.  I can not seem to locate the instruction via the documentation FM is providing.  Have done several internet search ...
      I am gathering information to pass to the individual helping us with the FM server at location.
      Anybody able to provide a link or guidance I would be grateful.
      Thank you.
       
    • By jduncan
      Hello,
      We recently upgraded from FMS 14 to FMS16 and one of our databases won't open via WebDirect due to the way it's named:  the database title has an ampersand ("&") in it.  This worked just fine for FMS14, but not for FMS16.  The easiest solution seems to be to change the database title.  I'm a little hesitant to jump into this because of a large number of externally held containers.  How would one safely go about changing the database name (I'd like to change the "&" to "and") without losing the linked containers? 
      In case anyone's wondering, I didn't name the database; I inherited it.
    • By ShelCOYS
      Hi, I have fm 14 server running on a mac mini. I have recently upgraded to FM16 running Mojave on 2 x local macs. We started with one license, where only one of us could use FM at a time (as we knew), I have since bought another copy and and reinstalled FM16 on the local mac with the new serial number but the server still seems to think we are using the same copy?? and we are getting the attached error. I have completely uninstalled FM locally but still does not work. I have asked my FM guy, as well as 2 or 3 other people but everyone seems to be stumped?? Is there any way of clearer the cache which may be holding this old information? Any help would be much appreciated.

    • By Gaohan
      Dear all,
      I'm new here so forgive me if not posted in the correct location. We have the following situation for which we do not know how to continue:
      We have Filemaker server running on a windows server. The server is accessed through its local ip address (in the 10.10.10.x block). For an internal application I would like to extract information from a FileMaker database for usage in another application. Initially, I used the xmlresultset grammar. It works for when requesting the databases hosted on the server (i.e. : http//10.10.10.x/fmi/xml/fmresultset.xml?-dbnames returns the expected result). However, when I attempt to retrieve a list of layouts that are available I keep getting an empty body result:
      http://10.10.10.x/fmi/xml/fmresultset.xml?-db=Test&-layoutnames Returns the following contents (Note the content-length = 0):
      [Chrome section: General] Request URL: http://10.10.10.x/fmi/xml/fmresultset.xml?-db=Test&-layoutnames Request Method: GET Status Code: 200 OK Remote Address: 10.10.10.x:80 Referrer Policy: no-referrer-when-downgrade [Chrome section: Response header] Content-Length: 0 Content-Type: text/xml;charset=UTF-8 Date: Mon, 19 Nov 2018 16:01:06 GMT Server: Microsoft-IIS/10.0 X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-Powered-By: ARR/3.0 X-XSS-Protection: 1; mode=block [Chrome section: Request headers] Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate Accept-Language: en-US,en;q=0.9,nl;q=0.8 Authorization: Basic XXXXXXXXXXXXX Cache-Control: max-age=0 Connection: keep-alive Cookie: JSESSIONID=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.jwpc1 DNT: 1 Host: 10.10.10.x Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36 I specifically made a layout that should return content as a table view of the records.
      I have verified with PHP, and it shows the same problem.
      I have read on some forum that layouts should be made available through web-publishing as well. How to do this? I cannot find it in the documentation.
      What else am I missing?
      Hoping for an answer!
    • By Richard Fincher
      My production Filemaker Server 14 running on Mac OS X 10.11 El Capitan (Not Mac OS X Server) has been running fine for a year since I last installed the Thawte SSL Certificate.  After renewing the certifate this year, I've tried various different methods of importing the new certificate, which came with an intermediate certificate, but I can't seem to get the intermediate certificate installed.  I've been mostly using something like:
      sudo fmsadmin certificate import --keyfile /Users/richardfincher/Desktop/GBROOMX36-4X/private.key /Users/richardfincher//Desktop/GBROOMX36-4X/ssl_certificate.crt
       
      I've also tried importing it through the web control panel.  It was necessary to remove the old private key thus.:
      sudo rm /Library/FileMaker\ Server/CStore/serverKey.pem
      After it is (apparently) installed, I usually restart with :
      sudo fmsadmin restart adminserver
      although a few times I have rebooted the server (not a VM)
       
      Any thoughts welcome....
       
      Oh, one thing is, a year ago it might have been still on Mac OS X 10.8.5 Mountain Lion, which was the previous OS before I upgraded it.
  • Who Viewed the Topic

    6 members have viewed this topic:
    rivet  lucyblade  Draken Blue  jee  Kolbeinn Reginsson  Hproth 
×
×
  • Create New...

Important Information

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