-
Returning an addon, for an addon
Is this possible, or what's an appropriate workaround here?
-
Upload CSV for Column Referencing Another Table (list)
In one of my tables I have a column that is a list. It references another table. How do I upload a csv and get it to correctly populate that coulmn. Currently if the csv file has a given list like [1,2,3] for a particulat cell, I would expect those 3 ids from the refernced table to populate that cell. However, it just…
-
"having" statement in aggregate functions
I'm doing a group by to aggregate a table and get a count of record. I'd like to only get the rows where the count = 1. In SQL, this would be something like: select name, count(1) from table group by name having count(1) = 1. Is this possible using the query all record function? I don't see it in the output tab.
-
Got OpenAI Completions API to return JSON, how can I transform it to be read as a list
I created some prompts in OpenAI's APIs that respond back with validated JSON. However, since it is in the response as a text string, I cannot figure out how to get Xano to recognize it as JSON (and then enable me to work with it as such). Example Output at response.result.choices.text: [ { "keyword": "cute", "sentiment":…
-
Maximum allowable size of the geopoint data type?
I did not see anywhere in the documentation the maximum allowable size of a geopoint data type? It seems that it must be limited as I have imported a multipolygon dataset successfully but only after I smoothed the original features as a few features in particular would not save to the database and returned a cryptic error…
-
best way to track user activity in the db?
For this particular project, I'm using Landbot, a fantastic, highly-recommended chatbot, and Xano as the backend. There's an 8-min intro video, and when they come back for day 2, I don't want them to have to watch that again. The easiest solution that's obvious to me is to create an object field called "activity" where I…
-
Delete "Empty" Fields with no Data Reference
Hey everyone, maybe someone can help me: I have a data base table two linked / referenced data fields on a second table. In this case the table should match "friends". As soon as one of the friends is deleting his account there is the correct "Refernce no longer exists"-Statement. [image.png] Using Tasks I want to get…
-
Format Date Field in Output
I have what I feel is a simple problem, yet, I can't find an easy solution. I have a table with a Date field that by default is returned as "2023-04-06" from the API to Wized/Webflow. My requirement is to display the data as "April 04, 2023". Is there a way to make Xano make this transformation before returning the final…
-
Bubble X Xano
Hello, I have been using bubble for 5 years now and I think Xano could help me to solve a performance problem on bubble. I explain you my problem. I have a database of 1000 events. I need to copy quickly a part of these 1000 events (about 200 or 300). For each copied event I need to use the google matrix api to add and…
-
Is there a way to generate a thumbnail from an image stored ?
Hi everyone, I'm currently saving my files in the database (mostly images and pdf files), but in FE there is a request to see thumbnails of images or PDF files. Is there a way to do this on Xano? Any suggestions, or help helps me a lot, thanks everyone
-
How to get number of Months since unix epoch
Hey guys, Is there a filter option to get the number of months from the unix epoch? I'm doing a query all records and looking to see if the user already has a record in the table for the current month, so looking to get the number of months since the unix epoch to compare. How would I go about this? Thanks
-
Is there a way to convert an object to a string?
Is there a way to convert an object to a string outside of using a lambda? Basically, I'd like to have something like the stringify function, so that I can easily put error objects into email alerts. Anyway to do this outside a lambda or clumsy recursive for loops?
-
How to increment value?
Example: Every single project should have multiple testers. In our application we want to have 50 testers for the specific project. My problem is what conditions or logic should i used to increment every testers who registered to that specific project?
-
Arrays Overlapping outside of Query
Hi! I saw that Xano has the Query Operator OVERLAPS. However, in the normal "if"-statement (not in a db-related query, but simply an "if" condition), this OVERLAPS doesn't exist. How can one compare two arrays to each other and find out whether or not there is any matching value between the entries of both arrays? As in:…
-
Custom Domain - Insecure Connection Error - Please help!
When I connected my custom domain, using api.mydomain.com.. it worked, kind of. It says that it's connected and is showing my custom domain on my Xano instance, but when I try to click on the instance to open it, i get this error (image attached). Does anyone know how to resolve this? I clicked "Proceed to…
-
Generate CSV with single column
Hello, trying to generate a CSV file with 1 column and for some reason all rows are treated as columns instead, not sure if that is a bug or not, maybe someone would have a better idea : )
-
How to concatenate multiple variables, not just two
Hi, so my external API function has an input of up to 4 variables that I need to combine into a single param for my API call. I've been looking around, found "concat" but it seems designed to concatenate only two values. Here's the specific issue, see the following API call:…
-
Extending CSV export to an addon (Split data to columns)
Hi @Michael Udinski :), I went through your video ( and achieved everything, the only issue I have now is when adding data from an addon, the columns come all together as one, how can we also split the addon data as separated columns? Thank you very much.
-
Creating key/value pairs from two different arrays
I am looking to combine two different arrays that do not contain key/value pairs, into one single object that contains key/value pairs. I would like the values in the first array to become the keys, and the values from the second array to become the key's from the first array's values. The order of each item in each array…
-
Error when multiplying a decimal
I get a strange error "Exception: Numbers are required for mathmatical operations." The number I'm trying to multiply is a decimal - e.g. 0.0002312203989 Any thoughts on what the problem might be?
-
JSON to Individual text fields possible?
Hi, I am wondering if this is possible to achieve? From my head maybe with a function? I have a JSON field that when I receive the data, I would like to separate into different text fields. Example: JSON input…
-
Does Xano have a function similar to SQL SELECT TOP(10) or Linq .Take(10)
While I am developing, I want to run my function stack against a limited number or records, rather than all of them. Does Xano have a function similar to SQL SELECT TOP(10) or Linq .Take(10) ? Thanks.
-
Calculating distance between two points - error message
I would like to calculate the distance between a start point and all the records in the table. The requirement is to find all Users within 50 miles of the input location ( = ‘place’). Question 1: Is there a way to do this in a Custom Query? I've tried but there doesn't appear to be a way. Question 2: Is there a way to get…
-
How to replace line breaks
How would you go about replacing line breaks in a text? For example, from “\n” to “<br>”. I tried the string_replace and the regex_replace (see screenshots) with no success. The response is “” (empty) every time.
-
Get first 20 records
Hi, I'm looking to achieve the following scenario. I currently have a database call that gets all records, and includes pagination (this shows 28 records per page) If the user is not on a premium plan, however, I only want them to be able to see 20 items maximum. How can I limit the amount of items that I retrieve from the…
-
Convert JPG Images to Webp
Hey guys, I created a table in my Database to serve my bubble application as an image bank. However the images arrive in JPG or PNG. How to transform these images from JPG to Webp in my table? I thought of creating a function for this. Has anyone ever done something like this? Thanks
-
Pinterest load more?
Hi there, I'm trying to create a similar website to pinterest. Rather than having fixed pagination, is it possible to have a “load more” (that just returns 25 EXTRA items, rather than loading a new list of the 25 NEXT items)? Many thanks
-
input an array as filter to select rows in a table - field is a table reference
I'm trying to passa an array as input to retrieve rows that contains my array. 1 - Scenario DB.table.items_ref overlaps input(object[items]) »»»> Not working 2 - Scenario DB.table.items_as_int_array overlaps input(integer[items]}) »»»> Working The problem with secenario 2, is that I lost the benefit of the table reference.…
-
Transforming a list into a list of objects
Hi Xano community, Im trying to trasnform 2 lists into a list of objects where each item in the list becomes a new object I added the above and get the results as So instead of teh above I want to get { Placement: 1 Budget: 10000 Placement: 2 Budget: 10000 Placement: 3 Budget: 10000 } Any guidace is much appreacite it !
-
Creating a dynamic array to populate multi select field
I have a search form that has a multi-select field for location, in this case US states. Users can select one or more. What I was considering was querying my listing table to create an array list of the states currently represented by active listings. Example is I have 10 listings in California, 5 in Florida, 2 in Texas.…