Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and Share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Addinsell
Addinsell
410
1
0
Joined: Tue Jun 30 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
Re: Two search in a base
I already tried with "1" before (see the post higher) and just tried with "h" No result !
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
It's normal : there is a cross for each of one, never the both. Either the bird is "très grande taille" either is "petite taille". I tried to replace "and" by "or" in the code but the issue persists…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Ok. But as you can see there is nothing in the column-formula there is something wrong somewhere. But where ?
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
If you do not put anything in the filter box search area hox can you use the formula ? Anyway here are screenshots showing that the "Petites taille" and "Très petites taille" works well.
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
The first screen shot is the result of the search X in the filter of "Petites tailles et Très petite taille" : there is not cross…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Yes exactly, John What do you enter in the filter box ? X ?
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
It does not work either.
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Yes I already joined a screen shot that I join again where one can see crosses in "trés petite taille", the other one is lower and can't be in the shot.
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Yes it works with 1 with if 'Trés petite taille' = 1 then 1 end So is there an error in the code : if 'Trés petite taille' = "x" and 'Petite taille' = "x" then "x" end ?
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
"Trés petite taille" is a text field
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Hi Fred, Thanks I tried 1 in "petite taille" and "trés petite taille" : when I put it in "petite taille et trés petite taille" in the filter, 1 does not appear…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
I tried : if 'Trés petite taille' = "x" then "x" end It does not work either…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Thanks, but same issue with x in lower case…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Thanks Fred I tried that but same result : no crosses displayed…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Thanks Fred When I enter a X in the filter no X are displayed…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
By the way if the fied was a formula field what I have to enter in the filter area of the column ? x ?
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
I create a new formula field and the same thing happens : when I drag and drop the formula from the right window to the left one the formula becomes a text field !
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Thank you Strange... I just noticed that my formula field "petites tailles et très petite taille" is in a text format in the table view ! I can't no more drag and drop it again because it is no more…
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
I displayed the new field formula "petits et trés petits" : it is empty !
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Addinsell
Addinsell
3 yrs ago
Get help
Reported - view
1
2
3
4
5
17
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics