-
Linking tables after importing from database
I have imported several tables via CSV and would like to link them afterwards. I have a unique ID (company name) which I could use as a link. How can I link tables that were already linked in another…
-
HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT
How can I display in the print layout the same table-view as displayed? The table-view is displayed with a different order of column and has filtered fields....
-
Need Script for calculating workdays between 1st record, 2nd record, so on.
Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…
-
Aide francais
Bonjour je cherche une personne qui parle francais pour obtenir de l'aide dans la création de ma base Merci
-
removing embedded quotes from a text object
still learning. How can I remove embedded double quotes from a text variable? xText contains -> this is a test'''to remove embedded quotes
-
How to use the "View" element
Hello, when we create a database, we can add an element called "View". Can you please tell me how to concrete use this field? Because I always get the error message "Expression does not returns…
-
Delete record if fieldA := fieldB
Hi, is there a way to completely delete the current record if a formula field results in a specific value or equals another given field?
-
How to create balance table from income and expense tables
Hi. I have two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…
-
Alert message on CloseRecord
Hi guys, i want Ninox to check that a certain field is not null when closing the record and alert me if it is the case. if Type = null then alert("Remember to fill in the *Type* field")end it works…
-
is it possible to copy a view?
I find the possibilities of formatting a view have improved hugely since the last version update. Now I have a luxure problem: I would like to create multiple views that differ just a little bit.…
-
disappearing formulas
I have just started testing the trial, which means web based and not the app. So far I have 2 tables, a parent and a child. Currently driving me nuts is that in the list view of the child table I add…
-
Getting a 429 Too Many Requests error from my Integromat scenario when accessing Ninox API
Can you please send me a link to the document that contains the limits of the API, i.e. how many requests is acceptable, over what time period and how long I should back off if I receive a 429,…
-
To sort the groups…
Hi Is there a way to sort the group by number ? Thank you.
-
If a text field has > 30 '#' then show alert
Wondering if there's a formula that will check a text field for the number of hashtags (#) and if there's more than 30, allow to pop up an alert or have field become visible alerting to the fact?
-
Inconsitancy by data aggregation
Hello, Ninox newbie here so please be gentle :) I have imported a lot of a data and want to clean out data inconsistancies. This case is fairly simple, for each invoice the invoice amount must matche…
-
how do I use ninox to print avery address labels?
how do I use ninox to print avery address labels?
-
How to make round down work
Hi!In manual it looks like round down(x) should work but it doesn“t
-
Why do I not find the Share view?
I use Ninox on my Mac. I have an annual suscription and I run it also on my other computer and my iPad. I have seen on the manual that if you click where Edit fields there are several options:…
-
Building your own Function?
Hello, Please van you give some code examples how to define a custom function? Forum description: ++++++ Creating User defined functions locally with the function command: function name(argument:…
-
API call on foreign API from Ninox WebApp
I'm trying to retreive Information from OpenProject API. The following Code works in my iPad, but not in Chrome: let response := http("GET", "Openproject URL/api/v3/users/{my User Number}", null,…
-
Hey ! Do you want another tricky question ??? Again concerning sorting…
One thing that is great in ninox is the way we can group records… Another thing that is great and super easy is to count the number of records in each group… But… now… i would like my groups to be…
-
Save archive as... crashes Ninox
For privacy policy reasons, we cannot use cloud services to save/store our Ninox database. I've been using "Save archive as..." and then "open in" to save it locally using Filr.…
-
Debt and credit
I have 3 columns for debater, creditor and balance. What formula do i need to show the balance columns. So the balance columns it is a difference of the debtor and creditor based on the picture…
-
Count If... function help
Hi I need help on a formula for my database.. I have a field called Procedure, this field has several posible choices (different procedures), lets call them A,B,C,D,E,F..…
-
Print
Hi, i maked button in form of invoice items, then when i changed a goods i click print form and i can see in attach. Problem is when i change for example items and will print againe ,…
Answer questions and share your knowledge