Ask AI
Skip to main content

Assign data to datatable column

Function: Assign data to datatable column​

This action allows you to update a specific piece of information within a datatable. You can pinpoint a particular cell (the intersection of a row and a column) and set its value. This is useful for modifying existing records or adding new data to specific fields.

Input​

  • Datatable: The specific datatable (UI element) where you want to update a cell.
  • Column: The unique identifier (code) of the column whose data you wish to modify.
  • Row: The unique identifier (code) of the row where you want to make the change.
  • Value: The new data you want to place into the selected cell.

Execution Flow​

Real-Life Examples​

Here are some practical ways you can use the "Assign data to datatable column" action:

Example 1: Updating a Product's Stock Quantity​

Imagine you have a "Products" datatable displaying all your inventory. When a sale occurs, you need to reduce the stock.

  • Inputs:
    • Datatable: Products_Table (the UI element displaying your products)
    • Column: Stock_Quantity
    • Row: PROD-001 (the unique ID for "Laptop X")
    • Value: 49 (if it was 50 and one was sold)
  • Result: The "Stock Quantity" for "Laptop X" in your "Products" datatable is updated to 49.

Example 2: Marking a Task as Completed​

You have a "Tasks" datatable for your team's projects. When a team member finishes a task, you want to update its status.

  • Inputs:
    • Datatable: Project_Tasks_List
    • Column: Status
    • Row: TASK-DEV-005 (the unique ID for "Implement User Login")
    • Value: Completed
  • Result: The "Status" of the "Implement User Login" task in the "Project Tasks List" datatable is changed to "Completed".

Example 3: Adding a Customer Service Note​

Your customer support team uses a "Customer Records" datatable. After a call, they need to log a brief note about the interaction.

  • Inputs:
    • Datatable: Customer_Records_Display
    • Column: Last_Interaction_Note
    • Row: CUST-98765 (the unique ID for "Jane Doe")
    • Value: Customer called to inquire about order #12345. Issue resolved.
  • Result: The "Last Interaction Note" for "Jane Doe" in the "Customer Records Display" datatable is updated with the new note.