Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

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
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
- 2 yrs ago
- Get help
- Reported - view
Re: Reference Error
Here is the description of the command. Let us know if this is enough.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Jump
@Rafael said: Fred the idea is when you check the 2024 year view the first record the 2024, now if I check the 2024 year can't View the first staff on Jan I don't see a 2024 year view element.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Jump
You are going to have to be more specific. I looked at your DB and don't really know what you want to do. There is only 1 table. Which first record of 2024 do you want to find and where do you want…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Jump
What do you mean by "Go to the first record of 2024"? Do you want to popup the record or bring the record up in a view element?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 65 66 67 68 69 154

Back to top

Overview

View all topics