Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

Re: Cascading Selection Fields with a twist
Well that is tricky. Once you are in the Dynamic choice filed you lose all ability to track the current record you are on in the Contracts table (something that many have asked for).…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Cascading Selection Fields with a twist
In my testing if I write (where I'm in Table2 and I create a Dynamic Multi-Choice field to Table1. Then I change the value name formula where Choice is a simple choice field in Table4): let x :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Cascading Selection Fields with a twist
Just to be sure I'm understanding the question. You have a dynamic choice field that is pointing to the Selections table. In the dynamic value name part you want to condition it to show a field from…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Very slow opening table
Yes, it is always the select statement. There are ways to minimize those and still get calculations done. I have a sport league so stats are the basis of any sports,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
Charts are not my thing so I don't think I can help out too much. I tried creating a formula that does something similar where you create the records in a table then use the same table to populate…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
Can you post the code you are working from?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Time interval use and sum
Playing around you can do the following as well: let XContOre := number('Lunedì' + 'Martedì' + 'Mercoledì' + 'Giovedì' + 'Venerdì' + Sabato + Domenica); format(time(XContOre), "hh:…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
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
- 155
- 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

1 114 115 116 117 118 150

Welcome to the Ninox community

Fred

My Posts

Re: Cascading Selection Fields with a twist

Re: Cascading Selection Fields with a twist

Re: Cascading Selection Fields with a twist

Re: Very slow opening table

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: Time interval use and sum

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()

Overview