Skip to main content
Forum
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
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3901
posts
630
likes received
5
followers
Badges
Latest Posts
Re: Parent / Child / Grandchild
You can create a view element in Projekte and in the formula you can put: Arbeitsauftrage.Reparaturen and this view will show you all records from Reparaturen that is related to Projekte through…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Dynamic Choice as table list/View column
For background, both dynamic choice fields are pointing to the same table (Table1). So I went back and selected the same choice for both but had a different text display in each and I encountered…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Dynamic Choice as table list/View column
I tried it on my Mac app and was not able to duplicate. I have this code: if Name = "Glenn" then dChoice else DC1 end dChoice and DC1 are dynamic choice fields that just happen to point to the same…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
That is great. If you are comfortable, please share the code so we can all learn from your successes.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Track selection of Dynamic Multiple Choice field
What if your dynamic multiple choice field is from a third table? Here is your answer. Open TableA and you can see two dynamic multiple choice fields (dMC and dMCJ).…
Attachment
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Date suddenly wrong
Have you turned on time zone independent date?
Fred
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 yrs ago
Get help
Reported - view
Re: Code the top search - Help
@Jarno Vande Walle can you post a sample of your db?
Fred
Fred
3 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
Fred
3 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
Fred
3 yrs ago
Get help
Reported - view
1
114
115
116
117
118
157
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
