# Uncategorized **URL:** https://community.spicecrm.io/c/uncategorized/1.md [Latest](https://community.spicecrm.io/latest.md) · [Categories](https://community.spicecrm.io/categories.md) --- ## [Welcome to SpiceCRM](https://community.spicecrm.io/t/welcome-to-spicecrm/8)
**Author:** [@system](https://community.spicecrm.io/u/system)\ **Replies:** 0\ **Last updated:** [November 16, 2016, 3:04pm UTC](https://community.spicecrm.io/t/welcome-to-spicecrm/8 "2016-11-16T15:04:49Z")
Welcome to the SpiceCRM Community Page! --- ## [Number of days between datetime and date fields](https://community.spicecrm.io/t/number-of-days-between-datetime-and-date-fields/796)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [June 1, 2026, 4:10pm UTC](https://community.spicecrm.io/t/number-of-days-between-datetime-and-date-fields/796 "2026-06-01T16:10:04Z")
If you have one datetime and another date field. DATEDIFF(DATE({tc}.quote\_relDATETIMEase\_date\_c), {tc}.DATE) OR DATEDIFF(CAST({tc}.DATETIME AS DATE), {tc}.DATE) --- ## [How to find date difference between datetime and date field](https://community.spicecrm.io/t/how-to-find-date-difference-between-datetime-and-date-field/785)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 2\ **Last updated:** [November 3, 2025, 4:26pm UTC](https://community.spicecrm.io/t/how-to-find-date-difference-between-datetime-and-date-field/785 "2025-11-03T16:26:53Z")
Is it possible to calculate the date different between datetime and date fields using below CustomFunction? @maretval datediff({tc}.DateTime,{tc}.Date) --- ## [Hide enum options by division rule](https://community.spicecrm.io/t/hide-enum-options-by-division-rule/783)
**Author:** [@gabs](https://community.spicecrm.io/u/gabs)\ **Replies:** 1\ **Last updated:** [October 14, 2025, 3:03pm UTC](https://community.spicecrm.io/t/hide-enum-options-by-division-rule/783 "2025-10-14T15:03:25Z")
Hello everyone, how are you? Is it possible to hide some enum options from a domain when I select a division inside the CRM? For example, if I select Division AUS, the options Agent and Competitor should be hidden. Is i… --- ## [Dropdown list not showing up after domain and dictionary setup](https://community.spicecrm.io/t/dropdown-list-not-showing-up-after-domain-and-dictionary-setup/782)
**Author:** [@gabs](https://community.spicecrm.io/u/gabs)\ **Replies:** 3\ **Last updated:** [September 19, 2025, 1:42pm UTC](https://community.spicecrm.io/t/dropdown-list-not-showing-up-after-domain-and-dictionary-setup/782 "2025-09-19T13:42:07Z")
Hello everyone, how are you doing? Could someone give me a hand? I’m trying to create a dropdown list. I created a new domain, set up the list, and added it to the dictionary. But even so, when I select the field, the l… --- ## [Ability to Mass Update or Bulk Update from selected records](https://community.spicecrm.io/t/ability-to-mass-update-or-bulk-update-from-selected-records/765)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 3\ **Last updated:** [March 26, 2025, 6:43pm UTC](https://community.spicecrm.io/t/ability-to-mass-update-or-bulk-update-from-selected-records/765 "2025-03-26T18:43:50Z")
Ability to Mass Update or Bulk Update from selected records Hello SpiceCRM, User Story The user has a series of Leads where the ‘Status’ needs to be updated - the user would like to Select the leads in question, and t… --- ## [Scheduled Reports fail if report has zero results](https://community.spicecrm.io/t/scheduled-reports-fail-if-report-has-zero-results/763)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 3\ **Last updated:** [March 7, 2025, 5:34pm UTC](https://community.spicecrm.io/t/scheduled-reports-fail-if-report-has-zero-results/763 "2025-03-07T17:34:30Z")
Scheduled Reports fail if report has zero results it is expected that a report with zero results is still a report outcome and should be delivered via the schedule report function in Kreporter via email The ‘Scheduler … --- ## [General Inquiry re: User Group Management & record-level acl](https://community.spicecrm.io/t/general-inquiry-re-user-group-management-record-level-acl/762)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 4\ **Last updated:** [March 7, 2025, 4:45pm UTC](https://community.spicecrm.io/t/general-inquiry-re-user-group-management-record-level-acl/762 "2025-03-07T16:45:57Z")
We are working on getting our heads around the method of applying ACLs to an ORG Unit. We would like to add an Org Unit to an ACL Profile – then when adding a User to the Org Unit, they should have the related ACL Pro… --- ## [SpiceCRM features](https://community.spicecrm.io/t/spicecrm-features/757)
**Author:** [@buxalex](https://community.spicecrm.io/u/buxalex)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 12:27pm UTC](https://community.spicecrm.io/t/spicecrm-features/757 "2024-11-25T12:27:22Z")
Hello, I would like to know whether SpiceCRM supports following features: B2B2X Next Best Action Knowledge Management AI & NLP in Sales Brand Management Thank you Alessandro --- ## [Deleted records showing in listview then need to reload\\](https://community.spicecrm.io/t/deleted-records-showing-in-listview-then-need-to-reload/753)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 2\ **Last updated:** [November 15, 2024, 6:55am UTC](https://community.spicecrm.io/t/deleted-records-showing-in-listview-then-need-to-reload/753 "2024-11-15T06:55:46Z")
deleted records showing in listview then need to reload We are testing leads and then deleting them by selecting the records in the list view and using the ‘bulk action’ function to delete – the page refreshes and the l… --- ## [Deleted lead not in trashcan manager](https://community.spicecrm.io/t/deleted-lead-not-in-trashcan-manager/750)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 1\ **Last updated:** [November 1, 2024, 7:37pm UTC](https://community.spicecrm.io/t/deleted-lead-not-in-trashcan-manager/750 "2024-11-01T19:37:37Z")
deleted lead not in trashcan manager version 2024.01.001.1730185005854 I deleted a Lead from the Leads detail view using the action item at top right I wanted to retrieve this lead so I went to the Trashcan Manager… --- ## [MS 365 Meeting Sync has Description field type mismatch](https://community.spicecrm.io/t/ms-365-meeting-sync-has-description-field-type-mismatch/746)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 4\ **Last updated:** [October 28, 2024, 12:27pm UTC](https://community.spicecrm.io/t/ms-365-meeting-sync-has-description-field-type-mismatch/746 "2024-10-28T12:27:55Z")
MS 365 Meeting Sync has a Description field type mismatch with corresponding SpiceCRM Meeting module mapping (description field) version: 2024.01.001.1728367438391 steps to reproduce sign on with MS 365 single signon… --- ## [Bulk action - select all only selects visible not all](https://community.spicecrm.io/t/bulk-action-select-all-only-selects-visible-not-all/743)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 2\ **Last updated:** [October 18, 2024, 6:42pm UTC](https://community.spicecrm.io/t/bulk-action-select-all-only-selects-visible-not-all/743 "2024-10-18T18:42:36Z")
Hello SpiceCRM I was wonder how we can ‘select all’ in the Listview – it appears that ‘select all’ will only select those records that are visible - eg I have 1995 leads and in order to select all leads- i would have to… --- ## [Open source & free](https://community.spicecrm.io/t/open-source-free/720)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [February 19, 2024, 3:25pm UTC](https://community.spicecrm.io/t/open-source-free/720 "2024-02-19T15:25:48Z")
Hello, When will you provide open-source free version of the SpiceCRM? --- ## [Google Calendar sync does not update when edits in Google](https://community.spicecrm.io/t/google-calendar-sync-does-not-update-when-edits-in-google/693)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 0\ **Last updated:** [March 3, 2023, 9:27am UTC](https://community.spicecrm.io/t/google-calendar-sync-does-not-update-when-edits-in-google/693 "2023-03-03T09:27:37Z")
Hello, I was working with the Google calendar sync and came across 3 issues: I created a new Meeting in SpiceCRM - and it synced to Google immediately (correct) I edited the Meeting in Google to add some text to the d… --- ## [Spring '17 release](https://community.spicecrm.io/t/spring-17-release/98)
**Author:** [@nommaz](https://community.spicecrm.io/u/nommaz)\ **Replies:** 7\ **Last updated:** [March 2, 2023, 1:57pm UTC](https://community.spicecrm.io/t/spring-17-release/98 "2023-03-02T13:57:09Z")
Hello, Since Spring is here, I have to ask if you are unofficially targeting a particular date for the new version? Cheers! --- ## [Npm start does not work](https://community.spicecrm.io/t/npm-start-does-not-work/675)
**Author:** [@damian.kowalski](https://community.spicecrm.io/u/damian.kowalski)\ **Replies:** 1\ **Last updated:** [April 20, 2022, 1:26pm UTC](https://community.spicecrm.io/t/npm-start-does-not-work/675 "2022-04-20T13:26:09Z")
When using an updated version of SpiceCRM and trying to locally run the front-end by typing npm start into the console this is the error I get: ⠋ Generating browser application bundles (phase: setup)…An unhandled except… --- ## [User / Admin Documentation](https://community.spicecrm.io/t/user-admin-documentation/627)
**Author:** [@tornmarketing](https://community.spicecrm.io/u/tornmarketing)\ **Replies:** 8\ **Last updated:** [March 14, 2022, 4:09pm UTC](https://community.spicecrm.io/t/user-admin-documentation/627 "2022-03-14T16:09:01Z")
Hey team, Is there any updated documentation beyond the installation guides? I know this was once active but have nothing there anymore https://knowledgebase.spicecrm.io/ ie wanting to confirm the upgrade process? … --- ## [Logic Hooks, custom schedulers and packages](https://community.spicecrm.io/t/logic-hooks-custom-schedulers-and-packages/634)
**Author:** [@chillidev](https://community.spicecrm.io/u/chillidev)\ **Replies:** 3\ **Last updated:** [February 1, 2022, 2:19pm UTC](https://community.spicecrm.io/t/logic-hooks-custom-schedulers-and-packages/634 "2022-02-01T14:19:56Z")
Hi Spice Community! I have a developer question. Imagine on save of a new Contact, I would like to trigger a request to a third party system. Could I develop a logic hook in Spice to do this? Could I create a custom s… --- ## [Custom width of columns in list views - per user](https://community.spicecrm.io/t/custom-width-of-columns-in-list-views-per-user/606)
**Author:** [@srazvigorov](https://community.spicecrm.io/u/srazvigorov)\ **Replies:** 4\ **Last updated:** [November 30, 2021, 1:43pm UTC](https://community.spicecrm.io/t/custom-width-of-columns-in-list-views-per-user/606 "2021-11-30T13:43:32Z")
Is there an option users of SpiceCRM to change the width of columns in List view of specific module and the changes to be in place next time the users open the modified list view? --- ## [API documentation](https://community.spicecrm.io/t/api-documentation/628)
**Author:** [@tornmarketing](https://community.spicecrm.io/u/tornmarketing)\ **Replies:** 5\ **Last updated:** [October 22, 2021, 8:47am UTC](https://community.spicecrm.io/t/api-documentation/628 "2021-10-22T08:47:57Z")
Hey team, Is there any recent API documentation? and working examples? Looking at what options we have to integrate with Zapier, Integromat or N8N I know the front end is all API, so assuming it should be a rather sim… --- ## [Can't upload CSV on my computer only](https://community.spicecrm.io/t/cant-upload-csv-on-my-computer-only/612)
**Author:** [@davindersangha](https://community.spicecrm.io/u/davindersangha)\ **Replies:** 4\ **Last updated:** [July 15, 2021, 3:58pm UTC](https://community.spicecrm.io/t/cant-upload-csv-on-my-computer-only/612 "2021-07-15T15:58:08Z")
Uploading leads. Strange thing is my computer is the only one where I get an error message saying MSG\_ONLY\_CSV\_ALLOWED Now we’ve used the same file on two other computers and they work. However, when others log in to m… --- ## [Configuration of column width in List views](https://community.spicecrm.io/t/configuration-of-column-width-in-list-views/607)
**Author:** [@srazvigorov](https://community.spicecrm.io/u/srazvigorov)\ **Replies:** 1\ **Last updated:** [June 30, 2021, 7:48pm UTC](https://community.spicecrm.io/t/configuration-of-column-width-in-list-views/607 "2021-06-30T19:48:07Z")
In the fields sets configuration there is an option to define how many “number of parts” to be allocated for visualization. It seems entering a number there to have no effect on column width in the interface. Any idea wh… --- ## [Database Type dropdown is blank. Stops installation](https://community.spicecrm.io/t/database-type-dropdown-is-blank-stops-installation/597)
**Author:** [@kevinjackson](https://community.spicecrm.io/u/kevinjackson)\ **Replies:** 4\ **Last updated:** [June 8, 2021, 8:12am UTC](https://community.spicecrm.io/t/database-type-dropdown-is-blank-stops-installation/597 "2021-06-08T08:12:17Z")
Trying to install SpiceCRM and I get stuck choosing Database Type on Database Configuration screen. I’ve also observed the System Requirements spinner spinning for \< 20 seconds… …then returning a “blank” screen with no… --- ## [Login hang after install](https://community.spicecrm.io/t/login-hang-after-install/589)
**Author:** [@andrejohn](https://community.spicecrm.io/u/andrejohn)\ **Replies:** 11\ **Last updated:** [May 10, 2021, 1:57pm UTC](https://community.spicecrm.io/t/login-hang-after-install/589 "2021-05-10T13:57:17Z")
I set up an new server with ubuntu 18.04, PHP 7.2 and mysql by using the howto. after installation i try my login, but crm hangs on … loading Repository Items … any idea? --- ## [Turn on the forgot password from scri\[pt?](https://community.spicecrm.io/t/turn-on-the-forgot-password-from-scri-pt/578)
**Author:** [@badbach](https://community.spicecrm.io/u/badbach)\ **Replies:** 3\ **Last updated:** [February 3, 2021, 7:24pm UTC](https://community.spicecrm.io/t/turn-on-the-forgot-password-from-scri-pt/578 "2021-02-03T19:24:31Z")
I still cannot login to my new install as admin. Is there a way to enable the forgot password from the backend or some script? --- ## [Error message on attempting to archive email in Gmail using SpiceCRM Extension](https://community.spicecrm.io/t/error-message-on-attempting-to-archive-email-in-gmail-using-spicecrm-extension/587)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 1\ **Last updated:** [February 3, 2021, 7:15pm UTC](https://community.spicecrm.io/t/error-message-on-attempting-to-archive-email-in-gmail-using-spicecrm-extension/587 "2021-02-03T19:15:52Z")
Gmail Extension for SpiceCRM shows error message when attempting to archive an email Additionally, there is no way to ‘go back’ or navigate away from the error message without reloading the Gmail page. NOTE: Groupwar… --- ## [Any way to change the admin password though phpmyadmin?](https://community.spicecrm.io/t/any-way-to-change-the-admin-password-though-phpmyadmin/577)
**Author:** [@badbach](https://community.spicecrm.io/u/badbach)\ **Replies:** 1\ **Last updated:** [December 16, 2020, 12:38am UTC](https://community.spicecrm.io/t/any-way-to-change-the-admin-password-though-phpmyadmin/577 "2020-12-16T00:38:57Z")
Just finally got my spicecrm loaded and cannot login. I can get to the database on MySQL server and wondered if I can change the hash and fix it there. I can go into the phpmyadmin and in the table structure I can go to… --- ## [Business model of SpiceCRM](https://community.spicecrm.io/t/business-model-of-spicecrm/566)
**Author:** [@manasan](https://community.spicecrm.io/u/manasan)\ **Replies:** 1\ **Last updated:** [December 6, 2020, 9:10am UTC](https://community.spicecrm.io/t/business-model-of-spicecrm/566 "2020-12-06T09:10:10Z")
I am interested in the profit model of SpiceCRM, how does the company makes profit? --- ## [CRM Documentation](https://community.spicecrm.io/t/crm-documentation/452)
**Author:** [@bhavin](https://community.spicecrm.io/u/bhavin)\ **Replies:** 2\ **Last updated:** [November 20, 2020, 1:13pm UTC](https://community.spicecrm.io/t/crm-documentation/452 "2020-11-20T13:13:00Z")
Hi Folks, Do we have a below documentations of CRM? User Guide. Developer Guide. Administration Guide. [Next page](https://community.spicecrm.io/c/uncategorized/1.md?page=1)