Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
3130
477
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: No duplicate absent…
My first question: are you able to tell which record of each familie group is the principal and which are duplicates? If so then please let us know what field is used to tell the records apart.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: No duplicate absent…
I was thinking that wouldn't it be easier for you to just manually set the "principal" record for each familie? How many could that be? Especially if it is the first time you enter a record for that…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: No duplicate absent…
IsDuplicate Familie is a formula field so you can't put data into it.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: No duplicate absent…
It looks like the code is working to me. Lines 23-25 they all have the same Familie so they would all show up as duplicate. Lines 29-31 look to be singular record with that famiilie so they show up…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Showing dialog in trigger after update-event
If you are using the web version then that is by design. Dialog don't show when not used in a button. What I've been told is because triggers happen server side so the server just ignores them.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: data export to excel 05-01 needs to stay 05-01 but ecel shows it as 5th Jan!
This is more an Excel issue not an Ninox issue. You will need to search the web about how to tell Excel to stop treating a number like a date.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Ninox database not showing on iMac following reinstall of OS
You have linked the same icloud account on your iMac as it is on your MacBook. If you have then I would email ninox support@ninox.com.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Ninox database not showing on iMac following reinstall of OS
Are you talking about Ninox Cloud or iCloud databases?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Ok, so we know it works in a new DB. Now you need to figure out why it is not working in your main DB. Start simple with just: if 'Trés petite taille' = "X" if that works, then switch to:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Is it possible to have red colour for number fields?
It does seem like a big oversight not to be able to format number like text. @phillipsloper, you don't have to change your other number fields or any of your calculations you can just use the new…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two search in a base
the formula is still looking for lowercase "x" and the data is using uppercase "X". Please make sure you double check that what you are looking for actually exists in your data.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Great! Now one more of the formula you put in Petite taille et Trés petite taille
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Can you put up screenshots of your new DB that match what I put up?
Fred
Fred
3 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
Fred
3 yrs ago
Get help
Reported - view
Re: Two search in a base
Like John this is what I get:
Fred
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 yrs ago
Get help
Reported - view
1
114
115
116
117
118
126
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics