-
Forms
Addin Forms to a Table I did add a several time a Form to my table, but it always show the detai of my table. When I change something in one Form, the change is effectiv in all Form and Detail.…
-
FILTER ON "ICON"
I created a formula to get an icon as answer : if ACTIF = 1 thenstyled(text(" "), "white", "done")elsestyled(text(" "), "white", "x")end It is better to get an icon than a "Yes" or "Not" in the…
-
Drucklayout
Hallo, Ich habe PSA-Prüflisten erstellt und hierfür auch ein Drucklayout. Jetzt möchte ich für jeden Mitarbeiter ein neues Tabellenblatt und das Drucklayout natürlich übernehmen.…
-
Application DMS Document management system with Ninoxdb
Hello,I have to create a DMS soon for a client. The client must be able to drop files by dragging and dropping, adding tags, adding metadata, doing research on the files and their content.…
-
button to print
HiOn Android I created a button to print in pdf (attached files) using the following syntax : importFile(this, printAndSaveRecord(this, "Layoutname"), "Filename.…
-
Formel für % Abgeschlossen
Guten Tag, wie berechne ich die abgeschlossene Zeit von einem Projekt in % Ich habe ein Startdatum angenommen 14.06.2019 und das Projekt endet am 30.11.…
-
Subtracting 8 hours from a time worked field.
I have a formula field given the result of Date/Time Start and Date/Time end which works fine. For example such a result would be 9:00 (1 hour overtime given the day is 8 working hours).…
-
Print view with a Filter
Hello :), I have put in place a filter on my print view in order to filter my invoices and only see my overdue invoices. The filter works fine, however I have an issue with the invoices that have…
-
storing my database on a remote server?
in order to have a web database app how to allow other users and say a 5 user plan is that any 5 users or do each user need a user name and password?
-
Is there a way to combine 2 print layouts?
I have the follwing formula in a button, which sends a copy of a template i need to the client. However is there a way of getting the 'letter' template to send with one of the 'sections' or a way of…
-
I would like to copy the contents of a field to the same field in the next record
Adding device details such as serial numbers. These could be all for one project in "Project Title". To save myself and user having to select the project tile repeatdy how would I creat a formula to…
-
multiple choice equal to twice the same value!
I have a multiple choice with 6 different choices... I had an issue to use the result in a formula so I made a number field and I put a formula when it s been updated.…
-
multi user question
Can I collaborate with another user if we both have purchased the app or do we need to subscribe?
-
Date Formula?
I need a formaula to claculate 30 days from end of month, but struggling to find a formula that calculates how to add 30 days to the end of an existing month, any suggestions?
-
immobilier
let plainPied := 'Plain-pied';let chambre := Chambres;let villeBien := text(Ville);let typeDuBien := concat(Type);let prixDuBien := 'Prix F.A.I à supprimer';let statut := Statut;let typeRecherche :…
-
want to use same data baes by group of people with diffrent rights. how many lisence required ?
Sa I have a dtabse Sales with the Cusomer Table, Inventory Table and Order Tabke and Sales Table. Now i want 4 persons with 4 different user rights, How many lisence required ?…
-
integrated Google Maps Formula.
Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…
-
Why does "delete multiple fields" option not always work?
I am using Chrome browser for Ninox and am finding I can sometimes delete muiple records and then it will stop working. I am in an admin account and am in admin mode (red wrench showing).…
-
choice field color
I have created a multiple choice field where the different choices have different colors. How do I get this colors to print out in a form? they appear as just text
-
Sums and Counts based on a text status
I am trying to total the value of some invoices based on the status, like "Paid", "Overdue", etc. Ive tried some simple formulas with various adaptions and they are still not working,…
-
Sum a field based on a multiple choice field
I am trying to sum a field based on the value of a multiple choice field, ie = 1, 2 or 3. This works for values 1 and 2 here sum((select 'Personal details')['Bond/Insurance Provider' = 1].…
-
How to sort concatenate values from linked table
Hello, got hard time in order to find a way to order concatenated fields from a linked table. In short I have to create a report from main table that use a linked table to feed a grid with "Note…
-
change the labels on search
hello, how to configure the labels that appear on a search? thank you. alain
-
integrated Google Maps Formula.
Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…