-
Help Required for Billing / Instance Change
Hi, I started with a new instance in Xano. I created tables. I connected it with Webflow. I liked the product. I bought the subscription plan. I realised I want to change the instance to a server in India. I am not able to change now. Help required.
-
Check file resource validity
Hello everyone, hope you're well. I want to perform an action when a user uploads an invalid image from the frontend, such as wrong extension, file size = 0 and so on. The Create Image from File resource automatically displays these errors on fail, but I need to trigger them at my level. Any idea how I can do this? Thank…
-
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…
-
Automating workflow on record creation or update
Hi, I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field. For example: let's say I…
-
If loop B is inside of loop A, a "Break out of a loop" function in loop B will break out of loop A?
Hi, If loop B is inside of loop A, a "Break out of a loop" function in loop B will break out of loop A as well or only break out of loop B? Thanks!
-
What is the ideal table structure, where courses have slide-based lessons with unique content types?
Hello everyone 👋, I'm new to Xano and working on a project which is about learning management system. I'm using Webflow + Wized + Xano. So here I have 2 tables "Courses" and "Lessons". Courses table will have list of course name and some more information about that course. Lessons table will have content for each course.…
-
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.
-
List array input not being applied properly to object output
Hi all, I am trying to pass an array of numbers from my front end and apply it to an object in my database where the number matches the ID. I have a current input of 1,3. And my output is showing that there are 2 items but it's not applying the values to each key.
-
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?
-
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,…
-
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?
-
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…
-
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…
-
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!