Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3610
568
5

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

My Posts

Latest Posts

Re: Need to Match show rows from a table if email field matches
Please double check the record for 20 Apr 2021, 05:08 to see that the email address is not in either Emailto or EmailFrom.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Link record n:1
Hi Andrea - In your first post you stated that you have a field called FirstTable, so I'm guessing that is the reference field in SecondTable linking it to FirstTable.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Need to Match show rows from a table if email field matches
a bit of background to Fabio's great suggestion: Your code was just missing a way for Ninox to access the current record you are in. Thus the first line of code is to tell Ninox to take the data from…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Link record n:1
What do you mean you want to do it in reverse? If it is a 1:N then wouldn't you always be in your FirstTable and be creating records from there, letting Ninox create the links for you?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: What happens in "Crash"
Wow, that does not sound good. What is the script you are running?
- Fred
- 4 yrs ago
- Get help
- Reported - view
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
- 4 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
- 4 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
- 4 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
- 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

1 133 134 135 136 137 145

Back to top

Overview

View all topics