Fred

San Francisco, USA

3615
570
5

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

My Posts

Latest Posts

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
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
That is a weird one. I've too tested it on my MacOS app and I can not duplicate the issue. You should probably email support for help with this one.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Small problem with this formula
I'm not sure what table you are starting in. I say this because you say: DataDate := loop1.Date; and I don't know what table the field DataDate is in. Let us walk through your for loop command:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Import csv files with related tables.
From my quick review, there is no way of setting reference field links during the import process. I don't even see the fields as being available. Which means you will have to 1) import the data into…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
@Mike N. said: which is why I asked the question because this is a whole new way of thinking for me. It is a whole new way of thinking for me too. My written description of the process is just as…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
You can try something like this in a formula field: let a := [1, 2, 3]; let b := [2, 4, 5]; let xCntA := a[(var subA := this; count(b[= subA])) > 0]; if cnt(xCntA) = 0 then "True" else "False" end…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
You can do 1 of the following at the very end: step2 or step1[(var r2 := this; count(xTar[= r2])) = 0]; Basically you need to have an array at the end.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view

1 110 111 112 113 114 145

Welcome to the Ninox community

Fred

My Posts

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

Re: Not Displaying Appointments on Mondays???!?!?!?

Re: Small problem with this formula

Re: Import csv files with related tables.

Re: Comparing Multi-Selects

Re: Comparing Multi-Selects

Re: Complex Select statement for View

Overview