-
Can I use importfile() to pull in a local file instead of web file?
I'm trying to use importFile(this, "file:///users/....") . to add a file as an attachment without luck (on a mac) Does file:/// work? - all the examples I found use http:…
-
simple Payment receipt table setup
Anyone has simple Payment receipt table setup? I am looking for DB that can record an invoice no, date of posting, adv payment with date,and final payment with date and reporting for these.
-
Partial dynamic view
Probably nothing new for many: I once built a 'partial dynamic view'.There you can filter each visible table column of the view for yourself without having to create several views.…
-
Linking to Multiple Records?
This is confusing. Wish it was as simple as Airtable. I've spent hours trying to figure out how to so this.
-
Example of print output with Carbone instead Ninox Print-Editor
Attached are screenshots showing the result of a print output with Carbone instead of the Ninox print editor.The data all comes from Ninox, the QR codes are generated from transferred data from Ninox…
-
Replacing one value in a field with another value for records that match
I think I must be approaching this problem in the wrong way but .. I have a table which contains a numeric value. I want to replace all occurences of the number 1 with the number 0 for all record…
-
INVENTORY
Hello everyone,First of all, I wish you a happy new year 2022 I have been using Ninox DATA Base for more than a year and I am facing 2 problemsI use the INVENTORY template to manage the stock of my…
-
Filter for the selected column - hide all with set value
how to leave out all with set word, rather than show all ithe the set word
-
Verknüpfte Tabellen automatisch Datensatz einsetzen
Hallo Zusammen Ich habe folgendes Problem: Bei der Zeitabrechnung habe ich zwei Tabellen: Zeiterfassung und Jahresarbeitszeit. Beide Tabellen haben je ein Feld mit einem Datum (z.B. 05.01.…
-
logical functions in a SELECT statement?
Is it possible to use any logical functions when defining a SELECT statement? Or do I have to use many separate SELECT statements? Example of what I use now: let x := Field1 if x !…
-
How would I Filter 'Modified On' (Timestamp) Field to show only records modified today
How would I Filter 'Modified on' (Timestamp) Field to show only records modified today. Iknow this probalbly involves having another field to show true or false but does anyone know the correct…
-
Stuck on simple multiple if/else
Hello, I am trying to update a formula field 'Score' with values 1, 2, or 3 based on corresponding ratings from choice field 'Rating': if Rating = "Not much" then = "1"else if Rating = "Good" then =…
-
I’m not able to login to ninox
Is the only page I'm not able to access.
-
Problems with appointment fields
Does anyone have a solution to this problem: The time in the Appointment fields cant be changed (across all IOS devices - latest versions - reorganized - deleted/reinstalled) What happens is this:…
-
Dimensione maschera a scelta
Buongiorno, avrei bisogno di dimensionare a mia scelta una maschera, qualcuno potrebbe aituarmi? grazie
-
use a field from a related table in a pivot view
Ich have 3 Tables with a M:N relationship built as usual. In the "Joint-Table" I can create a pivot view with data from the other two tables. However, when I would like incoporate this pivot view in…
-
Function for attachment count
Is there a way to retrieve the number of attachments associated with a given record? Ultimately, I would like to display this information in a view and, possibly,…
-
Help needed with invoicing
Hi, it's been a while since l have posted but have come across a problem l don't know how to rectify. l have an Invoice table linked to a Customer table,…
-
To select acolum in the table view ?
Hi Does someone know the way to select a colum in the table view in the Ipad version ? Thanks.
-
How can I filter a column in a table by "empty" OR Criteria A OR Criteria B, but not Criteria C?
Looks like I can only have empty or a selection of categories, but no combination of it, as in e.g. Excel?
-
"Set-Date-script" - something goes wrong
Guys, I have i button to set a task to "Done" Deadline := null;Today := null;DoneDate := Today;Status := 3 The "DoneDate" field does not set the value to "Today" but returns null.…
-
Call a button from a trigger
Is it possible to call a button from a table or field trigger. I have 2 applications for this. 1) I have a very long 'Trigger after update' on a table that was easer to work out as a series of…
-
Where to write a global function
I have to make a calculation: Total = Qty * price -/- discount.I know i can make the Total a calculated field but you don't need to fill the price or discount.…
-
PDF image color different in browser export
Hi. I have notice that the pdf exports the image with a color significantly different when generated from the browser than when generated from the macOS app. See the images.…
-
Query multiple columns from API
Hi I want to query several columns from my API, this example only shows how to query one. How do I query more columns? https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/pt53j1tburs8/query?…