function

How to create a function that validates an email input
HI, I am trying to create a global function that validates an email address input when called. I cant seem to find a simple function/way to check if an email address is valid. I am working with a conditional IF statement but hoping for some guidance on where to look? Thanking you
Cohort analysis for financial modeling
Hi guys, Can I build cohort analysis for financial modeling on Xano? Thank!
Suggestion: Request History for Library Functions
Hello, I was wondering if it would be possible to have a "Request history" for the standalone functions, similar to the ones within the actual endpoints? This would make it much easier to debug issues especially when chaining functions (i.e. endpoint going to a function that goes into more functions). Thanks!
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function? Below is a recording of my current setup that works in my 'Query All Records' function. However, in my 'Get Records' function, I'm encountering the following error: 'Please use a numerically indexed array.
How to nullfill variable (equivalent of SQL coalesce)
I keep running into the use case of wanting to create a variable that is the first non-empty value of a series of other variables. For example for some final variable X: I want X to be the first non-empty value of variables A, B, and C So if A = 2, B = null, C = 1 then I want X = 2 If A = null, B = null, C = 1 then I want…
Reference variable in a variable?
Hi, I'm using a loop to manipulate an object. I need each loop to use a succesive element in my JSON data. For example: Loop 0 —> user.preference.0 Loop 1 —> user.preference.1 Loop 2 —> user.preference.2 Initially I thought I could simply use the loop's "index" variable (which tracks the loop's current iteration number) in…
Add filter to change or replace key names in an object.
The filter should take an object such as {"key1":"value1","key2":"value2", "key3":"value3"} and provide a list of text to replace the key names e.g. ["mykey1","mykey2","mykey3"} and return: {"mykey1":"myvalue1","key2":"myvalue2", "key3":"value3"}. WHY? At times, one needs to provide more descriptive keys to the frontend (a…
Combining JSON data from seperate sources
Hi, I have a table of products and each product gets dynamically priced for the individual user in real time. The price is retrieved from an API call. I'm trying figure out how I can combine the products and the price data into a single JSON response that I can use as an API call. I have attached a screenshot to try and…
How can I ensure the create_object filter returns a null value in the object?
I have two lists, key_list = ["a", "b", "c"], values_list = [1,2,null]. The create_object filter will return {"a":1, "b":2}, the entry with null will not be included. What can I do to ensure {"a":1, "b":2, "c":null}?
Automating workflow on record creation or update
Hi, I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field. For example: let's say I…
Porting code from python into Xano
I have commissioned a scraper that was implemented in Python, the problem is that I don't want to use it in my shell but from Xano, is that possible? I'm attaching the code overhere
How to execute a task that is running every minute but only at a specified time?
I have a task that is running every minute and have a slurry of functions to run but only at certain times. Essentially I want to write a condition that if current time is 1am for instance, execute my function once (it should only happen when that time is hit, every other minute that elapses after should not continue to…
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 !
'Get All Input' function causes 'Unable to decode input error'
Hi all, I'm having trouble getting the “Get All Input” function to work properly. My setup is as follows: I have a submission form on a Webflow page with POST action set to endpoint in Xano. The first function in this endoint's funtion Stack is “Get All Input” with json encoding. When I send some test data from the form in…
How to run a conditional + edit function stack?
I assume loop would be the way to solve this, but I can't seem to get it to work. Quick loom here : https://www.loom.com/share/a6e67f13485b4373bbc4369d3e718455
Column based on concatenate values from other columns
Hi there, Im new to Xano, this may be an obvious question but I’m looking to have a column that’s is a concatenate formula from other values columns within the same record. Any guidance is highly appreciated. Sebas.
queue or API function delay
Hi community, I'm building and integration of two apps with Xano. 1st system calls Xano API. Then I have a logic inside Xano with some database manupulation And then it calls API of a 2nd system. 2nd system is OpenAI API which has some tough rate limits. My 1st system might have some use cases where it may do 1000 - 10 000…
Does anyone here know how to make a header and footer for a .txt file in xano?
I'm planning on creating a file resource (.txt) that has a sample format like this: HEADER 00000001 DETAILS/NAME/MMDDYYYY FOOTER 00000001 The details' data will be taken from a table while the header and footer are separately saved in a DB. Another thing, is it possible to create a file name sequence number that increments…
Is there a way to add a table as an input?
I find myself updating a certain set of fields/columns in different tables repeatedly. These columns appear as the same names same types across these different tables. I would like to be able to write one function that accepts the “table name” and then simply update these columns/fields in the provided table instead of…
Complex Financial Functions
Airtable has been very useful to me because of their ability to perform Excel-like functions. For example this monthly payment formula can be done by reference other fields in a record: {Loan Amount}*({Monthly Rate}*POWER(1 + {Monthly Rate}, INT(Amortization)*12)) / (POWER(1+{Monthly Rate},(INT(Amortization)*12))-1) From…
Bug in the new UI update
I like it that is intuitive and I didn't get confused a bit from the change. However, I'm trying to apply a "Find all elements" fuction in the stack and it doesn't show up. But when I run the endpoint it asks me for that input so it's there, just not showing up in the interface.
Leftpad Function
This snippet creates a code like "00045" by adding zeros to the left of a number (45 in this example) to create a string with a specific number of characters. Snippet: https://www.xano.com/snippet/6DUeN15v/ Loom walk-through: https://www.loom.com/share/5140921f5e474d1a9411b1bced147025 How to add a Snippet:…
Create Table References Based on External IDs
Hello everyone, I followed the video below to create references Based on External IDs on the table containing 600 records : Here is the function I created to perform this action: It seems to work but...only 70 records are processed... Looking at the video again, it seems that it is necessary to configure the pagination in…
array as input
Hi all, I am in trouble using array as input in my stack. In my case I have a "insured" table and a "policy" table. I am using filter by a custom query WHERE db:policy.id = var_2.id (var_2 is a list of policy id, resulting from customer relationship and auth control). I tried to pass this list and got this error { message:…

function

Discussion List