Populating Default Date Field Values

By | September 10, 2018

Date fields have been a challenging and sometimes a difficult task to work with in Sage CRM. Client side scripts and JQuery has although taken up customizations to a higher level, it does requires to write a few lines of codes/functions in order to customize the Date field’s functional behavior.

New Post: Generate Unique Reference Number in Custom Field using Workflow

One of our Customer walked in with a requirement where he needed to auto-trigger a follow up mail, post 7 days of a particular process stage. This clearly describes that we had to store two Date values; i.e. ‘Current Date’ as in when the record was progressed to a particular workflow stage and ‘Follow up Date’ as in on which date the Follow up mail must be triggered. This calls for some scripting through JQuery, JavaScript etc.

However in Sage CRM, such points can be handled by setting an appropriate column value. To do the same, follow below steps –

1. Login to CRM.
2. Create a Dummy Date (Follow up Date Field) field in respective Entity for e.g. Opportunity.
3. Add this field on the respective workflow stage of Opportunity, where it should auto – calculate the 7th day from the Current Day.
4. Through the Set Column Value action on workflow, set the field value as ‘10080’. Below is the screenshot of the same.

5. Save and Activate the workflow.

Whenever the user will progress the opportunity workflow, Follow up Date will be auto – set in the database.

Similarly, we can set below integers which helps in setting column value as below –

0 = Current Date
30 = 30 minutes into future
10080 = 7 days into the future
129600 = 90 days (3 months) from now.

About Us

Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique integration solutions for Sage CRM with Sage ERPs (Sage Enterprise Management (Sage X3), Sage Intacct, Sage 100Sage 500 and Sage 300).We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.

