Data mapping and conversions

Purpose

This document include data mapping and conversions made when fetched from remote data source into Cellosign forms. It includes all types of data sources: Applications, such as Salesforce and Databases, such as MSSQL.

Conversion is being made regardless of the primitive features of data source. For instance in Salesforce Date time is formatted as ISO-8601 string, MSSQL has it’s proprietary format. Regardless of the source, Cellosign will made available mapping and conversions for you disposal as listed in this document.

Limitations

Conversions are only made when mapping is being made using “Formula” editor. In any other case the primitive will be fetched and displayed as is.

Make sure to map data to the correct form field type in case that field is being made available for your client. For example if a date field is fetched and converted into a form field and client can edit it, it will be better be mapped to date field so the format can be consistently retained.

Mapping and conversions

Primitive	Conversion and format option	Notes and examples
Number	Ceil. Rounds a number UP to the nearest integer,	Ceil(1.1) = 2 Ceil(-7.004) = -7
	Floor. Rounds a number DOWN to the nearest integer	Floor(1.1) = 1 Floor(-7.004) = -8
	Currency format float. Thousands separator with 2 decimal digits	123456.7 converted to: 123,456.70
	Currency format integer. Thousands separator with no decimal digits	123456.7 converted to: 123,456
Date	EU date format. dd/mm/yyyy	28/02/2022
	US date format. mm/dd/yyyy	02/28/2022
	EU/US short month name. dd MMM yyyy	02 FEB 2022
	EU date time format. dd/mm/yyyy hh:mm	28/02/2022 23:35
	US date time format. mm/dd/yyyy hh:mm	02/28/2022 11:35PM
	EU short month name date time format dd MMM yyyy hh:mm	02 FEB 2022 23:35
	US short month name date time format dd MMM yyyy hh:mm	02 FEB 2022 11:35AM