Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3400
539
4

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

My Posts

Latest Posts

Re: Using triggers for yes/no field
@Rick Castellini if you learned access then you can pick up Ninox. Like learning a third language. It gets easier the more you know.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Using triggers for yes/no field
@Rick Castellini said: HOWEVER, why doesn't Ninox update ALL records that apply to the code? It only flips my Winner switch when I'm in a particular record.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech Do I need to reply to this or does the other button take care of this?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech said: How is that trigger after update supposed to update the Accounts ledger view? It is on the Trigger after update of the Amount field so after you modify the field the trigger…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using triggers for yes/no field
@Rick Castellini said: Yes, it didn't look possible, but why don't you think it's working in the Winner field itself?? No errors, just sits there. I'm not sure what you mean by "just sits there".…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using triggers for yes/no field
@Rick Castellini to add multiple commands you need to end the previous command with a semi-colon. Ninox processes the commands starting with line 1 and going down.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Using triggers for yes/no field
@Rick Castellini Formula fields can not modify other fields. You will need to find a regular text/number/choice (there are probably a few more) field that you add to Trigger after update,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
I would upload a file, but v3.10.10 broke the Export to Ninox function of the MacOS app. You can put this in a new button in the Accounts table > Ledger tab: let xFund := unique(Ledger.Journal.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech said: How do I filter the records in the button so that Ledger.Fund lookup field value is = “BEB”? Easiest is: BEB = 2. let xLedger := ((Ledger where Journal.Fund = 2)order by Journal.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Workspace ! Not being recovered where images are held & deleted.
@Haavard Hjorteland Well it looks like you are using 3.10.10 of the MacOS app and I was on the old 3.9.x. I just upgraded to 3.10.10 and I too get this problem now. I sure hope they fix this soon.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Using triggers for yes/no field
@Rick Castellini if Status = "Closed" or Status = "Expired" and 'Campaign Premium' > 0 then Winner := "Yes" else Winner := "No" end You need colons in front of the equal if you want to set the field…
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 47 48 49 50 51 136

Back to top

Overview

View all topics