Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3811
posts
607
likes received
5
followers
Badges
Latest Posts
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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
1
63
64
65
66
67
153
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
