-
Generate Unique Identification Numbers
I need to create a field in my database that generates unique identification numbers for each row. The desired format is f-####-####-####, where the "f" remains constant. These numbers should be generated for both existing records in the database and any future records that will be added. Can anyone help? I can easily do…
-
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!
-
Column depending on another
I have a column that depends on another. Depending on the value that is entered, the other column needs to be automatically filled with a predefined value. I've been trying to do an endpoint, but isn't working.
-
Paginate Response
Hi everyone, Just wanted to know if there is a quick way to paginate a response. As you can easily do when you query a record table → https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-paging I modify and sort my output quite heavily. So querying all…
-
Calculating total hours worked - Should I use Custom Functions?
Hi! I want my API to return the number of "hours worked", based on some business predicates, using the data being stored in related records. I'm sure it can be done with Xano, but I'm unsure about what component/feature to use. Should I use a Custom Function? Or should I use something different? In Airtable, I'd typically…
-
How do I create a program that can schedule recurring dates
Hi all, I'm trying to build an application where the admin is able to schedule a program to recur based on the days of the week and the time. For instance, every Monday, Tuesday, and Thursday at 7 am, there is a breakfast offer. Could I get some help in building this? Such as how the database and API should be designed?…
-
Native Xano Memberstack Alternative
Hi! I am building a membership site with multiple subscription plans. I have worked through the Webflow-Xano-Memberstack demo which provides a basic solution. I am trying to minimize my application stack and was wondering if anyone has built a membership site using native Xano, and eliminating the need for Memberstack.…
-
Will I have efficiency issues using random number generation as a serial/ad number?
I just added a function to my app where on creation of a new ad entry a serial number is created. I used a function to created a random NEW NUMBER between 1000000 and 9999999. I then queried all records of the ad table, with the output variable CURRENT NUMBER only containing the ad numbers. I then used a while loop to…
-
Best practice to pass/map variables to custom function
I'm sometimes dealing with situations when I have a few custom functions nested under each other. Let's say I get a user profile data (30+ key-value pairs) from db in the first one, but then I need to use these same keys-values in a custom function underneath. What would be the best practice to pass them to that function?…
-
Doing a product recommendation style quiz using Xano to do the math??
New Xano user, I hate to ask dumb questions (at least ones that can get answered by some intensive research) but I'm using Wized and Xano to build out the backend of my Webflow app and was curious, given Xano's function capability if it could do this: Take incoming inputs from a user on the Webflow front end Loop through…