Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

Re: Date suddenly wrong
Have you turned on time zone independent date?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Jacques TUR As always, you are correct. I thought I updated the DB with your changes, but I obviously didn't.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Jacques TUR After some playing around I noticed that your code reorders the selection if I select 3 choices (2,6,4) and then remove the first selection (2), the child table gets reorderd to 4,6.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Text value from dynamic choice field
@UKenGB I would recommend that you submit a ticket with Ninox. Hopefully they will fix it.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Text value from dynamic choice field
I'm able to duplicate it. I'm on v3.6.8 of the MacOS app and v3.6.10 on the iPad.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
I've never seen a filter done after a period like that. That works for you? When I try it out it always returns a count of 1 when it should do 3. This is what works for me:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
I forgot that multiple choice fields are numbered differently than choice fields. You would think that the number shown next to the text is the number you would reference. But it is not that easy.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
Have you seen this? Is Time-Zone independent turn on for your DB? Did you see my questions in my post below? Steven's code does work, for me, so I'm wondering what happens on your end.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
@David Irving Since termination reason (and Risk Level) field is a multiple choice field records can have either 1, 4, or 6 plus any other selection 2,3,5.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
@Bernd Krell You can try this: let Countdown := if 'Perpetual License' then "9999" else days(today(),'End Date') end; let bgColor := if 'Perpetual License' then "Green" else switch true do case…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
@Bernd Krell I'm not sure how the code you posted is related to your question. You can try something like: let newText := if YesNO then "9999" else "Other" end; let bgColor :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle In your Prestaties table create a new formula field, you can call it "schonedatum", and put this in it: date(year(Datum), month(Datum), day(Datum)) Does it return it a date?…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Custom HTML Dashboard
@Alex can u upload one here? not everyone has got access to the webinar.
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Code the top search - Help
It is a weird one. So when I set the BeginDatum and EndDatum to Aug 12 2022 it shows me nothing. The DB you uploaded does not have a record with the ID of 13 in the Prestaties table. But don't worry.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle The DB is locked. Please upload an unlocked one. Also you only have data for August 12. You were having issues with August 13. Please make sure there is enough data to test the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle Can you upload a copy of your DB with sample data so I can see what is going on?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle Thanks for the picture, but since you are asking for troubleshooting on searching, I find it hard to do without looking at the data. Can you make a dummy DB?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle can you post a sample of your db?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Fred milestone - 1,000 posts!
thanks for noticing. i hope i’m helping more than blowing hot air around.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: How to make a query in Ninox
If this is a one time action then I would recommend just importing 1 table into another. You can do this by exporting the data into a csv then import back into 1 table.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Translation button in forum

Just to put it out there in case someone at Ninox sees this. Please add a translation feature to the forum so we can easily communicate between us all without having to switch tabs to a translation…
- Fred
- 2 yrs ago
- 34
- 2
- Learn and share
Re: how to lock a cell at a given value?
take a look at the Invoices template built into Ninox. When you create a new DB it is one of the templates available. We can answer any specific question after you had a look around.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Rafael Sorry I wasn't clear. I mean to get rid of the first command in front of selProv.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Rafael Nothing that I can see is wrong. What happens if you get rid of the first in line 9?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Rafael take a look at the button in AlbumCards. It sounds like you wanted a clean Teams table and then link that to each AlbumCards. So you don't need another AlbumCards table or another Teams table.
Attachment
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 95 96 97 98 99 137

Welcome to the Ninox community

Fred

My Posts

Re: Date suddenly wrong

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Text value from dynamic choice field

Re: Text value from dynamic choice field

Re: Formula to Include Multiple Filters from Choice Fields

Re: Formula to Include Multiple Filters from Choice Fields

Re: Code the top search - Help

Re: Formula to Include Multiple Filters from Choice Fields

Re: Expiration date in colour

Re: Expiration date in colour

Re: Code the top search - Help

Re: Custom HTML Dashboard

Re: Code the top search - Help

Re: Code the top search - Help

Re: Code the top search - Help

Re: Code the top search - Help

Re: Code the top search - Help

Re: Fred milestone - 1,000 posts!

Re: How to make a query in Ninox

Re: how to lock a cell at a given value?

Re: Normalising existing data

Re: Normalising existing data

Re: Normalising existing data

Overview