-
Round now() up or down to nearest 15 minutes
Is there a way to accomplish this?
-
Filter
How can i filter my list by names and the first name in order to see, Heller (last name) Gérard (first name) before Heller Hervé ? Thanks in advance for your help
-
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,…
Answer questions and share your knowledge