Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 161
- 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
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
the DB is locked. Can you upload an unlocked version?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
We have given you some suggestions with the stock issue. Have you tried any of the suggestions? If this is a test DB, can you upload a copy of the DB to this post so we can take a look at it?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: When to use "do as server"?
If you look at table ABC do you see a record with Id of 45? It looks like you only had 9 records at the start and then you added 34 records? I did the following in the MacOS app: let c :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: (Invalid)
one way is to put an if statement in front: if denominatorfieldname != null then current formula end If you are doing division then you can check to see if the denominator field is not null.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 117 118 119 120 121 153

Welcome to the Ninox community

Fred

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

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

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

Re: When to use "do as server"?

Re: (Invalid)

Overview