-
Ask Anything! No question is too basic.
We want you to succeed using Xano or any other No Code tool to launch your big idea to the world. Visit the "🤷 Help! I'm a Noob" to learn the basics and grow with the community.
-
Diff array filter removing part of an item
Hello! I'm using diff filter to get the difference from two arrays. The variable "ProductsInflacao" has an item that is also in the variable "ProductsInfoNotProcessedYet". The diff is applied to a variable called "teste" and we can see in the print below that the difference is applied successfuly. This is the content of…
-
The account database page might need an upgrade. What do you think?
-
File resource duplicates object
Hey everyone, hope you're doing well. I have an issue apparently caused by a file resource. I have this input that is a list of objects The data I send from the frontend is this I then do a loop on the variations list to perform the desired action, but I'm being confronted with the loop running twice even I just sent one…
-
Simple Post request on Twitter
Hi All, I am new here. I was wondering if there are tutorials regarding an External API request that need OAuth 2.0 . I want to post a tweet from XANO but I find it confusing when it comes to authentication. I manage to make API calls only the ones that do not need authentication. Any help is welcome.
-
Help! I've hit a brick wall with a bulk update function
Hi. I am completely new to xano and I'm struggling to understand it. I was using adalo for an MVP build but hit a wall because the database functionality in adalo didn't support bulk updates. So I'm hoping I can achieve what I want to do in Xano. My app is essentially a to-do list that will break down a big goal (or…
-
How to add SVG icons to Xano?
I need help some here. Sorry if this is a basic question, but I could not find information about this anywhere. I have a categories table where I need to add SVG icons, but when I try to add them to the storage/image field, it does not allow me to select SVG files. Do I need to use a different field type for SVG?
-
Get content of a txt file
Hi all, Is there a way to get the text contents of a .txt file within Xano?
-
Creating Realtime Chat - Reasons for using external API service (e.g. Ably) vs Xano database
Hello, I'm looking to build a chat functionality in my app. I've watched the Xano videos on Ably Realtime Chats (Ably Realtime Chat Template - YouTube) and it seems to me that you can read/write chat records directly to the Xano database without really needing to go through Ably. There's a gap between getting the ably API…
-
Dates as Columns
Hi, what is the best approach in Xano for this? I have 3 tables: a channel table, an event table, and a table where events, channels and dates are combined. On my frontend (WeWeb), I want to display a grid that has: Rows: channels Columns: dates Cells: content table ID (displayed as event name lookup) What would I do to…
-
using first_notNull and passing a null value overwrites record
Hey there! I'm trying to patch a record using the get edit method, but I'm having trouble with the first not null function. I want to be able to update a record with a new value, empty it out, and add it back in, but I don't want to pass a value and have it update the field. I've tried passing the value and not passing it,…
-
🚨 How to make Stripe billing and auto tax work on Xano api stripe checkout session. Not working!
I'm trying to following the stripe docs for adding billing_address_collection & automatic_tax but for some reason it always returns these as false and null and not sure what I'm doing wrong! I've copied this: into Xano like this: But doesn't return this in the response:
-
Sendgrid with existing user table?
I have an existing user table. I want to setup password reseting. It seems like sendgrid would be the best option for this. How do I set this up with my existing user table?
-
Is there a way to return a response without aborting the workflow?
Hi, I am connecting Bubble with Xano and using Xano for long workflows (some take hours to complete). The problem is that Bubble expects a response within a few minutes of making the call to Xano or it will timeout. So I was thinking I could send a "workflow initiated" response to Bubble as soon as the call to Xano is made…
-
How to Sort by Addon?
Is there a way to sort an output's list by addon? I'm trying to return a list of users and sort by followed users first. I tried using an eval or aggregate instead of a list but couldn't figure it out. [CleanShot 2021-11-22 at 08.57.47@2x.jpg] [CleanShot 2021-11-22 at 08.57.56@2x.jpg]
-
How do you apply a unique filter to one column before querying the whole table?
I am looking to query the results of an entire table once one column is filtered out vertically for all unique values. In this case, each message has several rows (for different users). I want to filter for distinct messages and then select other columns such as created_at. I am able to grab all distinct messages in a…
-
How do I allow customers to cancel their Stripe subscription?
Hello, I am planning to charge a recurring payment for my software. I have followed the Xano docs for the Stripe extension, and my users can successfully make subscription payments. I am also able to track sessions in my "session" table. HOWEVER, I want to allow users to cancel their subscription in Stripe from within my…
-
Will I have efficiency issues using random number generation as a serial/ad number?
I just added a function to my app where on creation of a new ad entry a serial number is created. I used a function to created a random NEW NUMBER between 1000000 and 9999999. I then queried all records of the ad table, with the output variable CURRENT NUMBER only containing the ad numbers. I then used a while loop to…
-
How to group items across different database tables?
I have 2 databases - "Videos" and "Articles". I want to create a "Collection" feature where users can group items across the 2 different tables. For example, a user can create a "Sewing" collection that can have both videos and articles. What is the best way to do this in Xano?
-
Foreign Key for Global Notes Table
I want to use a global notes table for more than one entity relation (table). So far, I have the following tables: Organizations, Contacts, Activities, Projects, and Tasks. I want to use the Global Notes table for all of the Entities. In Airtable, there is a formula [RECORD_ID()] that would allow for these relations. This…
-
Retry failed external API calls using exponential backoff
Hi, Some times external API calls return errors, when this happens and one of our functions had to use a value that was expected to be returned by the API call (which did not returned it, because it failed), we get an error like: "api_call.response was not found". I would like to implement exponential backoff retries for…
-
Adding specific data to record only once when 1st object in list is created 🧐
[ {"type": "preface", "body": "some paragraph"}, {"type": "chapter_1", "body": "some paragraph2"}, {"type": "chapter_2", "body": "some paragraph3"}, {"type": "chapter_3", "body": "some paragraph3"} ]My function stack adds one record (1 object at a time), then queries all records. But I need to add the preface content only…
-
Calculating total hours worked - Should I use Custom Functions?
Hi! I want my API to return the number of "hours worked", based on some business predicates, using the data being stored in related records. I'm sure it can be done with Xano, but I'm unsure about what component/feature to use. Should I use a Custom Function? Or should I use something different? In Airtable, I'd typically…
-
Does Fuzzy Search consider mis-spells?
If a user mis spells a word it doesn't load the result for me.
-
How do I sync Xano database to Webflow CMS?
HELP. I'd like to have Xano as the master database for my Webflow CMS — all CRUD actions will be conducted on the Xano side and pushed to the Webflow CMS. Got the Xano side of things working fine, it's the syncing bit i can't quite wrap my head around.
-
How can I get the parent element of an array?
I'm sure it's quite simple but I can't find the right way to get it. I Hope somebody can point me in the right direction I've two tables, Books and Sales. The Sales table has a field "ISBN" and I wrote a function which loops over every Sales row and searches for that ISBN-value in the Books table. When found, it returns…
-
Trying to match two values, got stuck with an error
Hi, I just startet tinkering around with Xano, coming from Airtable & Softr. I have two tables in my DB, "Books" and "Sales". Every book has a SKU value and wether an ISBN value or an audible_product_id value. In the Sales table are thousands of rows of sales of these books and they all come with an ISBN or product_id…
-
Upload image error: the parameter content is not a valid file
Hi, I'm using Xano and Bubble and trying to upload an image to a user's profile. I've followed this tutorial: https://www.youtube.com/watch?v=eYn6XbhIpuI and the endpoint works in Run & Debug mode, and successfully initialized in Bubble. However, when I upload an image on the front end I get the following error: Any…
-
Get data from CVS file to function or JSON
Heeey all, how can I get the data from a CVS file and extract it for use in a function ? How should I do it?
-
Timer external api request
Hello everyone. I have a situation where I have to send a request to an API, this API returns me a key and with this key I have to make another request to another endpoint, but, with an interval of approx 7 seconds. How can I configure that after the first request wait X sec and then make the second request?
-
What filter can I use to convert "$ 60,000 USD" into "60000"?
Hi, I'm receiving some prices through an external api and need to extract the price number. What is the best way to to convert "$ 60,000 USD" into "60000"? Thanks!