-
How to automatically make a schedule
Hi there! I'm making a schedule of lessons. The first lesson must be started now. Each next lesson starts on a date +2 days from the previous lesson's starting date. These dates must be written to the database like a timestamp. How to make a schedule where the first lesson will start now and each next +2 days then…
-
How can I parse an array input?
Hello! Trying to parse webhooks from Sendgrid, but their API sends an array of objects, even if there’s just one (similar to below). How can I use this data if the array doesn’t have any name? I’d need to know how many objects arrived, then loop each one. If I just have “example” as an input, then it won’t detect any data…
-
Sorting array of simple objects
I'd like to sort an array of objects, by one of the object properties 'placename'. Example element of data: [ { Place: 760 placename: "Birmingham" profiles_places_id: 2 } ] I've watched two videos, but I still don't get it: Xano - Sorting Arrays of Objects Xano - Array Filters: Sort I added a sort filter in the Response as…
-
Addon help
Hey Xanoists, I'm having trouble with addons in 2 different api calls. Anyone have recommendations or a solution? Here's a quick video of API #1: https://www.loom.com/share/cdfa1ed4258c432e81e72b5dd89e9187 And video of API #2 using the aggregates: https://www.loom.com/share/4be30123a88e4b348cdfb7f18da6b751 I'm thinking I…
-
can't access $this var
I am attempting to use $this to reference a property of the current item in my forEach loop: [image.png] You can see it referenced in 7.1, however in 7.2 and 7.3 it is not available [image.png] Can anyone explain to me what it is I'm missing about how this should work?
-
IP Address of users?
Context: • I'm nearly done setting up my Bravo/Xano > Segment > Mixpanel analytics setup! • As users signup with Xano authentication we log their: Email & Name Question: Can we also pull their IP address during the Signup Endpoint? Why: It would be used in mixpanel to tell users location for analytics.
-
pull a random record?
Hi there, Is there a simple way to pull a random record from a table? I know I can do it in a few steps... counting the total records, choosing a random number equal or less than that total, and searching by ID..... but in this case, I'm pulling quite a few variables, so I'm trying to be as lean as possible..... Thanks!
-
Is it possible to build "replacement words" into Fuzzy Search?
Fuzzy Search addition has been a game changer to Xano. However, one thing I'm noticing as I test out searches is that there are certain words that mean the same thing but result in low/no matches. An ExampleLet's say the user searches "1080p monitor" but I have products that are listed as an "FHD Monitor". Us humans know…
-
Data Sizing
If I am build tables and approaching my size limit for a database does leveraging relationships instead of raw data decrease my overall database size. ie I have a flat table of cars with attributes in text. If I then converted that 1 table to many and leverages relationships would my overall size decrease or stay the same?
-
Empty string sort
I have a last name which is empty sometimes how can i sort last name i want empty last name in end but it will comes first when I am sorting please help
-
Simplify data structure in addon
hey again, I am having a customer table and a premium table. A customer can have multiple premium entries. I added a addon which queries the premium table via a few fields to load the related data for a customer (start, end date, active). Now I got the list of premium entries for a customer. But I would prefer to have a…
-
Can Xano output HTML?
I want to take a list of values from a table and display them in an HTML select. I was wondering if XANO could do some of the work, i.e. by generating the HTML. For example if my table 'Items' contained column of unique values called 'itemname', could XANO return, for each row, a string like this: itemname1 itemname2…
-
get an object property only when it's present in the object
Hi there, I'm having several troubles manipulating data with Xano 😅 Here is the (first?) trouble of the day. I get some data from an external API, wich may or may not contains a "styles" and/or "genres" property. Then, I try to create a new object with a "class" property which value should be the styles value (wich is an…
-
Data Caching - incrementation or decrementation ?
Hi Xano community, I tr to use the function of incrementing or decrementing on cached data but, it does not seem to work ... Has anyone ever had a problem with the data caching functions? I'm on "Scale X4" plan. Thanks
-
Update geo_point in task
hey, I am trying to update a geo_point field after getting the coordinates via the address in a task. Everything works fine so far but I do not see how I can create a geo_point variable to update the database entry?
-
Docs or Videos to Help with Moving Along if Variable Does Not Yet Exist in Function Stack
Checking if there's a way to see if you know that the variable does not exist because it has not come into not to existence yet and most of the ways that I know how to check for those is if there's like no value associated with a variable, however, I was looking through the #Xano documentation and there was a reference to…
-
Change the year component of an existing date in database
Hi all, I'm trying to look for the easiest way to convert the year component of an existing date in the database. Say I have a date of "Jan 1 2000" in the database and I want it to become "Jan 1 2022", what is the best date transformation to use for this? Currently my thinking is the following but I feel like there is a…
-
How to import a package in Lambda function
Hey, folks. I need to transform a crontab expression (e.g., “5 4 * * *”) into a timestamp of the next occurence. I couldn't think of a way to do so with existing Xano functions so I tried to do it with a Lambda function. My first, naive attempt was to use https://www.npmjs.com/package/cron-parser but I can't figure out how…
-
Set & Get Fun
Why does this work for Update Variable but not Add Number? [image.png]When doing an add number I get[image.png] Some Context:[image.png]Trying to loop through the totals object on calculator that has a set of entries corresponding to entries in an associated list of accounts for which I'd like to add and total (hope…
-
Time calculations
We have two time start_time and end_time both are timestamp I need to calculate time difference between start_time and end_time how can i do that please help
-
Join Array with a new line?
Hey there! I'm trying to build .ics files inside Xano from scratch and what I'm doing is depending on inputs, conditionally adding variables to an array. One might be if it's virtual, there's a location, etc. At the end though, when it's time to build the file,l I need to take all the "lines" or values of the array and…
-
INSERT INTO with SELECT
Hi Any way to pull up a chunk of rows from one table to insert into another table? Hate to loop through stuff on a 4GL platform.
-
Addon Output Appearing as Object
Hi! I am trying to use an Addon to add a new field to the Parent Object, but instead, it's showing up as a new Object in the output:[Screen Shot 2021-08-16 at 2.56.46 PM.png] My front end isn't able to step into the Object to get the listenerLiveURL variable, so I want the output to include this variable in the Top-level…
-
tables don't display data that is there
if have 65 records in a table. There are more records but dont display. If I search it comes up. [FireShot Capture 100 - Xano - api2.zwsociety.com.png][FireShot Capture 099 - Xano - api2.zwsociety.com.png]
-
Renaming a field after it is part of a function or api
Greetings, I was wondering (before i attempt this) is there an automatic cascade if I rename a field in an api or function? Meaning will I need to update everywhere I use that field….
-
Aggregating by date not available
Hi, I'm looking to aggregate results from a XANO table by a date field ('month') in this case, but it's not appearing as an option when configuring the output on the query. Table I'm looking to query- [image.png]SQL equivalent of what I'd be looking to run would be "Select month, avg(value_eur_per_litre) from fuel_prices…
-
help for complex merging of objects
I get from an api some json that I put together in a array:[screenshot-xlsr-vkx0-tgvl.f2.xano.io-2022.06.25-22_56_30.png] I need to perform calculations with a loop on the dates. I need to transform these arrays so that the keys are the dates in order to loop on them. I'm having trouble doing this and wonder if it's…
-
Help to Sort this aggregated list
My aggregated list contains a set of distinct values. I have an addon which provides related data. I would like to sort the list by one of the columns in the addon data - ClubName. In the Configure Return form, the Sort option does not provide a way to select into the addon. I am using this data as the values in a form…
-
Regular Expressions
I would like to be able to loop through an array, and if the array contains certain characters I want to replace them. The string is complex, like a JWT, but it will always be started with the same 6 characters. Is there any way in Xano to match using regex? This is pretty much the only option I can currently think of-…
-
Filters/Functions to convert an Object into an Array of Primitives? (RESOLVED: See Solution)
Hi Team, I've done it but am looking for a better way. 1. User inputs JSON 2. Create a variable which takes the JSON input and converts it into an object (array filter: first) --> variable called "object" 3. Create a variable called "keys" which applies the "keys" filter to object --> variable called "keys" 4. Create a…