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
Plugin apps
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
3831
posts
614
likes received
5
followers
Badges
Latest Posts
Re: MultiLine Text field with multiple rows alongside in form
Awesome @Jacques TUR ! You are the best! Table2 is a reference field that I used to float. Then the fields Formula and Formula 2 now float on the right side.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: is there a formula to disconnect the link field to a table ?
Sorry, haven't done this in awhile. I doubled check and you can use 0.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: List of years/months/weeks...
Here is one possible solution. Put this in the same button: let t := this; let selAllRecs := (select Table4); let multiContractcheck := if count(selAllRecs[User = t.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Parent / Child / Grandchild
Sadly I don't have any tips on printing as I don't print. The print limitation on child tables is very annoying. Ninox says they are revamping the print engine,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: is there a formula to disconnect the link field to a table ?
You can use: referencefieldname := null that will clear out the selection.
Fred
Fred
3 yrs ago
Get help
Reported - view
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
1
111
112
113
114
115
154
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
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
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
