Hello, Xano Community! Welcome back to our Customer Corner video series. Today, I'll show you how to create a table reference based on a field that is not an ID. This technique is particularly useful when you have a large number of records, and users need to reference a specific record without knowing its exact ID.
Consider a product table where each record is linked to a category through a table reference. Normally, you’d reference this through an integer ID. However, in a real-world application, especially with a vast category table, users on the front end might not know the integer corresponding to each category.
We aim to simplify this by allowing users to reference categories using a more intuitive field – in our example, the category name, which is text instead of an integer.
Upon running the modified functions with a text input for the category (e.g., 'Men's Clothing'), a new product is successfully added to the product table, correctly associated with the intended category through its textual name rather than an integer ID.
This approach significantly enhances usability, especially for end-users interacting with the front-end of your application, as they can now refer to categories (or other table references) by name instead of obscure IDs.
I hope this tutorial helps streamline how you handle table references in Xano, making your applications more intuitive and user-friendly. If you have any questions or need further clarification, please leave a comment below.
Stay tuned for more tips and tricks from our Customer Corner series. Bye for now!
This transcript was AI generated to allow users to quickly answer technical questions about Xano.
I found it helpful
I need more support