-
Improve performance: Save Calculated values in Static fields
Views of the tables can sometimes take longer to be displayed due to the functions which are calculating the values. Formula fields have to be calculated every time the view is opened.…
-
Can't open the database
I've created a new database and I have imported a table from another one. This table has no formulas, only text and number data. If I close the database and enter again, all works fine.…
-
How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
No clue as to what is required here
-
Jump
There are any way to jum from LT_Actividades to Disciplinas associated. When click the LT_Actividades Display all Activities link with all Disciplines, can I choose only the Display on DISCIPLINAS.…
- Answered
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Rich text
Hello, I have a Rich text with many line. To end of every line i have a CR. Now with a function of text or another how can find then CR position. In a other word i need to parse line by line the rich…
-
Switch Case statement in Ninox
Another great structure in Ninox that can help you in the automatization of your processes is a Switch Case statement. Simple syntax, fewer lines of code, and faster result in your app.…
-
Filter a view by Id
Hi Again, We need a little help filtering a view. The view is in an appointment table and selects/views the invoice table lines. I’m trying to filter only the lines associated with the current…
-
App cloud sync ?s
I moved my DB to the cloud. I can access it now on my other Mac so that greats as my wife can acces it now. But now i see i no longer have the edit features to makes changes to things or add things.…
-
Why would a dashboard disappear after saving a dup DB?
I am to the point that i want to start loading in data into a clean working DB set up for my use. So did a dup of a working DB and gave it a new name. I now see the Dashboard is blank nothing is in…
- Answered
-
State of payments
Hi, i have a table (Payments) where I store all the payments that has been done for each student. Each payment has a date, a description, a payment method, an amount and an actual payer (mother,…
-
Adjusting Table size?s
I am trying to adjust many of my tables. I need to pull out to all most full screen to see many of them. But when i adjust them it is like it has a invisible wall on the right side that moves in and…
-
Connect customer to E-Mail - Help
I am working on making a new e-mail area that can use e-mail templates. I have it all set up and kinda of working but it has problems see screen shots and info.…
-
number() function stops convert strings with letters
Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .…
-
Invoice item button
Hi All, I am trying to use a button formula to mimic the + add new record. When using the Ninox template invoice, creating a new record opens to a page to enter the article/item.…
-
Creating many to many relationship between two tables
I am trying to create a many to many relationship between two tables. The database I am working on has two tables one is movies and the other is actors.…
-
Database locked
I log in to my database on cloud system and it goes to an open table with a constant spinning ball. It seems locked and will not allow me to navigate away from this table with the spinning ball.…
-
Prices changing in time and data import
Hi, I'm almost done with the basic structure of a database for managing school payments and I have these problems: 1. averagely, students stay in school 3 to 8 years,…
-
Set auto completion on Ninox editor
Hello everyone, I was fed up with always having to close the code editor to fetch the name of a field or table, so I set up the Ninox code editor to have an auto-completion function :…
-
Prefill Field when creating new record
Is there way that makes the new record when open, prefill certain fields based on what is coded in the button. for example. I would like to book a guest into a tour.…
-
Hide Empty Fields
I have a statement type database. There are several line items in the database for description and cost of each item. I would like the description and cost fields to be hidden if they are empty,…
-
Report to print multiple tables
For legal reasons I need to keep backups of my records. I think I need to save PDFs of my tables beyond just using Ninox's backup feature. I've found that I can print what I need by using the Print…
-
Constraint for multiple customers
Hello Brain Trust, I’ve worked at a constraint without success. I have several tables in the database and the tables of concern are as listed: Customer Owners Item A customer is an individual that…
-
Creating a template to print labels
Hi, I am creating a template within the print of option of Ninox for my labels. I created furmula field that contains Name and Lastname and the address for one label and I copied the same formulas…
-
logging user access?
Is there a way with Ninox to log when users access the database? I'm interested in knowing who logs in and when. Ideally would also be nice to know when they close the database (i.e.…