Fred

San Francisco, USA

3418
539
4

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

My Posts

Latest Posts

Re: Sum of fields for a period of time
@iliper LTD Just a minor change suggestion. Since you need the last record you can get rid of the first() function. let t := this; last((select Table1)[Name = t.Name and 'Date + Time1' <= t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD said: After a couple of minutes we create record in "TABLE1" Name 'aa' and put any number in field Number . After we make an record in "TABLE2" and in text field 'aa'.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to select current register within 'select' function
There is probably a reason that escapes me and sharper minds can tell us why, but Ninox does not like to use 'this' in filtering. You can put 'this' in a variable.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD You are welcome. I got an email yesterday that the Tuesday webinar has been cancelled. Can you post a sample of your db with some records that are inside and some that are outside the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: popupRecord for child record via button
@Carsten Steinmann good to hear. To help others can you post the final code that worked?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sort table by month name in numerical month order?
You need to add the month number in front of the month names. You can create a new formula field and put this in the code: format(my_date, "MM - MMMM") This will put a two digit number in front of…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Sum of fields for a period of time
Your xEnd needs a first() or last() function, like in the xBeg, as well, since you are making an array of Date + Time data from the Credit_fill link. let xBeg := last('Hourly Estimation'.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Global function to work with out all parameters
@Jacques TUR yes it does! thanks again.
- Fred
- 2 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
- 2 yrs ago
- 4replies
- 104
- 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
- 2 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
- 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

1 82 83 84 85 86 137

Welcome to the Ninox community

Fred

My Posts

Re: Sum of fields for a period of time

Re: Sum of fields for a period of time

Re: How to select current register within 'select' function

Re: Sum of fields for a period of time

Re: popupRecord for child record via button

Re: Sort table by month name in numerical month order?

Re: Sum of fields for a period of time

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 []

Overview