For whom and for what use?

Field Service Management (FSM)

You are a service company with teams in the field and Are you looking for a method of managing your interventions (e.g. construction, after -sales service, installation, maintenance)?

Crystaldata is a NO-Code information manager that allows you to create Collections of business objects (eg customers, interventions, technician, costs, projects, etc.), To link them (customers <=> interventions <=> Technicians <=> Frais) And to share them online with your employees, in complete safety.

Project Management

Are you responsible for a team and the smooth running of a project program?

Crystaldata allows you to quickly create, and without making a line of code, a tool for monitoring the state of each project, to be notified when a significant change of state is recorded, and to see your dates of deadlines in a 'calendar' view or in your personal agenda (Google Calendar/Outlook/etc.).

DATA Management

Are you looking for a simple tool to manage your files, documents, report, and your information collected in the field?

CrystalDATA v1.0 has been designed to be usable on a smartphone in order to collect data as close as possible to their origin and whatever their nature (text, number, photo, PDF, etc.). Context data, such as the weather statement, the GPS position, can be acquired automatically. A graphic generation tool allows you to view information in the form of a curve or histogram.

Main features

• new_releases Create objects made up of various attributes, such as: text, number, euros, date, yes/no, choice list, file, image, PDF, GPS position, link to an object in another collection, QR code, weather...
• new_releases Add, edit your objects in a form
• new_releases Search, filter and sort your items
• new_releases Share your objects of objects with other users
• new_releases Export your collections in CSV, XSL and PDF
• new_releases Be notified after each adding an object in one of your collections, or when an attribute changes state
• new_releases Activity: Each modification of an object is recorded in a history (when, which, what, value before, value after)
• new_releases Access all your mobility collections (screens automatically adapt to smartphones/tablets)
• new_releases Assistant (IA). Ask the assistant, based on data from your object collections

The Crystaldata object and its attributes

An object consists of attributes (ex: name, brand, color, age, price, Qty in stock, etc.) and Each attribute has a specific type in order to best adapt to the data it will contain (text, number, date, list, yes/no, file, etc.)

The types of attributes available are:

• Text :
  • Simple text: can contain a chain of 255 characters maximum.The 'filter option?'Allows you to create a drop -down list containing the distinct values.
  • Long Text: allows you to write long texts
  • Rich Text: allows you to write and format a long text (fat, underlined, title, color, size, links, lists, etc.), using a small integrated text editor (Trix Editor)
• Numbers :
  • Number: to enter digital values, with or without decimal.The 'Operation' option at the bottom of the page 'will calculate the average or the sum of the attribute values.
  • Euros: ditto 'number' but displays the value with the Euros symbol (€).
  • Expression: field calculated from existing fields or a formula in Ruby language.(Ex: [time spent] * [Time cost] or [price excl.]* 1.2
• Date: a date chosen in a calendar.
• Yes/No: allows you to choose between yes or no or none of the two.
• List: to contain a list of values, like 'Blue, White, Red' or 'to do, done, canceled'.The values ​​must be separated by a comma.
• List of objects (Collection): to choose an object from the objects of another of your collections. (Ex: [Technician. "Last name, first name, experience"] )
• File:
  • File: Allows you to link and store a file in an object (document, image, etc ...).
  • Image: ditto 'file' but displays an original image or image preview according to the context.
  • PDF: ditto 'file' but displays an overview of the first page of the PDF document.
• User: allows you to choose a user from those who have access to the table
• URL: allows you to add a link to an internet resource via an URL (internal or external).
• Email: to add a link to an email address.
• YouTube Video: allows you to add a link to a YouTube video and display the preview of the video in a miniature.
• Color: a color chosen in a palette.
• Location (GPS) :
  • Capture the location of the user, if it requests it, by pressing the button
  • Displays the rental on a card, based on the contact details indicated in "LNG, LAT" format.(Ex: 48.85879287621989, 2,294761243572842 to point on the Eiffel Tower).
  • Distance: allows you to calculate the distance (on bird's flight) between two GPS positions.(Ex: [Site (GPS)] - [House (GPS)] or [Site (GPS)] - 48.85879287621989, 2.294761243572842 )
• QR Code: to generate a QR code from the content of another attribute of the object.(Ex: [n ° desérie], [Reference], [URL website] )
• QR Scan: allows you to scan a QR code with the camera of your smartphone, tablet or computer.
• Signature: allows you to sign manually with the mouse or on a touch screen.
• UUID: automatically generates a unique identifier.(Udid = universally unique identify)
• Tags: allows you to enter keywords separated by commas.(Ex: Paris, France, Europe )
• Stars: allows you to note an object with stars.(Ex: )
• Weather: allows you to display the current weather for your location.(Ex: 22 ° C, light rain, 73% humidity )
• Status: to add a statement to an object, associated with a color.(Ex: new:blue, confirmed:green, canceled:red, archived:gray )
  • Available colors: Blue Gray Green Red Yellow LightBlue White Black

Relations between objects

The relationships between objects are created with the 'collection' attribute. Example: an intervention object will have an 'technician' attribute which will allow you to choose a technician in the collection of the same name. These relationships are also visible in view of the details of an object. Thus, when a technician object is linked to interventions, The detail view of each technician automatically displays their interventions and allows you to enter a new one for this technician.

Filters/Reports

Filters/Reports make it possible to memorize selection criteria in order to obtain a filtered collection of objects, meeting its criteria.

These filters/reports accept different criteria depending on the type of attribute:

• A text type attribute is filtered with % TXT % (filter everything that contains the 3 letters TXT)
• A digital attribute is filtered with a sign and a value (Qty in stock:> 5)

Notifications

The notifications make it possible to be alerted by email after each addition and modification of objects in a collection. They are configurable for each collection and each attribute.

Example: to be alerted when an object in the 'Interventions' collection has an attribute 'status' equal to 'finished'.

Users, sharing and roles

You can share your collections with other users by giving them a role (reader, collector, publisher).

• Reader can only see objects from the shared collection.
• collector can add objects in the shared collection, and will only see his objects.
• editor can see and modify all objects.

Assistant (IA)

Ask the assistant, based on data from your object collections
Examples of questions, in natural language, which can be asked to the assistant:

• What is the name of the customer who returns most often in this list: [Customer]?
• Genate me the next 3 interventions to be expected, based on this list: [Date, customer, type]?
• You are a statistician.Calculate me the average of the durations of this list: [Duration]?(This is to be done only if you doubt the seriousness of this assistant;-)