Fred

San Francisco, USA

3615
570
5

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

My Posts

Latest Posts

Re: Time interval use and sum
Never have really worked with timeinterval before so I'm not sure what it is doing. From what Ninox said about tracking worked hours by recording idle time makes me think it is not as straight…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Suggestions from May 2022
The ability to have different formatting of field based on device. The checkboxes are too small on an iPhone so it would be great if we can make them bigger if the user is on a small device.
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Time interval use and sum
So here is official word from Ninox: Time Interval A Time interval is the time between two points in time. A Time interval is the most precise method to measure time, because several days,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Time interval use and sum
can you post the code you are working with?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
You are welcome.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
In the KPI Activities tab, change the code in field Formula 2 to: sum(COSTO_W.Cost) It is good that Costo_W is a related field.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
According to your picture Actual_Cost_Act looks to be equal to the sum of costs from Costo_W. If that is true then you can do a sum of cost from Costo_W,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List field content using rsort()
@VM said: What I'm trying to achieve is that the field 'Observações:' on the print layout collects all the inputs made in a given field ('Observações') of a table ( 'Folha de ponto') Ok,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
Is the costo_w table on KPI Activities a view element? If so then you would use a similar formula to sum the total of costs for 'Actual_Cost_Act'
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: NINOX Not Working in Web Browser - Windows 10
You should email Ninox support: support@ninox.com
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: SUM COST By CUTOFF_DATE
I'm not sure I understand what the question is. It sounds like you want to have a weekly breakdown of costs. That means you have to have a table that tracks cost by date,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List field content using rsort()
Glad to know that the searches are correct. @VM said: What I'm trying to achieve is to get only the dates corresponding to the days where entries in the field 'Observações' had been made… I'm not…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
I’m talking about adding line numbers in the forum not the app.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a dynamic multi choice field to update
Right, didn't think of changing the input format, or whatever that is called. I'll have to send it to Ninox. Thanks Jacques.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List field content using rsort()
If you put the following code in a formula field do you get the correct record Ids? 'Folha de Ponto'['Data FL_CX'.Data >= myStartDate and 'Data FL_CX'.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a dynamic multi choice field to update
I tried it and it doesn't work. Plus I don't see how the trigger after update can push the correct data into the Dynamic value part of dMC2.
- Fred
- 3 yrs ago
- Get help
- Reported - view
How to get a dynamic multi choice field to update

Hi all - I'm using the MacOS app. So I have this code in the Dynamic value section of a field called dMC2: let prevDMC := numbers(dMC); (select Table1)[(var t := this;…
- Fred
- 3 yrs ago
- 4replies
- 149
- Get help
- Answered
- Answered
Re: List field content using rsort()
Just to clarify a few points: 1) is the field 'Data FL_CX'.Data a date field? if not then what type of field is it? 2) are 'Date start' and 'Date end' date fields?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
For some reason I didn't see the very end of the code. 1) Please turn on line numbers when you Add Code Block. Click on the gear icon when editing the code and put a check next to line number.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
Do you want the 2nd loop to run regardless of the if statement? Then it would look something like: else closeRecord() end; for loop2 in select 'CUTOFF-DATES' do I would think that you should rename…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Format a Formulae Field to Show time
It just tells Ninox to grab the first record in the returned array. There are a few others like: last, sum, count, concat, etc. If you follow the link, look for the second subheading called Arrays.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Format a Formulae Field to Show time
Remember that Ninox always returns an array (even if it is one record) when doing a select. Sometimes Ninox will figure out that you want to return the value in a field,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
Looking at your DB, it seems like you have done a good job with the stock part. Your 'Inventory Herne', 'Inventory Bergkamen', and 'Inventory Beckum' all do what you want.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Formula Problem
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
Building on Lars' comments, you can never get to the 2nd else because the first two ifs cover all possibilities. The first IF covers everything below 1 and the second IF covers everything above 0.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 109 110 111 112 113 145

Welcome to the Ninox community

Fred

My Posts

Re: Time interval use and sum

Re: Suggestions from May 2022

Re: Time interval use and sum

Re: Time interval use and sum

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Re: SUM COST By CUTOFF_DATE

Re: List field content using rsort()

Re: SUM COST By CUTOFF_DATE

Re: NINOX Not Working in Web Browser - Windows 10

Re: SUM COST By CUTOFF_DATE

Re: List field content using rsort()

Re: Concatanate - Two For loop -

Re: How to get a dynamic multi choice field to update

Re: List field content using rsort()

Re: How to get a dynamic multi choice field to update

How to get a dynamic multi choice field to update

Re: List field content using rsort()

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: Format a Formulae Field to Show time

Re: Format a Formulae Field to Show time

Re: POS System ( Sales,Income,Expenses,Stock,Supply)

Re: Formula Problem

Re: Formula Problem

Overview