Talk to Us

Supported Fields and datatypes for the entity

Introduction

In Fab Builder, entity fields and data types are essential for structuring and storing application data efficiently. Selecting the right fields ensures data consistency, scalability, and optimised performance. Fab Builder offers a variety of field types to meet diverse data needs, making it easier for users to manage and organise their data effectively. Understanding and choosing the appropriate field types is key to building a robust, scalable application.

Types of Fields and Datatypes Supported in Fab Builder

Fab Builder offers a range of field types to efficiently manage different kinds of data:

  • Text: Used for storing short text strings like names or titles. Ideal for any simple, non-numeric data.
  • Integer: Stores whole numbers without decimals. Useful for quantities, counts, and other integer-based data.
  • Decimal: Stores numeric values with decimal points. Suitable for pricing, measurements, and financial data.
  • Boolean: Stores true or false values, representing binary states like "Yes/No" or "Active/Inactive."
  • Date: Stores calendar dates (year, month, day). Perfect for birthdates, deadlines, or event dates.
  • Datetime: Stores a date and a time, hence useful for logging timestamps or scheduling events.
  • Enumerator: Stores predefined set values, allowing users to choose from a fixed list (e.g., "Red", "Green", "Blue").
  • Relation (One): Defines a one-to-one relationship between two entities, useful for connecting individual records.
  • Relation (Many): Defines a one-to-many relationship, allowing one record to relate to multiple others.
  • User (One): Links a single user to another entity, enabling personalised data association.
  • User (Many): Connects multiple users to an entity, useful for team or group-based data.
  • Files: Allows for file uploads, supporting data like documents, spreadsheets, or presentations.
  • Images: Stores image files such as JPEG, PNG, or GIF, ideal for media and content management.
  • JSON: Stores structured data in JSON format, ideal for storing complex or nested data sets.

Use Cases and Best Practices

  • Choosing the Right Field Type: Select the field type based on your data. Use Text for names or titles, Integer for whole numbers, and Decimal for values with decimals. For true/false data, go with Boolean, and choose Date or Datetime for time-related data. Picking the correct type ensures efficient data handling.
  • Impact on Performance and Scalability: Correct field selection improves performance and scalability. For example, using Decimal for financial data ensures accuracy, while Integer helps speed up queries. Proper field use also reduces storage and optimises your app.
  • How Fab Builder Manages Field Types: Fab Builder makes managing field types simple, handling complex data like Relations, Files, and JSON smoothly. This allows you to focus on app development while ensuring data consistency and optimal performance.

Conclusion

In Fab Builder, choosing the right fields and data types is key for effective data management and performance. Fields like Text, Integer, Decimal, and Date help structure your data, while Relations, Files, and JSON enable handling complex data seamlessly.

Selecting appropriate field types ensures better performance and scalability. For smarter, more efficient applications, always choose the right field type for your needs.