Add or Edit Record

Hey there! In this blog post, we're going to explore the "Add or Edit Record" function in Xano, which is a powerful tool for managing your database records. This function allows you to add a new record or edit an existing one in a single statement, making it super convenient for various use cases. Let's dive in!

What is the "Add or Edit Record" Function?

The "Add or Edit Record" function is a database request available in Xano's visual interface. It performs a conditional logic operation to check if a record exists in your database table. If the record is found, it will update that record with the supplied information. If the record doesn't exist, it will create a brand new record instead.

Step-by-Step Guide

Here's a step-by-step guide to using the "Add or Edit Record" function:

1. Navigate to the Function Stack

• Head over to the "Function Stack" section in Xano's interface.
• Under the "Database Requests" category, locate the "Add or Edit Record" function.

1. Select the Database Table

• Choose the table you want to add or edit records for from the "Product" dropdown. In this example, we'll use the "Products" table.

1. Set the Find Record Criteria

• The "Field Name" input lets you specify the field used to identify the record. By default, it's set to "ID," but you can select any field from your table using the dropdown.
• In our example, we'll use the "Name" field to find the record.
• The "Field Value" input is where you provide the value to search for. This could be an input field, a variable, or any other data source.

1. Map the Record Fields

• Use the "Database Link" feature to connect your table's schema, making it easier to map the fields.
• Map the fields you want to update or add by selecting the corresponding inputs from your table's schema.
• In our example, we mapped the "Name," "Description," and "Price" fields.

1. Test the Function

• After setting up the inputs, you can test the function by providing sample values.
• If the record doesn't exist, a new record will be created with the supplied values.
• If the record already exists, it will be updated with the new values.

1. Integrate into Your Application

• Once you've tested the function, you can integrate it into your application's logic or workflows.
• This function is particularly useful when refreshing or updating data from external sources, or when working with user inputs that may require adding or editing records.

Key Benefits

• Streamlined Record Management: The "Add or Edit Record" function simplifies the process of managing your database records, eliminating the need for separate functions or conditional logic in your application.
• Single Statement Efficiency: By performing the add or edit operation in a single statement, this function optimizes your application's performance and reduces complexity.
• Flexible Usage: You can use this function in various scenarios, such as data synchronization, user input handling, or any process that requires adding or updating records based on specific conditions.

Give the "Add or Edit Record" function a try and experience the power of Xano's no-code backend development platform. Happy building!