How to specify the format of you fields when sending in through webservice
In the default behaviour, a webservice call to either revise or update will demand you to make sure all fields are sent to coreBOS in the form of your current user. This applies in particular to number and currency fields, but also to date fields.

Let’s say you use user ‘John’ to login to coreBOS through a webservice in a remote application (maybe some customer portal). John has his preferences stored in the user settings page for his user. He likes his thousands separator to be a dot, his decimals separator to be a comma and he wants only two decimals. So his currency fields and numbers would be formatted like:

1.234,56

In the database however, the number would be stored like this:

1234.560000 if it’s a currency field, or

1234.56 if it was for instance a percentage.

When you send a record, or part of a record to either the revise or update webservice methods, you would be expected to send in the data in the format of the user that sends the data in. So for John, he would have to send in ‘1.234,56’ on a currency field to end up with ‘1234.560000’ in the database. When logged in to coreBOS, coreBOS would take care of the correct formatting when John views or edits a record.

But what if John sends in the value in database-format? What if he would send in ‘1234.560000’ for his currency field? Well, coreBOS wouldn’t understand that and try to convert it to the database format anyway. Since John uses the dot as his thousands separator, coreBOS would remove that from the value first, since databases don’t know this concept. Then coreBOS would apply decimals, if there weren’t any to start with. CoreBOS would expect those to be indicated with a comma, since it knows it’s John that sends in the data.

Now John would end up with the number ‘1234560000.000000’ in the database. In the application, he would see ‘1.234.560.000,00’, which is not what he wanted.
So John has to make sure he sends in all currency and number fields in the format he specified in his user preferences.

But, since 26-07-2018, he could also do something else. He could add a special flag (or multiple) to his data, that tells coreBOS what to expect. Say John is updating a Potential with this data:

I wish setting a default filter for my users.

Today system exhibit filter "All" or in the better situation, if user has only one filter marked as Default.

Problem is, my default filter is setting in my admin user.

Better solution is setting a global variable, because in this way, I can standarized for a role or group.

Lets say you use timecontrol to keep track of the time spent on projects. You create timecontrol records from the project tasks, but you also want to carry over the account on the project to the timecontrol record, even though the projecttask is not directly related to the account.

You'd need the following business map (adjust to fit you exact needs)

My cron gives me the following result:

[ERROR]: ScheduleReports - cron task execution throwed exception.
DateTime::__construct(): Failed to parse time string (1970-01-01 25:43) at position 11 (2): Unexpected character

The time clearly seems off. Does anyone have any experience with this problem?

When I tried impor comments, system shows error at created cbCalendar db

At log
2018-07-23T18:24:40+00:00 DEBUG index Prepared sql query parameters : [110665]
2018-07-23T18:24:40+00:00 DEBUG index Prepared sql query being executed : INSERT INTO vtiger_activity_reminder_popup (semodule, recordid, date_start, time_start, status) VALUES (?,?,?,?,0)
2018-07-23T18:24:40+00:00 DEBUG index Prepared sql query parameters : [Calendar,110665,????,]
2018-07-23T18:24:40+00:00 INFO  VT PearDatabase ->ADODB error  Query Failed:INSERT INTO vtiger_activity_reminder_popup (semodule, recordid, date_start, time_start, status) VALUES (?,?,?,?,0)::->[1048]Column 'time_start' cannot be null
2018-07-23T18:24:40+00:00 INFO  VT PearDatabase ->TRANS Rolled Back
2018-07-23T18:24:40+00:00 INFO  VT PearDatabase ->TRANS Completed
2018-07-23T18:24:40+00:00 INFO  VT PearDatabase ->TRANS saveentity ends

I think I've asked this before, but somewhere in a thread that I can't find anymore. So here's twice then:

If I create a workflow task that updates a field on a related module, will that update in turn trigger the workflow system on the record to which that related field belongs?

Are there any plans to add calendar integration with CalDAV calendars? I would be very happy if I could switch from GCal to Nextcloud where I control most of my calendars.

I was wondering if we have something like a maintenance mode, that would disable users from being able to login (and logout already logged in users) and disable webservices, so we could do some maintenance without worrying about changes to the database being made.

Buenos días:

No sé si alguien me puede ayudar en la organización de la información

Me gustaría ordenar por la fecha de creación del más nuevo al más antiguo lo que se visualiza en el módulo cuando es seleccionado, por ejemplo en eventos, cuando accedo a ellos, me pone el primer resultado el más antiguo y el último resultado el más nuevo, y quiero invertir ese orde ¿Cómo podría hacerlo?

http://localhost/index.php?action=index&module=cbCalendar

I read we can only use autocomplete on UI types 10 and 2. That's fine for newer custom modules, but in most system modules like salesorders or invoice we have more 'exotic' types like 73 or 57. What is the reason we can't use autocomplete business maps on those?