-
Why can't I see the new table reference when doing an addon
I have a problem. I have a user table that references a clients table using the clients_id. I have an auth/me endpoint that calls the user details and an addon of the client. Now I have a new countries table and I created a new field, countries_id, on the clients table that references the countries table. On the auth/me…
-
Objects vs Table Reference, which one should I use and which direction?
Hiya! Noob here. I watched some of your YT videos, which were helpful, I had my structure all setup and I understood it, It had Table References, life was great. 😎 Then Objects were thrown in and it all got confusing again 😩. In the application I have in my head I had a products table and a products_type table. I had a…
-
How to filter or query records where a table reference no longer exists
I am just trying to clean up our data as we're about to go live to 100 external beta testers. I was just wondering if there is quick way to filter or query records where a table refrence no longer exists? I have tried != = 0 = null and have not had any success in the spreadsheet view of the table
-
Creating Unique Slugs Based on User Names from Relations
Hi there, I can't help my novice skill and knowledge. I need help, please. I want to create a slug based on users' full names. I attempted to add the slug field to the 'user' table but discovered that I couldn't have more than one unique index. So, I added the slug field under my 'profile' table, which already has a…
-
table ref fields not working
When I try to reference my organization table from another table with a table ref field it does not work. The items provided are not the organizaiton.id's and there are no descriptors provided either to see what field it is actually referencing. The screenshots below show the issue and it is across my entire instance. At…
-
Reference cell is not updating
Latest Chrome on MacOS eventually it updates if I repeat the same 5-6 times internet speed 1gb up/down so I doubt this has to do with it
-
Table id reference - when is it a good idea? - Got users but should i have a teams table?
Hi, I have a users table for auth, inside I have a table ref to a "managers table" My plan was to then have a user_id ref to the user table in the managers table as a list to create teams. In my head i feel it makes it more streamlined to get data for employee tables in the front end however, i also feel that it then makes…
-
Unable to create a record with a relational object field (many to many)
Hey folks! Trying to do what I think is a super simple thing in Xano, but having some difficulty. Thanks for your help in advance. I have a table POSTS related to another table TECHNOLOGIES via the Object field. I chose object because I don't expect a post to have more than two or three technologies related to it. All I…
-
Xano sets array input with an array containing a 0 instead of leaving it empty
Our table has columns with int array table ref fields that are not required . When we create a record with these configurations from our front end ( jetadmin) and send a json object without that specific input (as it should be non-required), Xano fills these specific fields with an array containing 0 instead of leaving it…
-
Does anyone here know how to make a header and footer for a .txt file in xano?
I'm planning on creating a file resource (.txt) that has a sample format like this: HEADER 00000001 DETAILS/NAME/MMDDYYYY FOOTER 00000001 The details' data will be taken from a table while the header and footer are separately saved in a DB. Another thing, is it possible to create a file name sequence number that increments…