Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Need Help to create a History Control Table
Can you try creating the code in a button that creates a new record in the control table and copies the correct data? That would be a good start. When that works then we can move on to the next step.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
Do you have sample of the code you have created already?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Sam said: Could you please show the corresponding codes for each formula field that you floated ? thanks Ask and you shall receive! Here is what the code looks like as part of a formula field that…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: table numbers
Hi there - @M. Thérèse Audooren said: I have a reference to a table (1 : N) where all the relevant records are displayed. Are you talking about the view of the reference field in your main table? @M.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Select multiple value in linked table
Hi Mauro - Let me see if I understand the structure. You have the following tables: car model (i.e. Audi eTron, Toyota Camry, Kia EV6) components (headlights, cam shaft,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Learn and share
- Reported - view
Re: Date suddenly wrong
Have you turned on time zone independent date?
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view

1 110 111 112 113 114 153

Welcome to the Ninox community

Fred

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: MultiLine Text field with multiple rows alongside in form

Re: table numbers

Re: Select multiple value in linked table

Re: MultiLine Text field with multiple rows alongside in form

Re: is there a formula to disconnect the link field to a table ?

Re: List of years/months/weeks...

Re: Parent / Child / Grandchild

Re: is there a formula to disconnect the link field to a table ?

Re: Parent / Child / Grandchild

Re: Dynamic Choice as table list/View column

Re: Dynamic Choice as table list/View column

Re: Dynamic Choice from Dynamic Multi Choice

Re: Track selection of Dynamic Multiple Choice field

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

Overview