0

Selecting specific records

Hi. I have a formula in table a looking up a value in table b. Value b has multiple records as table c looks up values from table b. Is there any way I can select specific records, for instance sorted by date or something else?  
When I look up now, all records are listed. 

4 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    select b[Status=2] order by Amount

     

    There are numerous examples in the documentation at:

    https://ninox.com/en/manual/calculations/reference-of-functions-and-language

     

    You can also filter and sort by any column by clicking the column header.

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    When searching the documentation at the above link, try pressing the command and f keys (on mac) or control and f keys (on windows) and typing "select". I find this much faster than using the build in search field.

    • -
    • silver_bee
    • 4 yrs ago
    • Reported - view

    Thanks :-) Do you know if it's possible to duplicate a database on the cloud version? I understand that it's possible on icloud, but I can't find this option on cloud. 

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Yes. Before opening a database solution, click on the upper right corner of its icon, then from the pop-up select "Create Backup" and perform a manual backup. When finished, click the "Import Archive" icon and import the backup as a new renamed database solution.

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1127Views