0

Button functions

Hi, is it possible to add a formula at a button to close all the opened table?

17 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    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

    • maxvalentino
    • 5 yrs ago
    • Reported - view

    Great, many thanks Leo

    • Ron_RLA720_mscpostpr
    • 5 yrs ago
    • Reported - view

    And thank you, Leonid, from me, too.
    I am newcomer to Ninox, so clear, simple, answer like that is very helpful way to learn.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hey guys,

    here is the link to the reference of functions and language

    https://ninoxdb.de/de/manual/berechnungen/funktions-und-sprachreferenz

     

    Leo

    • Ron_RLA720_mscpostpr
    • 5 yrs ago
    • Reported - view

    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.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    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.

    • chair
    • 5 yrs ago
    • Reported - view

    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

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hi Su,

    ---

    let thisNUM := number(Id);
    let myNUM := min((select 'Your Table')[number(Id) > thisNUM].number(Id));
    openRecord(record('Your Table',myNUM))

    ---

    Leo

    • Michael
    • 5 yrs ago
    • Reported - view

    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. 

    • chair
    • 5 yrs ago
    • Reported - view

    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?

    • Michael
    • 5 yrs ago
    • Reported - view

    I’ve that idea

    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi,

    Feedback taken and we are working on a more comprehensive manual.

    Regards,

    Sakshi-Ninox

    • alheron
    • 4 yrs ago
    • Reported - view

    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 🙂

    • Birger_H
    • 4 yrs ago
    • Reported - view

    This is no yet possible. We are working on this.

    Birger

    • Robert_N
    • 4 yrs ago
    • Reported - view

    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?

    • Support
    • 4 yrs ago
    • Reported - view

    You can try this:

    –––
    openTable("TableName");
    let myS := create 'TableName';
    openRecord(myS)
    –––

    Birger

    • Robert_N
    • 4 yrs ago
    • Reported - view

    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
  • 8967Views