Button functions

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

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?