10 thoughts on “Populating Default Date Field Values

  1. download minecraft

    We stumbled over here by a different web address and thought I may
    as well check things out. I like what I see so i am just
    following you. Look forward to looking into your web page yet again.

  2. g

    Thanks for a marvelous posting! I really enjoyed reading it, you
    happen to be a great author. I will remember to bookmark
    your blog and will come back sometime soon. I want to
    encourage you continue your great work, have a nice weekend!

  3. g

    I absolutely love your site.. Pleasant colors & theme.
    Did you build this web site yourself? Please reply back as I’m planning to
    create my own personal website and would love to learn where you
    got this from or just what the theme is named.
    Kudos!

  4. Emma Love

    Hey, how’s it going?

    I want to pass along some very important news that everyone needs to hear!

    In December of 2017, Donald Trump made history by recognizing Jerusalem as the capital of Israel. Why is this big news? Because by this the Jewish people of Israel are now able to press forward in bringing about the Third Temple prophesied in the Bible.

    Jewish Rabbis have publicly announced that their Messiah will be revealed in the coming years who will be a leader and spiritual guide to all nations, gathering all religions under the worship of one God.

    Biblical prophecy tells us that this Jewish Messiah who will take the stage will be the antichrist “who opposes and exalts himself above all that is called God or that is worshiped, so that he sits as God in the temple of God, showing himself that he is God” (2 Thessalonians 2:4). For a time he will bring about a false peace, but “Therefore when you see the ‘abomination of desolation,’ spoken of by Daniel the prophet, standing in the holy place (Matthew 24:15)…then there will be great tribulation, such as has not been since the beginning of the world until this time, no, nor ever shall be” (Matthew 24:21).

    More importantly, the power that runs the world wants to put a RFID microchip in our body making us total slaves to them. This chip matches perfectly with the Mark of the Beast in the Bible, more specifically in Revelation 13:16-18:

    “He causes all, both small and great, rich and poor, free and slave, to receive a mark on their right hand or on their foreheads, and that no one may buy or sell except one who has the mark or the name of the beast, or the number of his name.

    Here is wisdom. Let him who has understanding calculate the number of the beast, for it is the number of a man: His number is 666.”

    Referring to the last days, this could only be speaking of a cashless society, which we have yet to see, but are heading towards. Otherwise, we could still buy or sell without the mark amongst others if physical money was still currency. This Mark couldn’t be spiritual because the word references two different physical locations. If it was spiritual it would just say in the forehead. RFID microchip implant technology will be the future of a one world cashless society containing digital currency. It will be implanted in the right-hand or the forehead, and we cannot buy or sell without it. Revelation 13:11-18 tells us that a false prophet will arise on the world scene doing miracles before men, deceiving them to receive this Mark. Do not be deceived! We must grow strong in Jesus. AT ALL COSTS, DO NOT TAKE IT!

    “Then a third angel followed them, saying with a loud voice, “If anyone worships the beast and his image, and receives his mark on his forehead or on his hand, he himself shall also drink of the wine of the wrath of God, which is poured out full strength into the cup of His indignation. He shall be tormented with fire and brimstone in the presence of the holy angels and in the presence of the Lamb. And the smoke of their torment ascends forever and ever; and they have no rest day or night, who worship the beast and his image, and whoever receives the mark of his name” (Revelation 14:9-11).

    People have been saying the end is coming for many years, but we needed two key things. One, the Third Temple, and two, the technology for a cashless society to fulfill the prophecy of the Mark of the Beast.

    Visit http://WWW.BIBLEFREEDOM.COM to see proof for these things and why the Bible truly is the word of God!

    If you haven’t already, it is time to seek God with all your heart. Jesus loves you more than you could imagine. He wants to have a relationship with you and redeem you from your sins. Turn to Him and repent while there is still hope! This is forever…God bless!

    “EITHER HUMAN INTELLIGENCE ULTIMATELY OWES ITS ORIGIN TO MINDLESS MATTER OR THERE IS A CREATOR…” – JOHN LENNOX

    We all know God exists. Why? Because without Him, we couldn’t prove anything at all. Do we live our lives as if we cannot know anything? No. So why is God necessary? In order to know anything for certain, you would have to know everything, or have revelation from somebody who does. Who is capable of knowing everything? God. So to know anything, you would have to be God, or know God.

    A worldview without God cannot account for the uniformity and intelligibility of nature. And why is it that we can even reason that God is the best explanation for this if there is no God? We are given reason to know or reject God, but never to know that He does not exist.

    It has been calculated by Roger Penrose that the odds of the initial conditions for the big bang to produce the universe that we see to be a number so big, that we could put a zero on every particle in the universe, and even that would not be enough to use every zero. What are the odds that God created the universe? Odds are no such thing. Who of you would gamble your life on one coin flip?

    Is there evidence that the Bible is the truth? Yes. Did you know that the creation accounts listed in the book of Genesis are not only all correct, but are also in the correct chronological order? That the Bible doesn’t say the Earth was formed in six 24-hour days but rather six long but finite periods of time? That the Bible makes 10 times more creation claims than all major “holy” books combined with no contradictions, while these other books have errors in them? The Bible stood alone by concurring with the big bang saying, “In the beginning God created the heaven and the earth” (Genesis 1:1); and says our universe is expanding, thousands of years before scientists discovered these things. Watch a potential life-changing video on the website listed below with Astronomer(PhD) Hugh Ross explaining all these facts based on published scientific data. He has authored many books, backed even by atheist scientists.

    Jesus came to pay a debt that we could not; to be our legal justifier to reconcile us back to a Holy God; only if we are willing to receive Him: “For the wages of sin is death…” (Romans 6:23).

    God so loved the world that He gave us His only begotten son, so that whoever believes in Him, through faith, shall not perish, but have everlasting life. Jesus says if we wish to enter into life to keep the commands! The two greatest commands are to love God with all your heart, soul, strength, and mind; and your neighbor as yourself. All the law hang on these commands. We must be born of and lead by the Holy Spirit, to be called children of God, to inherit the kingdom. If we are willing to humble ourselves in prayer to Jesus, to confess and forsake our sins, He is willing to give the Holy Spirit to those who keep asking of Him; giving us a new heart, leading us into all truth!

    Jesus came to free us from the bondage of sin. The everlasting fire was prepared for the devil and his angels due to disobedience to God’s law. If we do the same, what makes us any different than the devil? Jesus says unless we repent, we shall perish. For sin is the transgression of the law. We must walk in the Spirit so we may not fulfill the lusts of the flesh, being hatred, fornication, drunkenness and the like. Whoever practices such things will not inherit the kingdom (Galatians 5:16-26). If we sin, we may come before Jesus to ask for forgiveness (1 John 2:1-2). Evil thoughts are not sins, but rather temptations. It is not until these thoughts conceive and give birth by our own desires that they become sin (James 1:12-15). When we sin, we become in the likeness of the devil’s image, for he who sins is of the devil (1 John 3:8); but if we obey Jesus, in the image of God. For without holiness, we shall not see the Lord (Hebrews 12:14).

    The oldest religion in the world is holiness through faith (James 1:27). What religion did Adam and Eve follow before the fall? Jesus, Who became the last Adam, what religion does He follow? Is He not holy? He never told us to follow the rituals and traditions of man but to take up our cross and follow Him (Luke 9:23). There are many false doctrines being taught leading people astray. This is why we need the Holy Spirit for discernment. Unlike religion, holiness cannot be created. It is given to us from above by the baptism of the Spirit. Jesus is more than a religion; He is about having a personal relationship with the Father. Start by reading the Gospel of Matthew, to hear the words of God, to know His character and commandments. Follow and obey Jesus, for He is the way, the truth, and the life!

  5. how to download minecraft free

    I’ll right away take hold of your rss as I can not to find
    your email subscription link or newsletter service.
    Do you have any? Please let me realize in order that I could
    subscribe. Thanks.

  6. Jesus Calling

    Hey, how’s it going?

    I want to pass along some very important news that everyone needs to hear!

    In December of 2017, Donald Trump made history by recognizing Jerusalem as the capital of Israel. Why is this big news? Because by this the Jewish people of Israel are now able to press forward in bringing about the Third Temple prophesied in the Bible.

    Jewish Rabbis have publicly announced that their Messiah will be revealed in the coming years who will be a leader and spiritual guide to all nations, gathering all religions under the worship of one God.

    Biblical prophecy tells us that this Jewish Messiah who will take the stage will be the antichrist “who opposes and exalts himself above all that is called God or that is worshiped, so that he sits as God in the temple of God, showing himself that he is God” (2 Thessalonians 2:4). For a time he will bring about a false peace, but “Therefore when you see the ‘abomination of desolation,’ spoken of by Daniel the prophet, standing in the holy place (Matthew 24:15)…then there will be great tribulation, such as has not been since the beginning of the world until this time, no, nor ever shall be” (Matthew 24:21).

    More importantly, the power that runs the world wants to put a RFID microchip in our body making us total slaves to them. This chip matches perfectly with the Mark of the Beast in the Bible, more specifically in Revelation 13:16-18:

    “He causes all, both small and great, rich and poor, free and slave, to receive a mark on their right hand or on their foreheads, and that no one may buy or sell except one who has the mark or the name of the beast, or the number of his name.

    Here is wisdom. Let him who has understanding calculate the number of the beast, for it is the number of a man: His number is 666.”

    Referring to the last days, this could only be speaking of a cashless society, which we have yet to see, but are heading towards. Otherwise, we could still buy or sell without the mark amongst others if physical money was still currency. This Mark couldn’t be spiritual because the word references two different physical locations. If it was spiritual it would just say in the forehead. RFID microchip implant technology will be the future of a one world cashless society containing digital currency. It will be implanted in the right-hand or the forehead, and we cannot buy or sell without it. Revelation 13:11-18 tells us that a false prophet will arise on the world scene doing miracles before men, deceiving them to receive this Mark. Do not be deceived! We must grow strong in Jesus. AT ALL COSTS, DO NOT TAKE IT!

    “Then a third angel followed them, saying with a loud voice, “If anyone worships the beast and his image, and receives his mark on his forehead or on his hand, he himself shall also drink of the wine of the wrath of God, which is poured out full strength into the cup of His indignation. He shall be tormented with fire and brimstone in the presence of the holy angels and in the presence of the Lamb. And the smoke of their torment ascends forever and ever; and they have no rest day or night, who worship the beast and his image, and whoever receives the mark of his name” (Revelation 14:9-11).

    People have been saying the end is coming for many years, but we needed two key things. One, the Third Temple, and two, the technology for a cashless society to fulfill the prophecy of the Mark of the Beast.

    Visit http://WWW.BIBLEFREEDOM.COM to see proof for these things and why the Bible truly is the word of God!

    If you haven’t already, it is time to seek God with all your heart. Jesus loves you more than you could imagine. He wants to have a relationship with you and redeem you from your sins. Turn to Him and repent while there is still hope! This is forever…God bless!

    “EITHER HUMAN INTELLIGENCE ULTIMATELY OWES ITS ORIGIN TO MINDLESS MATTER OR THERE IS A CREATOR…” – JOHN LENNOX

    We all know God exists. Why? Because without Him, we couldn’t prove anything at all. Do we live our lives as if we cannot know anything? No. So why is God necessary? In order to know anything for certain, you would have to know everything, or have revelation from somebody who does. Who is capable of knowing everything? God. So to know anything, you would have to be God, or know God.

    A worldview without God cannot account for the uniformity and intelligibility of nature. And why is it that we can even reason that God is the best explanation for this if there is no God? We are given reason to know or reject God, but never to know that He does not exist.

    It has been calculated by Roger Penrose that the odds of the initial conditions for the big bang to produce the universe that we see to be a number so big, that we could put a zero on every particle in the universe, and even that would not be enough to use every zero. What are the odds that God created the universe? Odds are no such thing. Who of you would gamble your life on one coin flip?

    Is there evidence that the Bible is the truth? Yes. Did you know that the creation accounts listed in the book of Genesis are not only all correct, but are also in the correct chronological order? That the Bible doesn’t say the Earth was formed in six 24-hour days but rather six long but finite periods of time? That the Bible makes 10 times more creation claims than all major “holy” books combined with no contradictions, while these other books have errors in them? The Bible stood alone by concurring with the big bang saying, “In the beginning God created the heaven and the earth” (Genesis 1:1); and says our universe is expanding, thousands of years before scientists discovered these things. Watch a potential life-changing video on the website listed below with Astronomer(PhD) Hugh Ross explaining all these facts based on published scientific data. He has authored many books, backed even by atheist scientists.

    Jesus came to pay a debt that we could not; to be our legal justifier to reconcile us back to a Holy God; only if we are willing to receive Him: “For the wages of sin is death…” (Romans 6:23).

    God so loved the world that He gave us His only begotten son, so that whoever believes in Him, through faith, shall not perish, but have everlasting life. Jesus says if we wish to enter into life to keep the commands! The two greatest commands are to love God with all your heart, soul, strength, and mind; and your neighbor as yourself. All the law hang on these commands. We must be born of and lead by the Holy Spirit, to be called children of God, to inherit the kingdom. If we are willing to humble ourselves in prayer to Jesus, to confess and forsake our sins, He is willing to give the Holy Spirit to those who keep asking of Him; giving us a new heart, leading us into all truth!

    Jesus came to free us from the bondage of sin. The everlasting fire was prepared for the devil and his angels due to disobedience to God’s law. If we do the same, what makes us any different than the devil? Jesus says unless we repent, we shall perish. For sin is the transgression of the law. We must walk in the Spirit so we may not fulfill the lusts of the flesh, being hatred, fornication, drunkenness and the like. Whoever practices such things will not inherit the kingdom (Galatians 5:16-26). If we sin, we may come before Jesus to ask for forgiveness (1 John 2:1-2). Evil thoughts are not sins, but rather temptations. It is not until these thoughts conceive and give birth by our own desires that they become sin (James 1:12-15). When we sin, we become in the likeness of the devil’s image, for he who sins is of the devil (1 John 3:8); but if we obey Jesus, in the image of God. For without holiness, we shall not see the Lord (Hebrews 12:14).

    The oldest religion in the world is holiness through faith (James 1:27). What religion did Adam and Eve follow before the fall? Jesus, Who became the last Adam, what religion does He follow? Is He not holy? He never told us to follow the rituals and traditions of man but to take up our cross and follow Him (Luke 9:23). There are many false doctrines being taught leading people astray. This is why we need the Holy Spirit for discernment. Unlike religion, holiness cannot be created. It is given to us from above by the baptism of the Spirit. Jesus is more than a religion; He is about having a personal relationship with the Father. Start by reading the Gospel of Matthew, to hear the words of God, to know His character and commandments. Follow and obey Jesus, for He is the way, the truth, and the life!

  7. minecraft download mojang

    A person necessarily assist to make severely posts I would state.
    This is the first time I frequented your web page and thus far?
    I surprised with the research you made to make this
    particular put up amazing. Excellent activity!

  8. Free Stuff

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove people from that service? Appreciate it!

Leave a Reply

Your email address will not be published.