Button functions
Hi, is it possible to add a formula at a button to close all the opened table?
17 replies
-
openRecord(recordId) - opens the record and jumps to the related table
openRecord(record(Invoices, 1))popupRecord(recordId) - opens the record in a popup form without switching to another table
popupRecord(record(Invoices, 1))openTable(tableName, viewName - opens a table view
openTable("Invoices", "All Invoices")closeRecord() - closes the top-most record form
closeAllRecords() - closes all record forms
Leo
-
Great, many thanks Leo
-
And thank you, Leonid, from me, too.
I am newcomer to Ninox, so clear, simple, answer like that is very helpful way to learn. -
Hey guys,
here is the link to the reference of functions and language
https://ninoxdb.de/de/manual/berechnungen/funktions-und-sprachreferenz
Leo
-
No, Leonid, that page is not so helpful. Many reasons, but I won't take time to explain all here.
In general, the user manual is organized from the wrong point of view. It is written by a few Ninox programmers. But we are 99,000 Ninox users. There is a big difference in approach that is not yet understood at Ninox.
So, until the user manual is improved to a higher standard, you will continue to get many, many, simple questions like the opening post on this topic. That there are already hundreds of such simple questions on this form, confirms my point.
I appreciate answers like the specific function list that you provided above. But even better would be a better manual. And even better than that would be a "front end" to the documentation using a simple AI engine.
-
Hello Ron,
i understand you very well. I'm not a programmer and at the beginning I had thousands of simple questions. Sometimes the developers could not understand these questions, because many things are natural for a programmer, and for "normal" people - a big secret. That's why I'm trying to answer all the questions here because Ninox seems to me the best data base software ever.
-
I completely agree that the manual isn't user friendly for non-programmers (like me), but I do love how easily I have been able to cobble together a relational database with relative ease.
Leo, could you please let me know what I need to type to create a button to jump to the next record please?
I know that there is the > button at the bottom of the form, but I'm going to be passing the iPad to a user who would probably press the wrong button or wouldn't be able to see the tiny button so I simply want to have a 'Go To Next Record' button on my form.
many thanks in advance
Su
-
Hi Su,
---
let thisNUM := number(Id);
let myNUM := min((select 'Your Table')[number(Id) > thisNUM].number(Id));
openRecord(record('Your Table',myNUM))---
Leo
-
Maybe we shall have a wiki-manual, anyone could give input to it then. Out of experience not many people will help to improve the manual that’s why it’s only written from a few of people.
-
That's a good idea.
Before I ask a question I always do a search to see if the answer is on either the forum or in the manual.
Perhaps Ninox could look at the questions that are being asked on the forum and incorporate these into the manual?
-
I’ve that idea
-
Hi,
Feedback taken and we are working on a more comprehensive manual.
Regards,
Sakshi-Ninox
-
Hey Leo
following on from the 'Next Record' button (which works well, thanks) is there a way to use this to move from one record to the next but open in the same field. For example, if I am in field 3 of Record 1 can I use the 'Next Record' button to move to field 3 of Record 2, then field 3 of Record 3 and so on.
Many thanks in advance
Al
-
This is no yet possible. We are working on this.
Birger
-
Hi,
Im new to Ninox and find it very useful with everything I do with work. im trying to create a button that opens my Sales log as well as a new client page at the same time. Is this possible?
-
You can try this:
–––
openTable("TableName");
let myS := create 'TableName';
openRecord(myS)
–––
Birger
-
Thanks. I'm currently using this:
let myID := Id;
let NN := (create Client);
popupRecord(record(Client,number(NN.Id)))I'm trying to also have certain information already filled in, like the reps name. Is there anything like that I can use?
Content aside
- 4 yrs agoLast active
- 17Replies
- 8995Views