-
Trouble with Regex pattern
I'm trying to use the following regex pattern to validate phone numbers: /+?\d{1,4}?[-.\s]?(?\d{1,3}?)?[-.\s]?\d{1,4}[-.\s]?\d{1,4}[-.\s]?\d{1,9}/g I works fine on https://regex101.com/ However, the regex_matches filter returns always false. The same problem here. No matter what the input is, returns "the phone number is…
-
How to format email body text
I have a Task that sends an email to a list of users via sendgrid_basic_send. The sending works fine. My question is about the email body. I created a text variable and entered the body text into the value field. This is basically a string of text. Is there a way to format the text, e.g. new lines? I need 2 or 3 lines of…
-
Subtracting one value from another and returning result
Hi, I created this in an addon… [{vote_type: upvote,suggestion_vote_vote_type: 1},{vote_type: downvote,suggestion_vote_vote_type: 2}] Is there a way to add a value that subtracts downvote from upvote which would return something like [{vote_type: total,suggestion_vote_vote_type: -1}] Thank you, Dave
-
Empty geo_point entries issue
Hello, I have a column of geo_point , and when adding new entries some were added not as null, but simply empty (eye icon unticked in the editor) Now I'm having this issue that there is no way to query for these records. When I query that row, the geo_point column is not shown in the response. Then I'm trying to query all…
-
External API requests depending on the number of records returned in previous response
Hello, I am struggling with adjusting my function stack to do external API requests depending on the number of records returned. I have built an app that fetches bank account details. It is working fine with a single account where first API gets the account number (if 1 account is returned it is fine): and second API does…
-
Cohort analysis for financial modeling
Hi guys, Can I build cohort analysis for financial modeling on Xano? Thank!
-
How to stop database from updating to blank values
Hello, I'm facing difficulties when it comes to updating values in my database. To make it more convenient for you to understand the issue, I've created a video walkthrough. Kindly view it at the following link: . Regards.
-
Quick "Remove" Array Question
Hi guys - Seems elementary for me but there is something wrong in my "remove" from array setup I have here. I simply want to remove items from the results array in which the 'created_at" (as a timestamp), is before or less than the most recent log timestamp (Above). It seems to be not working (not finding any true…
-
Select Distinct - how?
Hello Can someone point me to the feature that will enable me to select the distinct values of a query filter, such as: [ {"recipientID":538}, {"recipientID":538}, {"recipientID":411}, {"recipientID":533}, {"recipientID":538} ] Distinct would return: [ {"recipientID":538}, {"recipientID":411}, {"recipientID":533} ] I've…
-
How do changes to a table get reflected in the APIs that have been already auto generated?
I want to understand the impact of table name changes, column additions/removal/name change etc…, foreign key relationships, etc… and how APIs can be broken and then fixed. Is there solid documentation on this? What refactoring is automated for you?
-
need a specific format response
I have a specific response format which like this test:5.0:customer:{ "value1":1236, "value2":"hello" } the key name is like this test:5.0:customer which static but when i try to create this response using set filter expected result not come the result which come like this test:5: { 0:customer: { "value1":1236,…
-
best way to sort an array of objects with two conditions
I have an array of objects and i need to sort it with two fields object.generated.apr ascending and object.generated.rewards descending both are number decimal this is what i did the point is that the sorting must be done at the same time and not first with one and then with the other, which would remove the first
-
Generate chart data
Hello, I'm looking for assistance in refining my formula so that I can generate the necessary data for creating a chart. Target state: The graph should ultimately roughly look like below: Data required: I need 3 types of data points. I created a function on Xano solving 1 and 2 but I’m still stuck with 3 1) The number of…
-
Trying to concatenate within a table
In my "user" table I just want to combine the "First_Name" and "Last_Name" into one name, with a space between them. The output should be recorded in the "Full_Name" column in the related row. I cant seem to make it work.
-
Reference no longer exists.
Hi all, Why table id seems to "Reference no longer exists"? I don't aware of what I did :( What do you suggest to me? [image.png]
-
How do i compare data between two arrays saved in separate variables and extract the unique data
So basically I'm running two different api calls one to google calendar and another to Microsoft events and saving each of the these events results in their own variables, so i want to compare the results saved in those variables between each other and save the unique ones in a variable. This is my current set up the data…
-
How does XML decode work?
I've been inputting a few different test RSS feed urls, but continue to get an XML Parsing error. Any ideas on what I'm doing wrong? Here are the urls:
-
Responce in Object
I'm getting this output: {"availabilities": …} {"availabilities":[{"id":1,"productId":"prod123","dateTime":"2023-09-03T10:00:00+02:00","vacancies":10},{"id":2,"productId":"prod123","dateTime":"2023-09-03T15:00:00+02:00","vacancies":8}]} but I'm looking to get the following output: {"data": {"availabilities": …}} {"data":…
-
'Add to End of Array' is adding an Array to the end of an Existing Array
Hello, I have an existing array, which is labeled "ShowHostArray" below. When I add an integer to that array, it adds another array, which ultimately breaks my schema. Any thoughts on how to fix this?
-
Logarithm calculation
Hello, How may I do a logarithm math calculation on Xano. For example: Ln(variable1) / Ln(variable2). I understand there is Lambda but I need to upgrade for that which I can't do now. I also found this : but I need to call an external API. Before trying this, I would like to know whether Xano allows me to do such math…
-
How would I build a 24 hour timer?
What I am Wanting to Accomplish You know how a lot of apps reward you for logging in and collecting some type of bonus that becomes available every 24 hours? I'm trying to figure out how to build that in Xano/WeWeb. I'm wanting to gamify my site a little bit that will reward users w/ points for certain actions that then…
-
How to import a tab-separated text file into Xano?
Hi Xano Experts! I am receiving some tab-separated text files from Amazon through a URL and I was wondering how I can import and parse the data into Xano? Would appreciate some guidance or resources :) Jordan
-
Getting the error; Please use a numerically indexed array.
I've created a 'for each' loop to change the format of my timestamp. However, when I run it, I receive the error message 'Please use a numerically indexed array.' Does anyone know what I'm doing wrong?
-
How to return only the keys of entries with a true value in addon?
I have a table for my members called "nodes". It has an addon of "skills". The skills table is full of skills that are all bools. The two tables are linked by a shared id. On my frontend I want to filter by a skill. So if I pick "Animation" from my UI filter select, it should search Xano and return the users who have…
-
When could I install external node library ?
@Michael Udinski Hi, we read this after trying to install . Please let us know if this could be available soon, its urgent for us for not using another external api and lose time. thank you, Thierry
-
will change in table name impact api based on the table
Will api logic be impacted if I rename the name of the table being used
-
How to use multiple filters on aggregated results?
Hello, I have a database table of airline tickets. On my front end the user can filter the airline tickets by: airline destination country destination city client name traveler name cabin The user can filter by one of these elements (e.g. airline), or by multiple elements (e.g. airline + destination city + cabin). So in my…
-
Filter an addon
I'd like to filter a result with lambda from an Addon. ex: the user has many cars. when I call this user, I have an addon that brigs all his cars. Can I filter this Addon to bring me only the red cars for exemple? I know that's easier to call all red cars with the user ID = x. But I have a situation where I have some…
-
How to transform a date into a ISO8601
Hi there, I need to transform a date to ISO8601 format but if I use "c" in transform timestamp the resulting format is this: 2023-09-04T00:00:00+00:00 and I need this one: 2023-09-04-04T00:00:00Z How can I do it? Thanks!
-
Struggling with Fuzzy Search
I don't know what I'm doing wrong (or more likely, what I'm missing) when it comes to fuzzy search. I've got a database full of monitors that users can search. The first issue I was having made me discover that partial match wasn't a default thing. To fix that, my function stack takes the user's query, breaks it into an…