-
wearable APK integration on Xano
Hi all, Does have anyone figure out how to integrate data coming from an wearable ring as APK into Xano? I would like to test different ways to collect data but haven't figure out how to do it.
-
Does it make sense to set up a satellite table for all non-frequently queried fields?
Hi, Coming from the Bubble world, where it is strongly recommended that one sets up a satellite data type to store all the fields of data that are not commonly queries. This is because in Bubble, you cannot choose the fields to return in a database search query — Bubble returns ALL fields during a database search. So to…
-
Is it a bad practice to have a large list of json objects in a database table column?
Hi, My app does some inventory updates where some products are retrieved as json objects from an external api. I have a database table called "inventory update" which contains a column called "products_json" which is the list of all the products involved in that specific "inventory update" (so it is a list of json…
-
How to save a changing response structure from external API in database?
Hello! I am trying to save a list of transactions from my bank account in my DB. For example: here you can see that there is one incoming (account top up) and one outgoing transaction (paying a utility bill). One of them has a creditor name (utility provider) and another one has a debtor name (my own account from which I…
-
What is an efficient way to store a bunch of booleans?
Hi everyone! I have a form on the front end that push some data and a bunch of booleans in it. The data structure looks like this: base data (user, role, date, etc.) and around 70 booleans from checkboxes. What is the best way to store data like this? I need to be able to query data and make aggregate functions by these…
-
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…
-
Move Workspace to a Customer account
Hi. As freelance, most times I have to build a functional Data Base with API endpoints to show. Then, if gained the contract, I would like to move all workspace to the customer account to finish the job and give them control. I know this is one of the Agency license functions, but I'm not an agency, just myself. Is it…
-
Creating tagging system in Flutterflow
Hello, I would like to create a tagging system in Flutterflow. For every item in the table there would be string tags to select from the list of custom tags created by the user. The user would be able to create, edit and delete the tags. It would be perfect to filter with any tag also. My idea was to do UI in a form of…
-
How do you design your Xano DB schema?
Hello! I wonder if there are any good practices about designing Database Schema with Xano. Does Xano comes built-in with any tool that would generate such schema (of the existing tables)? We're thinking of using to design our DB, and then integrate those into Xano manually, but I was wondering if there wouldn't exist…
-
Column based on concatenate values from other columns
Hi there, Im new to Xano, this may be an obvious question but I’m looking to have a column that’s is a concatenate formula from other values columns within the same record. Any guidance is highly appreciated. Sebas.