-
repeated array pop and shift
i have tried repeat shift and pops to get at arguments of an array. One would think that you get subsequent elements of the array and the resulting array would have less elements. I am not seeing that. The only combo that works is to do a shift and then a pop.[FireShot Capture 088 - Xano - api2.zwsociety.com.png]
-
Fuzzy Matching/Text Analysis
Hello All, I am using a front end to submit data to Xano currently the fields the users are submitting are free text and Im looking for a way to build or extend a fuzzy matching logic to standardize the data against a second data table with standardized data.
-
regex and custom query
I am using custom query and regex match. If my query is " john doe" and I want that to match "john1 doe", how can I do that?
-
Is trimming a 0 not possible?
I've been trying to use the ltrim filter for the past hour to trim the following text value: 0840006609841 I simply want to remove that first "0" from the left side. I've tested other ltrim values and it all worked, but when I try to trim a 0 (zero) it seems Xano ignores it. Am I doing something wrong?
-
database triggers
I saw a post from 9 months ago, where the suggestion was to trigger actions on db updates using functions on the stack. However, there could be more than one function on the stack that causes the update. Rather if a particular field in the DB gets changed then it would be nice to tie a custom function or api get triggered…
-
cron jobs
is there a way to run background jobs that might do some analysis?
-
Triggering email notifications if total values in a table within a date range reaches a threshold
Hello, I wonder if someone can help. I'd like to be able to trigger email notifications to users in a location (e.g. a specific county) if rows submitted to a database that mention their county surpass a threshold. So imagine someone has signed up to a service where they want alerts of new property sales in an area where…
-
Caculate Database Fields Against Each Other
I'm trying to figure out the best way to word what I'm doing so let me just tell you what I'm trying to accomplish: On my DB table you can see I have a list of products and along with those products I have prices from 3 different merchants.[image.png] On the front-end I want to be able to primarily sort the listing based…
-
Help Needed: Editing/Updating Multiple Records with Xano Post API
Hi everyone, Objective: I want to be able to edit/update multiple records through the Xano Post API for my tables Summary of issue: I understand that the issue is in the mapping a list [] to a singular field. My "Edit Record" function is not allowing these arguments/inputs to be passed and throwing an error. But I don't…
-
addons
[FireShot Capture 067 - Xano - x8ki-letl-twmt.n7.xano.io.png]when i setup an addon to reference another table B, i get a array type returned [{tag_name}], where tag_name is the field name on table B. I name this field in the parent object as role. I was trying to use filter to avoid having an array and object being part…
-
Summing fields
Hello Xano community! Is there any way to sum all fields in a column and add the result in a field from another column? Thank you!
-
For each loop time stamp manipulation
I use function 'for each loop' that add records based on the array. I need to set the "date_from" variable for each new record starting from the input date and adding +2 days to each next record. Is there a way to create a record with date and time manipulations? [Снимок экрана 2022-06-03 в 11.24.49.png][Снимок экрана…
-
DATEADD and/or LEAD type functions within XANO
Hey, Posted this https://community.xano.com/c/help-im-a-noob/advice-around-date in the Noob forum, but probably belongs more in the transforming data group. Essentially trying to replicate a SQL query that uses DATEADD (substracting months / weeks / quarters) and LEAD functions within XANO. Anyone ever successfully done…
-
Post JSON data
I am creating webhook end point that receives the JSON data (as post). Its header has hmac hash to validate the request. When I receive the payload, it looks like the order in JSON is changed when received on Xano. For example the JSON posted from the external server to the Xano endpoint is: { "event_id": "...",…
-
Comparing Any type with Date type
Hi, I have a Date type data in the Database and I want to compare it with an input (date type) variable. But the smaller or equal does not work here. Actually smaller works but the equal does not work here. Ex: It does not match if the two dates are equal. Should I transform any of the variables to do this…
-
Video metadata wrong
We've uploaded some videos into the database, but now I see that Xano is returning text/html for the mime type in the metadata. You can see the problem at this public endpoint: https://xim9-gixc-hpns.n7.xano.io/api:55wqYSaL/public/reviews Any idea what's going on? How can we fix this metadata? Thanks! Jonathan ┄ video: {…
-
database field for reference counting
i am modeling a field in a database for reference (usage) count. I increment the counter in the db. How can I add to it with transaction integrity. This is the filter I us[FireShot Capture 065 - Xano - x8ki-letl-twmt.n7.xano.io.png]
-
How to use joins to get this data
I have three tables: property • id • address properties_to_users • id • user_id • property_id • role_name user • id • name How do I get the result of a query that shows the properties associated with a user with the users roles. I only want to show the property once. This is for an authenticated user, so the input is the…
-
Access test data source from task
I'm like to use a background task to migrate data from the live data source to the test data source. Is it possible to access both data sources from a single task? Thanks! Jonathan
-
Conditional Query for empty fields
Hi all, Would like to conditionally query for when a particular field inside my table is empty, as per the screenshot below. [image.png]The schema for Account.subscription is an object. Is it possible to query for this? How else would you filter this?
-
ics data to xano
are there any ways we can add ics file content to xano database?
-
Efficiency Question
Hello! Context: I have 2 tables, User and User Invite. I would like to check if a User or User Invite already exists, before creating a new User Invite record, in bulk (so inviting a list of email addresses to the application). Question on which approach is more efficient with regards to Xano: A) 1. Query all records for…
-
Update records without looping
In order to update multiple records, I first need to query, loop through the list, then update one record at a time. I find this to be extremely slow. Is there a way to update records directly, like something you can perform in SQL like update user set firstname = 'John' where lastname = 'Smith'
-
Comparing timestamp and dates
Hi, I have a table where I store values for some metrics. The table structure is quite simple: metric id, userid, metric date and metric value. When a new metric comes in, I want to check if I already have a value for that metric id & user id for the date in question. I tried a query all records with 3 custom filters - 1.…
-
Apply Filter to Input
I'd like to apply a filter to my input data. E.g. I have a url that's coming in url encoded, I'd like to immediately url_decode. Can I apply that filter directly to the input variable `url`?
-
Save me: Unable to update object
I'm trying to update an object field with some object but I'm getting an empty array as response The table field:[Image] How I'm updating the field:[Image] The result I'm getting:[Image] I also had this kind of issue trying to update an array and didn't find any solution. So you will save me if you can help me.…
-
DomParser in Lambda functions always not defined
I am trying out the Lambda Functions for an HTML transformation, and am using the DOMParser However I get "DOMParser is not defined" as an error. i tried two options a basic one with no success: var htmlDoc = new DOMParser().parseFromString("","text/html"); and my code which throws same error: var parser = new DOMParser();…
-
Monthly Tasks
How do I get a task to be scheduled the 1st of every month? Currently the closest option is every 4 weeks, which by technicalities, is not a month as each month has a different amount of days / weeks. [image.png]
-
Remove key from JSON object dictionary
Imagine I have a record I'm returning that looks like: ``` { id: 10, name: "My record", creation_date: 123452435 } ``` How do I remove `creation_date` from the object?
-
Question
So I have a table called plans which has a starting and ending date and a list of subjects. When the user creates a plan, a bunch of "Entries" are created that relate to that Plan. Subjects are added to every day that's selected, thereby creating an "entry" to that plan. How can I automatically create entries based on the…