Fred

San Francisco, USA

3528
551
4

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

My Posts

Latest Posts

Re: Global function to work with out all parameters
@Jacques TUR said: Does it work when you call teamAvP with void in the cName parameter? cName doesn't work if I hard code text(void), but since the data comes from a reference field it seems to work…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Global function to work with out all parameters
@Jacques TUR said: Can you tell me more so I know where to look? Ok, so I have this global function: function teamAvP(tID : number,yNum : number,cName : text,rType :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
Is the field Date from the Credit_fill table a date field or a date/time field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Global function to work with out all parameters
Yes, sorry for letting the code run long. What else should I put if not text(void). It works for cName just not rType.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
I just realized you have a first in there. Which doesn't make sense since you want to sum a collection of records. sum(first((select Credit_fill)[Date >= xBeg and Date <= xEnd] [Date = t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD said: sum(first((select Credit_fill)[Date >= xBeg and Date <= xEnd] [Date = t.Date and 'Table Name' = t.'Table Name'].CREDIT)) what is second set of [ ] for?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of "Hours" up to "todays hours"
@raisla67 said: Could you recommend me a book to learn programming for Ninox? Sadly, there isn't a book about Ninox programming. I found these videos very helpful. Look for the Ninox Learning videos.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Sum of "Hours" up to "todays hours"
@raisla67 said: data types are: Date for Date Time for Time of use Text for Registration Don't know if it is too late, but may I recommend using a number field for Time.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Global function to work with out all parameters
Ok, how does one do a null in a text field? I have this global function: function teamAvP(tID : number,yNum : number,cName : text,rType : text) do avg((select Results)[TeamID = tID and (yNum = void…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Select using []
@Alan Cooke said: And that is what I did. I had simply forgotten that Work Reports was a child of Tasks Sorry, Alan, if I came across as scolding. I forget my structure all the time.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Select using []
@Alan Cooke said: Projects has a sub table Tasks which has a child Work Reports. Reason being that Work Reports are technically based on a task which in turn is based on an overall project.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Hours accumulated
duplicate post with different Subject line.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of "Hours" up to "todays hours"
Please tell us the names and type of fields you are using.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Select using []
Just to verify, your screenshot is of fields in the Projects table? @Alan Cooke said: In the scrren shot below you can see Projects (formula) in the Projects form and below the View of the related…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Global function to work with out all parameters

Is it possible to have a global function that works with out having all parameters defined? Right now I can't see a way, but I'm just diving into global functions.…
- Fred
- 2 yrs ago
- 12replies
- 370
- Get help
- Answered
- Answered
Re: Very simple excel formula not translating across to Ninox... what am i doing wrong?
Ninox doesn't do %. Unless they've added that feature. I haven't checked recently. So if 'Assumed shop margin' is a decimal then: RRP * (1 - 'Assumed shop margin') or if 'Assumed shop margin' is an…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Very simple excel formula not translating across to Ninox... what am i doing wrong?
Please post your the code you have written so far.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Is it possible to run the script in a button from another script?
Sadly you can’t activate buttons from a script. Unless this is a hidden feature that@Jacques TUR hasn’t found yet. You will have to copy and paste the code from the other 5 buttons into the 6th…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
@iliper LTD That is very nice of you to say, but a miracle it is not. I’m glad it is working for you.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Button to make record
@iliper LTD it is the name of field in CASH DESK that points to List of Players. That is the name in your sample DB, you need to match the name in your version if that is not the name.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
Here is what I changed for the Cash In button: let xCurrRec := this; let DRselect := (select 'Daily Result')['List of Players' = xCurrRec.'LIST OF PLAYERS' and Date = xCurrRec.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
@iliper LTD said: Yes, probably so, but I'm not a programmer and I don't know how to do it. If you give me a full way how to do it, we will be happy Fred said:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: View not showing top line on update
@Kent Signorini If all she does it data entry then the iPad works fine. From a developer point of view the iOS version still doesn’t have the autofill feature when you are writing code.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: View not showing top line on update
@Mel Charles yeah, I try not to hold my breath every time i upgrade.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninox Mac app now free
i haven’t gotten it. i hope this means they are slowing dropping proper support. iOS is still not feature equal to even MacOS, let alone Cloud.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view

1 87 88 89 90 91 142

Welcome to the Ninox community

Fred

My Posts

Re: Global function to work with out all parameters

Re: Global function to work with out all parameters

Re: Sum of fields for a period of time

Re: Global function to work with out all parameters

Re: Sum of fields for a period of time

Re: Sum of fields for a period of time

Re: Sum of "Hours" up to "todays hours"

Re: Sum of "Hours" up to "todays hours"

Re: Global function to work with out all parameters

Re: Select using []

Re: Select using []

Re: Hours accumulated

Re: Sum of "Hours" up to "todays hours"

Re: Select using []

Global function to work with out all parameters

Re: Very simple excel formula not translating across to Ninox... what am i doing wrong?

Re: Very simple excel formula not translating across to Ninox... what am i doing wrong?

Re: Is it possible to run the script in a button from another script?

Re: Button to make record

Re: Button to make record

Re: Button to make record

Re: Button to make record

Re: View not showing top line on update

Re: View not showing top line on update

Re: Ninox Mac app now free

Overview