-
Global Script Definition for Specification of Quarters and Fiscal Years
I am trying to create reporting within my database of records within the specified Quarter. As far as a simple solution, within my table and form, I could add a text table of Q1FY20 but I was…
-
help
Ho un campo rendimento che varia in base al confronto tra una data fissa e una data che inserisco. Ecco la formula ma non succede nulla let a :="07/10/2005"if Attivazione < a and Articolo.…
-
What language for user programming
Is there a reference for the commands, statements and conditionals that users might add on triggers and other aspects of Ninox? ("If", "else", "let", etc).
-
How do I update a view field
I have a view field in my database. When I click on the field, finder comes up for me to pick a jpeg to view. If i accidently choose the wrong file, I can't see how I can change it.…
-
How to Sum up values from a specific field, only if another field value is the same.
I have the three fields: Receipt # Group FIELD Receipt Items FIELD formula for Receipt Items right now: let myNum := 'Receipt # Group';cnt(select Inventory where myNum = 'Receipt # Group') Purhcase…
-
Streak' calculation
I'm trying to create a formula that will look at the date field from the previous record, compare it to the current record, and then make a calculation based on the difference.…
-
Syncing
I have imported a lot of data using the Mac Desktop App. But it does not sync to Ninox. When I open the web app of Ninox the data does not appear and vice versa.…
-
HELP Accidentally deleted a table
Not sure how, but I thought I was deleting a field and accidentally deleted an entire [very important and complex] table. I can't find the file in my iCloud folder to try and revert.…
-
How to select more than one option from a multiple choice when creating a record from a button?
Hi i have a field with multiple choice in a subtable when creating a record from a button in a master table how do I preselect 2 or 3 choices? I am able to select just one, this is my code : let LNK :…
-
CHOICE option appended to a TEXT field
Example: the text "Hello" is entered into a TEXT field. The options under a CHOICE field are " World" and " Earth". In this case "World" is selected. On update the CHOICE selection is appended to the…
-
Indicating already picked Multiple Choice fields
I have a table of users linked to a table of assets (ie A-Z). Each user could pick more than one option ie User1 has A, D; User2 has B, P etc. How can i indicate which choices are already selected or…
-
Ninox Web ( https://ninoxdb.de/en ) - Certificate Error
Ninox Web ( https://ninoxdb.de/en ) it's ok just in some computers some browsers - in several others I can't log in - Certificate error -- DLG_FLAGS_INVALID_CA for example: in one computer,…
-
Removed choice value by mistake
I accidentally removed a choice value by mistake and saved the repair. My database is structured around the values of this particular field. I could just add the value again,…
-
Créer un enregistrement dans un sous formulaire
Bonjour, Je souhaiterai pouvoir créer un enregistrement dans un sous formulaire en cliquant sur un bouton. J'ai donc affecté à mon boutton le code ci-dessous : let e := (create 'Echéancier');e.…
-
Weighted Average
Does anyone know of a way to calulate a 'weighted average' for use in a Bubble Graph. Thanks in Advance. Tim
-
Using old format for new table
I'm creating a new database for 2019 and I would like to use the format of some of my tables in my old database for 2018. I was hoping to just rename the database and erase all the old data.…
-
How can I change a field type - from text to choice?
Don't know what to put here
-
Sorting records by info in a field
I'd like to sort my records in alphanumerical order according to text within the TUBE field. Despite being a beginner I've managed to get a working database with a few features but I have no idea how…
-
Function result from multiple tables
I have a formula result sub-table A that I want to multiply by a number entered on sub-table B. I wrote the formula by clicking the field for A, "*", clicking the field for B.…
-
copy a database
I would like to copy a database so I can experiment with it without messing everything up. I can't find how to make a duplicate copy of a database.
-
Seeing a deleted column in the table's Edit Columns view
Why after deleting a column in a table (via the table cog) do you still see the column in the filter of the columns for the table?
-
Zoom text field to full screen on iPad
Clicking in a text field will zoom to full screen on the iPhone app. This is helpful for long texts. This zoom to full screen does not happen when I click in a text field on the iPad app.…
-
Form view
I created a form view for the details of a specific item. As i select a specific item in the invoice database and want to change my view from "all" tot the selected record,…
-
Tabellen vergleichen
Hallo, ich habe zwei Tabellen, Artikelnummer2018 und Artikelnummer2019. Jede Tabelle hat eine Spalte „Artnummer“. Ich möchte in einer dritten Tabelle die Unterschiede ausgeben lassen.…
-
Round Up
I need a function to round UP to the nearest 100. The manual references both "round up" and "ceil" functions but both return the error "function is not defined".…
Answer questions and share your knowledge