Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

2,185
319
2

Joined: 06 Feb 2020

My Posts

Latest Posts

Re: Is there a known problem with dynamic printing?
I was able to produce a test print. I do use a custom JSON, so I don't know if that makes a difference.
- Fred
- 10 hrs ago
- Get help
- Reported - view
Re: Account flows
Ok take a look at the button in Accounts > Ledger tab. I've added a number field in Ledger called Balance and the button does the math for all related Ledger records.…
Attachment
- Fred
- 12 hrs ago
- Get help
- Reported - view
Re: Prohibit Deletion
@demo3678 So you have multiple computers with the same iCloud account accessing the DB? This is not really a multi-user situation. If multiple people are sharing the same computer,…
- Fred
- 13 hrs ago
- Get help
- Reported - view
Re: Prohibit Deletion
@demo3678 It makes sense that you wouldn't need to worry about deleting records if you are the only user of the DB. If you are trying to protect the DB from yourself, which I do myself.…
- Fred
- 14 hrs ago
- Get help
- Reported - view
Re: Account flows
@Fred oops, this doesn't work beyond two records. :)
- Fred
- 15 hrs ago
- 1
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech You can try this in another formula field. let curLedger := this; let relatedLedger := ((select Ledger where Accounts = curLedger.Accounts) order by Journal.…
- Fred
- 17 hrs ago
- 1
- Get help
- Reported - view
Re: Button to open a PAGE
@John Halls But the MacOS and iOS are stuck in 3.9 so you can't go back and forth.
- Fred
- 17 hrs ago
- Get help
- Reported - view
Re: Account flows
You can also put this in a formula column in the Ledger view element. This method is dependent on the view element being sort ascending by Journal.Date.…
- Fred
- 19 hrs ago
- 1
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech said: I would like a running total of the account balance on each ledger line item. You can check out this post.
- Fred
- 19 hrs ago
- 1
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech said: I would like a column that shows a running total after each ledger line item Currently the DrCr field in the Ledger table is a formula field that converts the data in the Amount…
- Fred
- 21 hrs ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech Can you add the DrCr field as a column then you can use the Column sum feature?
- Fred
- 22 hrs ago
- Get help
- Reported - view
Re: Workspace ! Not being recovered where images are held & deleted.
@Haavard Hjorteland said: 3: Third option I have tried is: Selected the DB, then "Export data", then selected "NINOX" and tried different options with 'Data model', 'Data' and 'Files' checkboxes.…
- Fred
- 22 hrs ago
- Learn & Share
- Reported - view
Re: Word Wrap doesn't function when you apply a rule to a table
Ninox doesn't regularly look at the forums, so you have to email them directly.
- Fred
- 23 hrs ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech I've updated the flow tab in Accounts.
Attachment
- Fred
- yesterday
- 1
- Get help
- Reported - view
Re: Prohibit Deletion
When you edit a table you can set Delete Records to whomever you want.
- Fred
- yesterday
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech said: Not working yet. Can you write out an example using the records in your DB? When I use Alain's example in your view in the Flow tab of the Groceries record (Account Id = 731) it…
- Fred
- yesterday
- Get help
- Reported - view
Re: Button to open a PAGE
@John Halls and the MacOS. That is why I switched to cloud. They have increased the feature disparity between products. Sadly they are bringing the same disparity to the cloud versions (Private vs…
- Fred
- yesterday
- Get help
- Reported - view
Re: Account flows
Ok, now spending a few more moments looking at things, I think I understand this: let xAccountId := number(Id); let xLedgerId := text(unique(concat((select Ledger)[Accounts.Id = xAccountId].Journal.…
- Fred
- 3 days ago
- 1
- Get help
- Reported - view
Re: Close the cell after editing
Build a dashboard/Page to do all data entry. Then you can easily control write access. You can see if a field already has data and not allow any updates. Or you do what Mel and Rafael do in this post.
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Workspace ! Not being recovered where images are held & deleted.
@Haavard Hjorteland Yes, you can access Public cloud in MacOS app. You just login to the app as you would the cloud. That is what I do. I would love to continue to use the app but it is stuck on 3.9.…
- Fred
- 3 days ago
- Learn & Share
- Reported - view
Re: Account flows
We can help build the code. Question: This line: let xLedgerId := text(unique(concat((select Ledger)[Accounts.Id = xAccountId].Journal.Id))); You want to find all related Journal records to a…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Workspace ! Not being recovered where images are held & deleted.
@Haavard Hjorteland I don't know if this is solution, but if you have a MacOS computer, or a good friend that has one, the MacOS app, which is free, allows you to export entire Ninox DBs as is.
- Fred
- 3 days ago
- Learn & Share
- Reported - view
Re: Reference Error
@ionker said: I entered this in the global command (I think this is where it should go) but it won't accept it. Have you tried it in a button? You can also post your code.
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Account flows
Take a look at this resonse. Some very helpful tips on how to manipulate arrays.
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Jump
@Rafael said: y presionas el cambio 2023 o 2024 en 2023 hay seis meses con horas en 2024 hay 1 mes solo enero. la Fórmula del panel) cambia de 2023 a 2024 Ok, excuse me,…
- Fred
- 4 days ago
- Get help
- Reported - view

1 2 3 4 5 88

Back to top

Ninox-Documentation

Overview

View all topics