Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3602
566
5

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

My Posts

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 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

1 133 134 135 136 137 145

Back to top

Overview

View all topics