Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: Compound filter for a view
Maybe something like: do as server let t := this; select Sales where 'Sale Date' >= t.'StartDate' and 'Sale Date' <= t.'endDate' and (var c := Customers; count(numbers(t.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Compound filter for a view
Is Customers a N:1 reference field in Sales? You can only select 1 customer for each Sales records?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Constraints issue
My wee brain is having a hard time following the structure with just words. Can you post a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export .csv to excel not work
There is an issue with Export to Ninox on the MacOS so there might be just issues all around with export. There are issues with Pages in MacOS with local/iCloud storage.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
@Dave Irving nothing got returned because you didn't tell Ninox to express the variable. You just created one. Notice the void at the end. Just put xStatus at the end.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
@Dave Irving For yes/no, it is best to use 1 for yes. let xText := switch 'Text Response' do case 1: 10 end;
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
you don't need number() just putting a number without quotes is a number. To make things easier, the Open Email and Text Response checks should be in the Chronos table.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
One way is the generous use of switch commands. For the Status you can do something like: let xStatus := switch Status do case 2: 50 case 12: 25 end For the chrono subrecords,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Build a Report Advice
The DB doesn't look like your pictures, but I think the basics are there. In the Stats - Overall table: 1) I changed the names of the Total Leads and Total Active Leads formula fields by adding "old"…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech You are very welcome. When you get a chance please mark the post answered. Thanks,
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Build a Report Advice
I don't know the structure of your reports so I can't say if you can get away with just a select and a create function. Or if you will need a for loop or two in there.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Build a Report Advice
@Dave Irving said: then than upon click it will create a new record for that corresponding report I'm not sure why you need a new record created for a report?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Workspace ! Not being recovered where images are held & deleted.
@Haavard Hjorteland said: Is there a way to get rid of this background Image? If i just reupload a small tiny Image I'm afraid the old one is still added to my auto backups?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: 3.10.10 calendar not synching with Apple calendar
I haven’t tried it but I wouldn’t be surprised. Email support to get it logged.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
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

1 55 56 57 58 59 145

Welcome to the Ninox community

Fred

My Posts

Re: Compound filter for a view

Re: Compound filter for a view

Re: Constraints issue

Re: Export .csv to excel not work

Re: Lead Scoring Assistance

Re: Lead Scoring Assistance

Re: Lead Scoring Assistance

Re: Lead Scoring Assistance

Re: Build a Report Advice

Re: Account flows

Re: Build a Report Advice

Re: Build a Report Advice

Re: Workspace ! Not being recovered where images are held & deleted.

Re: 3.10.10 calendar not synching with Apple calendar

Re: Using triggers for yes/no field

Re: Using triggers for yes/no field

Re: Account flows

Re: Account flows

Re: Using triggers for yes/no field

Re: Using triggers for yes/no field

Re: Using triggers for yes/no field

Re: Account flows

Re: Account flows

Re: Workspace ! Not being recovered where images are held & deleted.

Re: Using triggers for yes/no field

Overview