Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Renaming part of title attachment
Looking at the starting post, you have the field 'Interne Nr.' Is that a user editable field? If not then you can try the following in your Titel formula: let x :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
You are close. Can you give me the code for the formula for the Titel field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: popupRecord for child record via button
That is weird. It works for me. I am on the MacOS app, but that shouldn't matter. let selDC := number(dMCTable2); let iDC := item(Table22, selDC); popupRecord(iDC,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas said: Unfortunately it gives me an error. I guess it could be because the content of the "title" field is generated by a formula That is your problem.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: v3.7.11 on MacOS does not like Ninext
@Jacques TUR well upgrading to 3.7.12 fixed the issue. It was not available to me yesterday but now it is today.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Global function to work with out all parameters
@Jacques TUR yes it does! thanks again.
- Fred
- 3 yrs ago
- Get help
- Reported - view
v3.7.11 on MacOS does not like Ninext

Hi all - Anyone else having issues loading @Jacques TUR Ninext with the latest version on MacOS? I just upgraded, always while holding my breath, and when I open a DB with Ninext I get:…
- Fred
- 3 yrs ago
- 4replies
- 117
- Get help
- Answered
- Answered
Re: Sum of fields for a period of time
@iliper LTD But you didn't answer my question. Is it a date field or a date/time field? I ask because now you are talking about time and if the Date field is a date field then there is no time to…
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Hours accumulated
duplicate post with different Subject line.
- Fred
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 12replies
- 442
- 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 98 99 100 101 102 153

Welcome to the Ninox community

Fred

Re: Renaming part of title attachment

Re: Renaming part of title attachment

Re: popupRecord for child record via button

Re: Renaming part of title attachment

Re: v3.7.11 on MacOS does not like Ninext

Re: Global function to work with out all parameters

v3.7.11 on MacOS does not like Ninext

Re: Sum of fields for a period of time

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?

Overview