-
Array Compare issue
i have two array like array[A] and array[B] i want compare both array element are same or not and which element is not present in array Example arrA=['hello','hii','ok'] arrB=['hello','hii'] if we are compare this both array than in arrB 'ok' element not inside of arrB any solution for this???
-
get records from A which are not in B
Hi guys, I have a first table "brands" which contains brands. I have a second table "affiliations" which contains brand affiliations for each user. I would like to create an API that allows me to retrieve the list of all brands (from the "brands" table) but for which the user is not yet affiliated (no entry present in the…
-
Array result
Hi there, I was import my data from Airtable to Xano. When I get the result output come like this , 1- the date come a long number why ! and 2- the list or array[ ] come with number not actual text I need the name of person not their Id number !? 3- the amount ( Estimated_value) should have $ ($18,049) how can I fix all of…
-
Addon: How to use record id in a nested addon?
Hi, I use two addons in an output if a record: 1) The first addon uses the ID of this record to retrieve matching results --> works fine 2) The second addon is nested in the output of the first addon and also uses the ID of the first (!) record. Unfortunately the id of the first record is not available for the nested addon…
-
Timestamp issue
I want format_timestamp in By Custom Query. if i am create new variable than i can use format_timestamp but in query all if i am using inside in where condition there is no format_timestamp option can you please add this option in custom query
-
Can I ditch this loop? Or better?
Just curious if any of the recent updates (or gaps in my knowledge) can simplify this... A user selects multiple tags from a list. Those tags relate to the "name" field of a tag database. And because of a limitation on my front-end, Xano gets sent an array of tag.name instead of tag.id. Ultimately, I'm trying to add that…
-
Using Strings for Timestamp Functions
Today I learned in office hours that the timestamp filters (to_timestamp, format_timestamp, add_secs_to_timestamp) can take strings as inputs. The key is that the PHP Date object needs to recognize them as strings that can represent dates. (It works pretty well for most reasonable arrangements.) We can use these to import…
-
Quantile of a list
Hi everyone, I have a list of 2500 entries and growing. Now I want to add a night-task that re-evaluates specific entries and give it some sort of a score. What I now need is to say "the lower 25% of all values are getting an €, the ne 25% - 40% will get an €€ and so on". I here need to take the quantile of that values, as…
-
Cascading Delete Issue
Is there a configuration for cascading delete? When I read the documentation and followed the instructions at this video https://www.youtube.com/watch?v=nFhcbdhaaec, the author is deleted but I get "Reference no longer exist" instead of the record being deleted in the books table. Is that the default behavior? I expect the…
-
Filter to set boolean based on the value of the input
Is there a filter that can convert a text boolean value into actual boolean? For example, We have an import job that has boolean values like T,F,Yes,No,True, and False. We would like to just have a filter that can take these values and then set the boolean field based on certain rules.
-
Pagination Issue
I created one API and apply the pagination on that api but I want to add one optional parameter id and get the record based on id Also i am adding the addon on that api and add user recode and i want to get the record based on user id How can I do that please help me
-
Transforming Text Type to Integer
Hi Everyone - I am using an external API request in a function to fetch some data. Unfortunately, the data being returned formats one of the fields within the array as text, even though the returned value is actually an integer. What's the best way to transform that field field within each item in the array to an integer?
-
Slice array with dot notation
Is it possible to slice an array using dot notation? For example, you can take the first element of an array with "array.0". But what do I need to do if I want the first 3, e.g. "array.0-2"? Thanks.
-
Concatenating Database Fields
Is there a way to concatenate two database fields? For example, when adding an "Eval" you can do "cities.name" as "name", then "concat" with the value of ", ". But I would like to add a database field called "location" to the concat function. So my result would be "Tokyo, Japan". Any ideas?[Screen Shot 2021-12-04 at…
-
How to link enum tables with lists?
Hello, i want to link enum tables with other lists, so when a person enters a value, it reflects back, basic idea no? well so far i have tried to use a for loop to edit the record within the database, i have verified that there are enough spots in the enum table but still to no avail. [image.png]this is my non working…
-
Upload image from a link
Hi , I just have a problem to create an image in Xano from external API : I make a get and i have this response : [Capture d’écran 2022-01-11 à 11.45.14.png][Capture d’écran 2022-01-11 à 11.45.48.png] I understand in tutorial , i have to make a get file resource data , and after create an image ? I try lot of…
-
find/replace for arrays?
I have an array where the order matters - and I'm trying to find the best way to replace a specific entry with something else at the same index. I figured out a way by converting to string, replacing, and then turning back to an array... but it's clunky. Wondering if there's a better way? [image.png]
-
remove item from array
Hello, I'm working with Adalo and Xano. Adalo have problem working with array and external DB. So... I'm trying to return only one value from an array to Adalo. I tried many things (filter array...) but cant figure out how to do it. This is the case: 1. I have DB "chatroom" with relationship to users. every chat room have…
-
Looking through a comma separated string "list"
More adventures in the bubble to xano migration! When you export a list of users in bubble, you get a text column/field with a comma-separated list of email addresses. [image.png] Can I, and if so how do I loop through these emails? I can query all users where Followers isn't empty, then create a loop for each user and…
-
Can I set a value based on a condition within a filter?
There are a bunch of variations for this but I am specifically looking for doing these two: Edit record from Posts: [image.png] Within here I want to basically say: If Variable X = "string1" set value to True And here: [image.png] If Variable Y = "string2" set value to Variable Y Are these possible or do I have to…
-
SendGrid Email
I am using SendGrid email extension and I send email using dynamic email function but in this function there is no subject option like in side of basic email send function. I want subject filed in dynamic email function because I am using template id.
-
How to calculate number of days
Hello, I need to calculate the number of days between 2 dates. I have tried several ways but without success, can someone tell me what is the best way to do this? Thanks, Enrique.
-
Create object from arrey
Hey! I want to do the following:I need to get an Object with a key:value pair I get a JSON response like this, and as I understand it, my array contains a variable. Correct, if not, I'm still a noob in this matter.[Снимок экрана 2021-12-24 в 1.35.42.png]I need this to be a pure variable with no square brackets. Based on…
-
join not performed in xano
In MySQL if we are using join between two table than in response we get a table which contain the data of both table but in xano this will not happen than I am using addon to do this. In my case I have two table one is product table and second is product_item table i performed join on both table and also use addon. i just…
-
Passing data between API calls
This is a follow up to this: https://community.xano.com/c/apis/how-to-hold-temporary-data-between-api-calls-endpoints For an auth process, essentially one call produces a random string, and the next call passes that string back and needs to verify it is identical to the one i sent originally. Currently i just save it to a…
-
Merge two variables / HTML and variables
Trying to post html with some data from Xano to another api. The main problem is that I have no idea how to basically do: var text = "Some text" var html = ""+text+" " Creating the variables are easy but how to make the html variable both include html and the value from the text variable. I don't get how to combine text…
-
Importing Objects using CSV
Hi, I have an existing table as follows id = 1, Name = Apple, Forecasts = [{Quarter: 1, EBITDA: 312, EPS: 250},{Quarter: 2, ...}] I am able to update the table's name field using csv but struggling to update the object array 'Forecasts'. Any tips to import this? Also tried Forecasts.0 as column name.
-
Credit Card Data
Hi there, what would be the best way to store the credit card data of the users, in the same user record or in a different table? Should I keep the data encrypted in some way? Thanks!
-
For loop issue
Hi guys, In a custom function, I have a for loop nested in a while loop. The while loop iterates a paginated request to the DB (until the page_num>last_page), and the for loop iterates the records of the current page. After the for loop, I add 1 to the page_num variable. [image.png]When I do nothing within the for loop,…
-
Multiplying aggregate sum with another variable "list*float" errors?
Hello all. I've taken a list of numbers, made their aggregate sum, and created a variable with that value. I've also found the value that I want to multiply this aggregate sum variable with. I can run everything successfully up to this point. I can have my response show my list with the aggregate sum and its table…