-
(Untitled)
Hi, I am now using Adalo as a front-end solution. (Has used Bravo earlier). I am working on an app that is going to help people with building better mental health. It’s based on something called ABC - Act Belong Commit. The Act-Belong-Commit guidelines for positive mental health provide a simple approach you can adopt to…
-
RANK() function
Hi everyone! While I really love Xano so far, I'm stuck on something that's an absolute roadblock for the business case I'm trying to implement on Xano. In MySQL, it's possible to use the RANK() function, which let's me calculate the rank of a row based on the value of one column (score_total in example below), and then…
-
Inputs - API or Functions - Default Values
I would like to understand the use of "default values" ... for e.g. I have a function with a Input testValue, I set DEFALT VALUE e.g. "123" when a call the function returns empty value .... so what is the use of this "DEFALT VALUE"? (In my case if this works as I thought, returning "123", would awesome and reduce a lot of…
-
adding date to +N days.
hello, i just cannot understand concept of calculation in Xano. please help me out to use Xano. 1. just like Airtable, can i add days from a day with function? 2. just like Airtable, can make a timestamp record with date record + time record( the value is like ' 00:00 ' )
-
confused making function.. please help me
hello i just tried another day to make function like automation in Airtable. but, it's not easy and i'm about to give up.. for the last time, i would like to ask help. 1.situation i'm building private car care reminder service. • Table A : carwiki, each car has its own care interval information.• car_id : 1 / washing…
-
"Get de last item of object field list to user record"
Sorry if the post title is a little bit odd 🙈 I will show step by step what I am doing and what I want to achieve. I am in right way of there is something simpler or faster ? [mock001.jpeg][mock002.jpeg] I need to incorporate this in all user table queries (GET) to have only the user update status id ( lastest ) as a…
-
Create New Array From Existing Array
Hi there, I'm looking for some help with the following scenario: 1. I have a variable called "All Inquiries" that is the result of a database search. 2. Now I'm trying to create new variable ("Accepted Inquiries") by searching through "All Inquiries" for records where "status" = "Accepted" 3. I'd like to be able create…
-
Manipulating Arrays
I have 2 arrays: arrayA = [ 1, 2, 3, 4, 5] arrayB = [1, 2, 3, 4] I need to create a new array only with the value that does not have in the 2 arrays, in this case arrayC = [5], as in the example above. How can I do this? Is there any way I can subtract one array by the other so that only the values are different from the 2…
-
Integer into friendly number
What would be the recommended way to transform an integer into a friendly number? 123456 → 123,456Would I have to create a custom function for it? If so, how would you recommend structuring it?
-
Convert x-www-form-urlencoded to json
How do I transform a webhook received in xano from x-www-form-urlencoded format to a json?
-
Non empty values from Query all Records?
I have a Query all Records function on a `users` table. In that `users` table, there is an optional `token` column of type `text`. I would like to return all the users who *have* a token. In other words, ignore users where `token` is null or empty. It seems pretty straightforward but, for some reason, I haven't been able…
-
Grouping and counting in Xano
We have a requirement to produce a report which shows a list of Users grouped by City. The report displays a count of Users per City and is sorted in descending order of count. This data is available from an API. Report example: City | Number of Users Bristol 43 Liverpool 39 Chester 25 etc We can product a report like this…
-
Can Xano handle NDJSON format?
Hi Xano community 🤩 , I am using Prowebscraper to scrape product and price data from two brazillian online grocery store and recently, when I added more scrapers in order to get more data points, I got some issues while I was trying to read this read with Xano. I got an error message at Xano saying that the response I got…
-
Can you automatically creating records?
Hi all This is my first post! Please be kind :-) I'm exploring Xano for our hand made beanie production back end using Adalo as our front end. One of the things we'll need is the ability to automatically create production item jobs for a particular beanie. For example, the production manager will look at a particular sku…
-
Bug while using the decimal character (".") in string split and concatenate operations
I just observed that string manipulations that involve splitting or concatenation, and uses "." as the separator are consistently failing. Using "." as separator to split "file.name" gave me ['f', 'i', 'l', 'e', '.', 'n', 'a', 'm', 'e'] instead of what I was expecting - ['file', 'name']. Similarly using "." as the…
-
Check for upcoming dates < 7 days from today
Can you assist me in transforming date/time fields. Creating an API that looks at Activities with a start dates (7/21/2021) that are less than 7 days from today (7/14/2021) and start date greater than today. [checkdate7days1.png][checkdate7days2.png] Tried but could not figure out. Thanks again!!!
-
How to use the 'input' object as a whole
Hi, I am using Xano as a means of logging network activity when calling external APIs from my app, I would like to extensively log requests coming in and out for trail reasons. So, it sits almost like a piece of middleware in addition to functioning as a database. Is there any way to have access to the 'input' object (as…
-
In xano, is it possible to know the number of times an audio file has been played?
Hello, I am looking for a new data management solution for an application that I am developing. Its function is, in particular, to read audio files. In xano, is it possible to know the number of times an audio file has been played? Retrieving this data would allow me to expand the functions of my application. Thank you.
-
Getting a Trello Card created-at timestamp
It seems like Trello has a bit of a cryptic way to store a Card timestamp. The created-at timestamp for a Trello Card is the first 8 hex characters of the Card id/guid. Those 8 hex characters need to be converted to their equivalent decimal value. The decimal value is the Epoch timestamp, which can be converted to a…