-
Values of Multiple Choice shown as list in print report
Hi guys, Normally when you put the values of a Multiple Choice field in a print report, it's shown as all the values separated by a comma and a space. Is it possible to get the values shown as a…
- Answered
-
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…
-
Top left Global search
I never use the Global Search top left because it really does need some refinement by Messrs Ninox before it really comes into its own. For one users need to be able to choose columns.…
-
Update a field in another table
Hi, I have a 'Parts of car' table, where after selecting for example the engine, I need to select the parts (in this case 1 part) which is necessary to repair the engine.…
-
Where have the Views gone?
I have a simple table of all the images used in the database. They are categorised so I can limit the list when picking a photo for a linked record. I set up half a dozen (Table type) 'Views' so I…
-
Block a field if ?
I need a script that allows me to block the loading of HOURS (Horas Hombre) if the Document (Documeto) its DateR5 is 100%.
- Answered
-
Sum related field with specific criteria issue
I have a table called Projects with a reference to a table called Proposals, and there can be multiple Proposals per Project. Within Proposals I have two fields;…
-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Neither of the two formulas work
I try these two formulas but not work some ideas. select 'DOCUMENTOS' let xFld1 := 'Avance Plan'; let xFld2 := 'Avance Real'; let i := (create AVANCES_PROY); i.('Avance Plan' := xFld1); i.…
- Answered
-
Data Entry Validation?
What is the preferred method to validate (restrict) user input? Say you have an "ounces" field that should only accept values from 1-16. How would you enforce that data entry? Thanks.
-
Export Import File
Hi, I need to produce a file that has references to the same record but on multiple lines. It is for an import file into our web software. The file is:…
-
Aiuto Please I must do a TIGGER AFTER UPDATE
As soon as I select a choice from the "Chi?" automatically he must select the same answer in the "Consulente" combo box.I state that "Consulente" is a linked table and that is "Chi?…
-
Payment of several unpaid invoices
Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…
- Answered
-
Display fields from a linked record
Hi, This is most certainly basic features, but how to display certains fields (i.e. text or picture) from an upper linked/rooted record, directly in the sub record, please ?…
-
Split Records
Hi Guys, I have attached a sample database called CONDOS. It has a subtable called JOB with a parent SERVICE. The Condos have multiple owners. Each owner has a percentage given in the OWNER table.…
- Answered
-
Sync to new device (iPad Pro)
I've been using Ninox predominantly on my iMac. However, I occasionally use it on my laptop and even more rarely due to the size of the screen on my iPhone.…
-
Column Filter Date?
My table's column is grabbing dates from a subtable. How do I filter the results to show a specific date only? The results I get are for the date I want plus all of the dates of records with that…
-
Copy Yes/No function value
The table has a button that creates a copy of some records from the table for the next day. Part of the formula looks like this let c := (create 'TABLE'); let t := this; c.(DATE := t.…
- Answered
-
Proper Case code sample
It seems Ninox does not have a proper case function. That is to say only the first letter of a sentence to be forced to Upper. The best I could come up with is: DESCRIPTION :…
-
Extract year from date field in text format
Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…
-
Insert automatically customer data
I would like insert automatically customer data in another table without having the user fill them in. The data is same, selectd in a lookup table. It's possible? Thank you
-
Da numeri a lettere
Mi serviva una funzione per stampare delle ricevute in cifre ed in lettere così anche se non sono un esperto ho scritto una funzione che può essere utile a tutti.…
-
Building table relationship 1:N
I have two tables I imported from a previous database. They were linked by an ID number. How do I recreate the relationship between these tables on the imported ID number fields?…
-
Automatic cutting stock item when creating invoice
Hello. I would like to know if the below scenario is technically doable in Ninox. I have a table for - Invoices - Stock Invoices and Stock do both have a subtable for Line Items.…
- Answered
-
3.10 BUG feed back please.
When I try to select an option here, I get nothing offered. Can anyone confirm before I report to Support
Answer questions and share your knowledge