Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula Problem
- Fred
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Colour Coding
I don't use styled very much so I don't know if it can do text on its own. I think I saw somewhere about using HTML to color text, but I can't say for sure.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Colour Coding
Have you looked into Conditional Styling for columns? This is helpful if you only want to see it in a table view. In a table view or view element, if you click on the column name you will see the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically Displaying referenced data based on String
Can you give us a bit of background on your tables? What are your table names? What is the name of the reference fields that link the tables? What is the name of the raw data fields that you will…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: function between two numbers
If you take a look at this post, you will see that you can use arrays in the switch function.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Bruno Skëndaj said: I'm struggling to link them together Are we talking about the Income table and Expenses table? If not then what tables are you talking about?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
This is where the use of reference fields come in. We don't know the names of those fields so you will have to adjust the following formulas. For StockIn (I use mashed up words so I don't have to…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: function between two numbers
You can use a switch function. It is not intuitive but you can do something like: switch true do case number < 5: "result 1" case number >= 5 and number < 7.5: "result 2" case number >= 7.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
Sound like you create a record in your Purchases/Supply table and you want the Stock table to aggregate data from Purchases/Supply. I'm guessing that you have a reference field in Purchases/Supply…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Suggestion List from first crack at Ninox
looks like you are too busy fixing CSS errors for Ninox.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Suggestion List from first crack at Ninox
I too thought it was a new post, but a spam post brought it back up.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Problem with radio Botton on Web version
I am able to duplicate it on the MacOS app on v3.6.0. Just to be clear this only happens on reference fields. Dynamic choice/multi fields show radio buttons fine.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show/Hide One Record
The only way I can think of would be to find a way to just filter out that one record through one of the columns.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Small problem with this formula
Please tell me which table and button/trigger you want to put this formula in? @Rafael said: The Formula works, but no return to the date I change in Table FECHACORTE for loop1 in select…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: ninox database
Are you in a table view? If so make sure you don't have a filter set on a column that filters out the newly created record. Not that I've done this before.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show/Hide One Record
Are you talking about show/hide one record from a list of records in the table view? Or you only want to filter a table view so only one record is show?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 102 103 104 105 106 137

Welcome to the Ninox community

Fred

My Posts

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)

Re: Colour Coding

Re: Colour Coding

Re: Automatically Displaying referenced data based on String

Re: function between two numbers

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

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

Re: function between two numbers

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

Re: Suggestion List from first crack at Ninox

Re: Suggestion List from first crack at Ninox

Re: Problem with radio Botton on Web version

Re: Show/Hide One Record

Re: Small problem with this formula

Re: ninox database

Re: Show/Hide One Record

Overview