Cellica Database Anywhere for iPad: FAQ


Is my database secured?

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


How to get UDID of iPad?

To get UDID, connect your device to your Mac/PC and launch iTunes. In iTunes, select your device in the �Devices� section and navigate to the Summary tab. Click on the Serial Number label to reveal the Identifier field and the 40 characters UDID. Press Ctrl+C to copy the Device ID to your clipboard, and paste it in Device ID and Confirm Device ID field.


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 Database Anywhere application on iPad, �Preferences of Home Screen� options has set to Both or Profiles.


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

Please send us UDID of your iPad/iPod 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 �UDID�. Now on device when you create new record this field will be populated by device�s UDID.


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

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�.


How to use 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 �Syncing Mode� option and Set Auto Mode . Now set interval of syncing in minutes.


Whenever I add/edit/delete record on iPad, 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.From the more option ,select Record status that shows information related with record syncing process.


I am not satisfied with current font and font size, is there any option to change it?

Cyan color indicates that record synchronization is still in progress. Red coloYes, User can change font and font size from Preferences of Cellica Database Anywhere software. In Preferences, Select �View Settings� option.


Can I hide Profiles List on home screen.

User can hide Profile List from home screen. You can select following options.




From Preferences of Cellica Database Anywhere on iPad, you can customize home screen. On home screen, on upper right side icon is there, use it to open Preferences of software. Following screen shows Preferences for customizing the Home Screen. Here select �Forms� option, which will show only form list on home screen. You can select Forms or Profiles or Both if you want.