Add Record - Xano Documentation

In this section, you will specify the data to be added to the record.Click

to quickly enable or disable all fields.Hover over each field name and click

to disable that field — this means that no data will be written, or the default value in the database will be used instead, if set.

Hiding a field prevents its value from being written. Statements created before the Enforce Hidden Fields release keep the older behavior — where a hidden field could be overwritten by an input or variable of the same name — until you enable it. See Understanding enforce_hidden_fields for details.

If you have an object that already contains all of the data to use in the add record step, click

to auto-fill from that variable.

You are able to manually specify a record ID, but proceed with caution. If you have workflows that rely on sequential IDs, or multiple requests try and add records with the same ID simultaneously, you might run into problems. By default, Xano will auto-increment the ID for you, which is usually best practice.

Customizing the return

Click

to edit the fields returned in the query.

Note that customizing to reduce the fields returned will not have an impact on query speed, but may help with other performance issues in your function stacks. It is always good practice to only return the fields necessary.

Return As

Change the variable name that this function will output to.

If you’re using conditional steps, you can use the same variable name in multiple steps to make satisfying the conditional or outputting data in the response easier.For example, if we are sending a specific response based on if a variable is true or false, we can set both of those outputs to the same variable, making building our response easier.

Give this function a description for easy understanding of what this function achieves.This description will appear in the function stack, giving you easier readability for complex logic.

​Customizing the return

​Return As

Customizing the return

Return As