Fred's Profile | Ninox Community

Badges

Latest Posts

Re: button for Duplicate a record and its links to a sub table
@frsalabert said: I could duplicate a vessel and link its options to an existing offer or to a new one if it is too complicated script to access a dedicated record in the offer table Sounds like you…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Linking imported tables
oops, the code should use first() not unique(). let t := this; let findTable1 := first(select Table1 where Number = t.Number); Table1 := findTable1 and do as server let t := this;…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: file unzip Fail
@svs You can always access cloud DBs through a browser on any platform. The apps are buggy right now. but that will be fixed.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Linking imported tables
Have you already imported the table from FM? If so then you can try something like this in a button in Table2 : Table1 = master, Table2 = subject. The reference field names would be same in the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Compound filter for a view
@Sam You must not have updated your app to 3.10.10. If so then DO NOT UPDATE. 3.10.10 breaks the export. I just tried on my iPhone and it does not work.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: calendar option missing
There are major issues with 3.10.10 app (any). So you will have to hang on and wait for a fix. You should email support just to make sure they know of all bugs.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech You mean export the results of a view element? Not from the export menu item. Since the view element is just a window to other tables and not really in the current table.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 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
- 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
- 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
- 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
- 2 yrs ago
- Get help
- Reported - view

1 63 64 65 66 67 154

Welcome to the Ninox community

Fred

Re: button for Duplicate a record and its links to a sub table

Re: Linking imported tables

Re: file unzip Fail

Re: Linking imported tables

Re: Compound filter for a view

Re: calendar option missing

Re: Account flows

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

Overview