Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3614
570
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Using triggers for yes/no field
Try: if Status = "Closed" or Status = "Expired" Ninox doesn't have a way, that I know of, to combine search terms.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Search and select the most similar text
In the table Registro: The reference field AE - fatture ricevute is linked to which table? The reference field Intestato a is linked to which table? Can you upload a test version of your DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button to open a PAGE
They also updated the iOS app. BUT iOS still is missing auto completion of commands or fields. They shouldn't call it 3.10.10 if does not match all of the features.
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Fred oops, this doesn't work beyond two records. :)
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech I've updated the flow tab in Accounts.
Attachment
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Prohibit Deletion
When you edit a table you can set Delete Records to whomever you want.
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 56 57 58 59 60 145

Back to top

Overview

View all topics