Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3743
594
5

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

My Posts

Latest Posts

Re: Two search in a base
Can you put up screenshots of your new DB that match what I put up?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
I created a fourth record with blanks for the two fields. Then when I filter petites tailles et très petite taille for X, I get the 3 records that have an X in petites tailles et très petite taille.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Like John this is what I get:
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Well they are text fields. Just to verify that your if is looking for "X" not "x". Your data is showing "X" (captial). If you are still getting nothing then I would suggest that you create a new DB,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Please show us the Edit Fields window for Petite taille and Trés petite taille.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Thanks for the clarification. Now for a bit more troubleshooting: You said when you put a 1 in Trés petite taille and changed Petite taille et Tres petite taille to:…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Find a record that has both or just put an "x" in both fields and see what happens.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
I have not seen any record with both Trés petite taille and Petite taille marked with an "x" so I don't think anything is wrong. Can you confirm that you have records with x's in both fields?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Did you change the formula in petite taille et trés petite taille to look for 1? if 'Trés petite taille' = 1 then 1 end then you can filter petite taille et trés petite taille to filter for 1
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Ok now you have to investigate the data. 1) what kind of field is Trés petite taille? 2) if you put a 1 in one of the records and switch the formula to look for 1 does it mark it properly?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
you are welcome. Good luck with FM. I just could not justify the price.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox App is Crashing on my iMac
I don't have anything to say when the software crashes. If you can use it a browser then I would use that until Ninox gets back to you. .
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Remember that equal is case sensitive. From your screenshots it looks like you have "X" (capitol) in your data, but you are searching for "x" (lowercase) in your formula.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Syncing
If you bought the desktop app then you don't need the cloud account to use it. If you want to sync between your desktop and your iPad then you need to make sure you saved your DB in iCloud not local.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
I thought you wanted an x in Trés petite taille et Petite taille if there is an x in both Trés petite taille AND Petite taille. Is that not true? Or do you want an x in Trés petite taille et Petite…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Date in Formula
Hi Jon - Welcome to world of poorly written manuals of Ninox. What you should write is: if days(Date, today()) > 365 then "long"else "short"end We use a special function called "days" where it finds…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
You can't try ="x, but I suspect that you don't have any data that has an x in both fields. Can you find, or make, a record that does and see what the new field says?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to import local database from external HDD?
You should email tech support at support@ninox.com
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
The picture from May 30 10:17pm doesn't change the formula field into a text field. What it is showing you is that the data in the field is text. The field is still a formula field.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
It looks like the formula is working. The records you show do not show "x" in both Trés petite taille and Petite taille so then there is nothing in petits et trés petits.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Please tell us what do you want to happen? what tables are you using? What fields are you using? are you in a record or are you looking at a table view?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Maybe you can tell me exactly what you are trying to do. Your last formula doesn't need an end, if you are just doing a select.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Don't you then do a select like: select Table1 where field1 = "x" and field2 = "x"
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
When you say "cross" are you typing in the letter "x"? Or is this an icon? What kind of fields are they (text, number, etc)?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Impossible to put some pictures in Ninox !
If you can't drop it in, then Ninox probably does not support WEBP format.
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 139 140 141 142 143 150

Back to top

Overview

View all topics