Cellica Database Anywhere for Android: FAQ


Is my database secured?

Yes, Data transfer between Android device side Cellica Database Anywhere and Server application is secured as 128 bit AES is used for encryption.


Does software send complete database every time?

No, This software sends only changed records like new/updated/deleted records and not complete database each time.


What is evaluation period of this software?

Software has 10 days evaluation period. In 10 days, software will work with all features and functionalities. After 10 days, Desktop side application will ask for license key. Then visit Cellica to purchase the software. After purchasing the software, you will get license key. Use it in following activation form.


I have to change the PC where I have installed desktop software, can I install the software on new PC ?

Please uninstall desktop software from your old PC first and then only install software on new PC. To change the computer, you must uninstall software from old computer first.


Does I need to create forms compulsary in desktop software?

No, it is not compulsory. Just create profile (select tables/views/stored procedures) and sync. Make sure that in Preferences of Cellica DB Anywhere application on Android, �Preferences of Home Screen� options has set to Both or Profiles.


How to re-install desktop software after a PC crash?

Please send us IMEI/MEID/MAC Address of your Android Touch to support@cellica.com and write us exact reason what happened with the PC where you had installed desktop software.


How I can use device id in Cellica Database Anywhere?

Drag TextBox control on form and set �Content Type� property of TextBox on form to �IMEI/MEID/MAC Address�. Now on device when you create new record this field will be populated by device�s IMEI/MEID/MAC Address.


How I can can input/read qrcode/barcode in Cellica Database Anywhere?

There are two ways to accomplish reading Qrcode/BarCodes

A) Using inbuilt camera to scan QR/BarCode.

In this case we need to use �Content Type� property of TextBox on form. Set this property to �QR Code�.

B) Using external barcode scanner.

In this case we need to use �Content Type� property of TextBox on form. Set this property to �QR Code�.

In this case, barcode scanner needs to be connected with device using Bluetooth. Tap in text field in New/Edit mode and then scan value using external barcode scanner. It will be put in text field automatically.


How to use phone call Feature and Send Email Feature on forms?

Use button control on form and then set button action to one of the desired action, �Send email� or �Phone call�. Now set the �Data Column� property to set the destination field of profile whose data you want to use.


How to use image control for displaying logo?

Drag Unbound image control on form and set �Content Type� Property to �Logo�. Now on device you have to choose image for this control only once and same will be displayed for all records.


How to use FileMaker Pro to create profiles in desktop application?

A) Until version Filemaker Pro 7

You can create profiles using File base connection (Select your Filemaker Pro Database directly while creating Profile using �Browse� button) and Using DSN base connection (Create DSN of your Filemaker Pro database by using the ODBC driver for Filemaker Pro) on profile connection page.

B) After Version FileMaker Pro 7

Only DSN base connection will work. Create DSN of your Filemaker Pro database by using the ODBC driver for Filmmaker Pro.


How to select multiple controls on form designer?

On Main form:

a. Hold CTRL Key & Select Controls one by one.

b. Drag a rectangle over the controls to select the Controls.

On Subform

a. Hold CTRL Key & Select Controls one by one.


How to work with multiple controls in form designer?

Moving multiple controls

a) Select multiple controls.

b) Now use Arrow keys to move the multiple controls on the form. Or Hold SHIFT Key and Drag Selected Controls to desired place.

Resizing multiple controls

a) Select multiple controls.

b) Use Shift Key + Arrow Keys to resize multiple controls.


I am getting message, Device ID �XXXXXX� already present?

This message appears when installation for same ID is present for single user version or device with this ID is added in Enterprise edition.


Can I associate record timestamp with database record?

You can do this with Cellica Database Anywhere. Profile should have column with type DateTime (Timestamp). Drag �DateTime� control on form, set its Data column property to Timestamp column in which you want to save �Record Timestamp�. Now set �Def Val_Type� property of DateTime control to �Timestamp�. Now when you add or edit record on device side, this field is populated with current timestamp. If you want to do this in background then you can do this by setting �Visible� property of DateTime Control to �TRUE.


How can I associate digital signature with record?

Drag �Bounded Image� control on form set its data column property to column with binary type. Now set the �Content Type� property to �Signature�. On device side user can attach signature with this record by tapping on this control and this will be synced with desktop.


How Cellica Database Anywhere handles Image/Signature data?

Image/Signature data is considered as binary data in Cellica Database Anywhere. Cellica Database Anywhere stores Image/Signature data in binary format in user database. User can use this binary data to display Image/Signature in his application or he can view Image/Signature using �View Data�( Ref. 1.1.4 View Profile Data) option in desktop Cellica Database Anywhere. User can also export Image/Signature data in external file in .png format using "Save" button from view data option.


How I can backup my form design work/ Forms/ How I can avoid redesigning of forms/ How I can reuse form/ How I can rename form?

There are 2 ways you can save your form designing work

a) Export multiple forms using �Export� option available on Form Manager Click on �Export� button on Form Manager, you will be presented with list of existing form, select one or more forms from the list, and choose �Export�. Select location for saving forms (.fm) files.

b) Using export button on toolbar in Form Designer window Sometimes you may want to take backup of your form while you are in between form designing process before making big change in design. For this purpose there is �Export Form� button on toolbar on Form Designer Window. Click it to export your existing form layout and save it.


Can I use forms designed with single user edition in enterprise edition?

Yes, Form designed with single user edition can be used in enterprise edition. You need to export forms from single user edition( ref 11) and import them in Enterprise edition form manager while creating new form.


How can I sync my database automatically?

From Settings form, select �Sync Settings� option and disable Sync menu option. Now set interval of syncing in days, hours and in minutes.

To start synchronization automatically, In Settings form of Cellica Database Anywhere on your Android Phone/Tablet, Set �Sync Menu� option to OFF. This will allow you to set �Sync Interval. In Sync Interval you can set Day, Hours, and Minutes.


How can I change column width in Multi Column view (Grid View)?

Please Tap on Grid view on particular column whose width you want to change and hold there for few seconds, Context menu will appear. Select �Resize Column Width� menu to change the width.


Whenever I add/edit/delete record on Android device, in Record view I get Red/Cyan color.

Cyan color indicates that record synchronization is still in progress. Red color indicates that Record has problem while syncing with desktop database. Status menu shows information related with record syncing process.


How to scan Bar code in Cellica Database?

You need to hold for few seconds on Text Box in Form and it will display menu "Scan Barcode".

On clicking this �Scan Barcode� menu, you will get another dialog, where you have to select type of bar code you want to scan (�Scan QR Code/ Scan Product/Auto Detect�).

Software will scan the Bar code according to this and display data in text box.

Scan QR Code: Use this option to scan QR Code.

Scan Product: Use this option to scan One Dimensional Bar codes on products.

Auto Detect: Use this option, if you do not know the Bar code type.

You can get barcode scanning option in Text Box control on forms, Search Field and in editing profile data.

PS: To enable barcode scanning functionality on your device, you should have installed "Barcode Scanner" application on your Android device.