-
Auto create records in sub-table
I have a table: "TRAINING". Inside that table, I have a sub-table: "TOPICS" I know that it's possible to have a button, creating let's say 10 records in the sub-table when clicked (every training…
-
Views
I have a PROJECTS table with 2 subtables CONTRACTS and SOLUTIONS. I would like to show a View in SOLUTIONS, showing the CONTRACTS - but only the ones related to the current PROJECTS How do I write…
-
Not Authorised - Undefined message
Team Members receive this message when pressing a button to print and email a document. It works ok for the owner. I need help as team members print every record they enter in the database. Tony Ryder
-
How to view join table?
I've set the data model, but how can i view the join table?
-
Question about subtables
First, let me say that although I understand various relational database concepts, I'm a long way from being an expert user. There is no such thing as oversimplification when describing something to…
-
I'm trying to develop a small application for a caregiving team for my disabled brother that I want to move from paper to ipad data entry. I have begining databases. I can't figure out how to test it online. Like I could any HTML code. Help!
I'm trying to develop a small application for a caregiving team for my disabled brother that I want to move from paper to ipad data entry. I have begining databases.…
-
WhatsApp and Viber formula
I use ninox cloud. I want to make a button, send a message to WhatsApp and a button for viber. Both messengers are installed on the computer. Someone already using it?…
-
Enter a number in the field do not use the keyboard
I need to make it so that when the buttons "-" and "+" are pressed, the number in the field changes. So that you do not use the keyboard to enter a number in the field Does anyone have a solution?…
-
Activity Contact
Hello guys, I have a "Offers" table with all the offers from sellers. Inside I have an "Offer Status" field in which I check. I would like that, when the status of the offer becomes "Offer lost" I…
-
Bild aus anderer Tabelle in Printengine über select-Befehl darstellen?
Hallo liebe Community, über den select Befehl lassen sich z.B. Bilder aus nicht verknüpften Tabellen in der Formularansicht anzeigen. Geht das auch in der Printengine? Über (select Tabellenname).…
-
how to get a local database online
Is it possible to move existing databases onto the ninox cloud I just signed up for?
-
Ninox amendment…
Hi I received an email from Ninox about a new amendment. Being French and the texts concerning it being very long and very specialized (law language) I don't understand much.…
-
New to Ninox - How to create and link a "lookup" table?
I'm creating a Media Collection database consisting of 3 main tables; one for LPs (albums), another for CDs, and a third for DVDs/Blu-ray Discs (movies).…
-
Create a sales ranking
Greetings, I am from Ninox members (sellers), and I would like to create a sort of ranking based on the achievement of monthly goals. Eg: I have Massimiliano who has a sales goal of € 10,000.…
-
How to duplicate a record with reference to the original one?
I am using a button-script like this let d := duplicate(this);d.(“Yes / No” := false);d.(Customer := 0);popupRecord(d) This duplicates the record and empties the fields: “Yes / No” and Customer.…
-
Question
I need help identifying a particular year in a multi-year database.
-
Switching between databases
I use 2 databases back and forth - is it possible to write a code snippet on a button that when clicked closes "DataBase1" and opens "Database2" - and vice versa?
-
Can I write comments inside the code?
Hey, I want to give comments inside the code. Example : sum = number(a) + number(b) (// this is the sum of two numbers).
-
Loops syntax
Hi, guys: I'm running into something that I just can't get past. I have a loop structure that I can get to work; here's a general summary: let xCounter := 0; let xTotalMatchingRecords := cnt(Table);…
-
How prohibit changes to the table/field record
How i can prohibit changes in the table of an already made record. Task - If the record has been made, no one can change it, just admin. The prohibition on deletion has been work,…
-
display of fonts in a "Rich Text" control
Hello,why I can no longer display the fonts or colors of the text in a "Rich Text" field. When I click on show fonts or colors nothing happens. (PC MAC - OS High Sierra)
-
sendEmail({ help!
Hi, I have the following triggered after update from a date function 'outworker deadline', but it refusing to send an email. Todays date is a formula field today().…
-
Convert coded text to plain text
Hi. I have this code from Zapier-Jotform [{"N. de llicència":"Ib 1234","Nom complet":"Mateo Domínguez Fuentes","Data naixament":"02/02/1983","Categoria":"Absoluta"},{"N.…
-
Display two tables at once?
One other question for today... Is there any way to display two different tables, in table view, on the screen at the same time? I want to visually compare some of the data between two tables,…
-
Table relationships, data model
Very new Ninox user here, used to use FileMaker long ago. I'm trying to learn how to create relationships between tables. I tried creating a relationship between two tables (in the same database),…
Answer questions and share your knowledge