Creating and Managing Custom Fields

Creating and Managing Custom Fields

Introduction

Custom fields allow businesses to extend standard forms in iVendNext to capture unique data requirements. Whether you need to track additional customer details, add project-specific fields, or customize inventory attributes, creating custom fields ensures your system adapts to your workflow—not the other way around.


This guide provides a step-by-step approach to adding, configuring, and managing custom fields in iVendNext.



1. How to Create a Custom Field

Step 1: Access the Custom Field Menu

  • Navigate to:
    Home → Customization → Form Customization → Custom Field
    (or)
    Open any     DocType list view (e.g., Customer, Item) → Click Customize in the sidebar.



Step 2: Add a New Custom Field

  1. Click Add Row in the Custom Field table.

  2. Fill in the following details:

    • Document: Select the target DocType (e.g., "Customer").

    • Label: Name your field (e.g., "Loyalty Tier").

    • Field Type: Choose a type (e.g., Select, Link, Date).

    • Options: Required for Select fields (enter values separated by new lines).

    • Fetch From: For Link fields, specify the linked DocType (e.g., "Project").

  3. Click Update to save.


Example:


  • Field Type: Select

  • Options:


Bronze  

Silver  

Gold  



2. Key Configuration Options

2.1 Default Values

  • Set a pre-filled value (e.g., default "Country" = "USA").

  • Use {field_name} syntax to reference other fields (e.g., {customer_name}'s Order).


2.2 Dependencies (Depends On)

  • Show/hide fields conditionally (e.g., display "VIP Discount" only if "Is VIP" is checked).

  • Syntax: depends_on = "field_name"


2.3 Permissions & Visibility

  • Permission Level: Restrict editing to specific roles (e.g., "Accounts Manager").

  • Hidden: Hide fields from view (useful for backend calculations).

  • In List View: Display the field in DocType list views.



3. Advanced Customizations

3.1 Changing Field Data Types

  • Issue: Cannot change from Data to Link after creation.

  • Solution:

    1. Go to Custom Field list (via search bar).

    2. Open the field record → Modify Field Type and Options.

    3. Save and refresh.


3.2 MultiSelect Table Fields

  • Use Case: Assign tasks to multiple users.

  • Steps:

  1. Create a child DocType (enable Is Child Table).

  2. Add a Table MultiSelect field in the parent DocType.

  3. Link to the child DocType in Options.


3.3 Dynamic Document Titles

  • Combine multiple fields into a title (e.g., {customer_name} - {invoice_date}).


IdeaTip: Use Read Only or HTML field types for dynamic titles.



4. Best Practices

4.1 Naming Conventions

  • Prefix custom fields with custom_ (e.g., custom_loyalty_tier) to avoid conflicts.

  • Use Rename Fieldname in the Custom Field list to modify existing fields.


4.2 Performance Optimization

  • Avoid exceeding MySQL’s row size limit (65,535 bytes):

  • Convert Data fields to Text/Long Text where possible.

  • Reduce Length property for VARCHAR fields (default: 140).


4.3 Testing & Validation

  • Test fields in staging before deploying to production.

  • Use Mandatory and Unique flags to enforce data integrity.



Conclusion

Custom fields empower businesses to tailor iVendNext to their unique needs. By following this guide, you can:
✔ Add new fields without coding.
✔ Configure dependencies and defaults.
✔ Resolve common issues like datatype changes.



    • Related Articles

    • Creating and Managing Custom Reports

      Introduction In today’s data-driven business environment, having access to accurate and insightful reports is crucial for making informed decisions. iVendNext offers robust reporting capabilities, allowing businesses to create and manage custom ...

    • Creating and Managing Roles

      Introduction Roles in iVendNext define what users can access and modify within the system. Whether you're setting up a new team or refining permissions for existing users, understanding how to create and manage roles is essential for maintaining ...

    • Creating and Managing Serial Numbers

      Introduction Serial numbers are essential for tracking individual units of high-value items, such as electronics, machinery, or equipment. In iVendNext, Serial Number Management allows businesses to assign unique identifiers to each unit, enabling ...

    • Creating and Managing Sales Orders

      Overview Sales orders are the backbone of any business that deals with selling products or services. In iVendNext, creating and managing sales orders is a streamlined process that ensures accuracy, efficiency, and customer satisfaction. This guide ...

    • Creating and Managing Sales Invoices

      Introduction In the world of business, efficient invoicing is crucial for maintaining cash flow and ensuring timely payments. iVendNext, a comprehensive ERP solution, offers robust tools for creating and managing sales invoices. This article will ...