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
-
select b[Status=2] order by AmountThere 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.
-
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.
-
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.
-
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