Fred

San Francisco, USA

3399
539
4

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

My Posts

Latest Posts

Re: Compound filter for a view
@Sam I would love to but MacOS app 3.10.10 broke the export function and I don’t have a Pro account. What questions do you have?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Account flows
@Erik Ivan Bech @Erik Ivan Bech said: I basically need to create a separate Balance field for each in the ledger table like OpenBalance and ClosedBalance and have a corresponding script that filters…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: I am able to search for a product purchased within a given date range by using another dMC field for products. Do you think it is possible to filter for both at the same time?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Constraints issue
@Alan Cooke said: there are 4 buildings of which I have selected 3. At a later date I want to add the 4th building. When I click Create record and get the list of buildings I only want to see 4 since…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
@Dave Irving The contains() command needs an array/string and a single item to check. With multiple choice (regular or dynamic) you should use the numbers() command and not chosen() command.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Does the 'page' feaure work on tablet devices?
seems like there are quite a few big bugs in the app version of 3.10.10. you should wait, not with baited breath, for the next version.,
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: You are spot on with the second one. They both do the same thing. Is the 2nd one faster?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Alert not working
alert() does not work inside a do as server. You are basically telling Ninox to alert the server.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create a Date showing Day of Week, Month, Day of week
Take a look at the format() function. You would create a formula field with the code.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Constraints issue
@Alan Cooke said: The first part of the constraint limits Buildings to Organisation. What I need is to limit the Buildings to only those not previously selected.…
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 46 47 48 49 50 136

Welcome to the Ninox community

Fred

My Posts

Re: Compound filter for a view

Re: Account flows

Re: Compound filter for a view

Re: Constraints issue

Re: Lead Scoring Assistance

Re: Does the 'page' feaure work on tablet devices?

Re: Compound filter for a view

Re: Alert not working

Re: Create a Date showing Day of Week, Month, Day of week

Re: Constraints issue

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

Overview