Hello world! Welcome to WordPress. This is your first post. Edit or delete it, Read More → kobi September 2, 2022 1 Comment
Uncategorized Quasi distinctio molestiae quibusdam excepturi quia accusamus Molestias et omnis ex. Corrupti aperiam dolor sed vel veniam praesentium sit. Read More → kobi April 28, 2020 No Comments
Uncategorized Optio cum asperiores vel Id ut ratione porro sed rem ipsa sit A voluptatum in et Read More → kobi April 28, 2020 No Comments
Apps and databases connector Data mapping and conversions Estimated reading: 2 minutes 210 views 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 PrimitiveConversion and format optionNotes and examplesNumberCeil. Rounds a number UP to the nearest integer,Ceil(1.1) = 2Ceil(-7.004) = -7Floor. Rounds a number DOWN to the nearest integerFloor(1.1) = 1Floor(-7.004) = -8Currency format float. Thousands separator with 2 decimal digits123456.7 converted to: 123,456.70Currency format integer. Thousands separator with no decimal digits123456.7 converted to: 123,456DateEU date format. dd/mm/yyyy28/02/2022US date format. mm/dd/yyyy 02/28/2022EU/US short month name. dd MMM yyyy 02 FEB 2022EU date time format. dd/mm/yyyy hh:mm28/02/2022 23:35US date time format. mm/dd/yyyy hh:mm02/28/2022 11:35PMEU short month name date time format dd MMM yyyy hh:mm02 FEB 2022 23:35US short month name date time format dd MMM yyyy hh:mm02 FEB 2022 11:35AM Apps and databases connector - Previous Integrating connector and template
