Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Account flows
If the button works you can put the following formula in the Trigger after update of the Amount field in Ledger: let t := this; let xLedger := (Accounts.Ledger order by Journal.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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
- 2 yrs 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
- 2 yrs ago
- 1
- 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Account flows
@Fred oops, this doesn't work beyond two records. :)
- Fred
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Learn and 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
- 2 yrs ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech I've updated the flow tab in Accounts.
Attachment
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Prohibit Deletion
When you edit a table you can set Delete Records to whomever you want.
- Fred
- 2 yrs ago
- 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
- 2 yrs ago
- 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
- 2 yrs ago
- 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Learn and 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
- 2 yrs 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
- 2 yrs ago
- Learn and 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
- 2 yrs ago
- Get help
- Reported - view
Re: Account flows
Take a look at this resonse. Some very helpful tips on how to manipulate arrays.
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 64 65 66 67 68 153

Back to top

Overview

View all topics