• SugarQuery Having Max(datefield) < xxxx-xx-xx

    Hi, I need to create a query which selects contacts which only having cases older then one year. I managed to create a working MySQL query, but how to convert it to a SugarQuery? Anyone any experience with this type of query? MySQL SELECT contacts…

  • How to change date format?

    Hi, To change the date format to ' dd-mm '. Thank you.

  • Get user who checked a checkbox and add the user in Relate field(Users module)

    Hi, I have 3 fields: Checkbox, Relate field & Date in my custom module. All users can access the module but only few users can edit or update the fields. Here, when a user logs in and checked the checkbox, I need the get the user and update him in the…

  • Auto-Creation of Tasks Leading up to a Specific Date Field (ie due 150 days Before Date)

    Hello, trying to figure out if this is possible within Process Definition or if needs to be coded. I'm trying to set off a chain of tasks that need to be created based on a date in the future. For example, let's say an annual conference event date field…

  • Custom Date field "range Search" does not show in "Popup Search"

    Hello, I Created a Date Field in the Accounts module called "Founded Date" and marked the "Range Search" property so i could find Accounts in a range of dates. i added the field to the basic search and the Popup Search. In the Basic Search i see the range…