Fred

San Francisco, USA

3699
590
5

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

My Posts

Latest Posts

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Thanks Jacques! I wondered how it would affect performance as your code must have to go through the entire DB and figure out how every field is related to every other field.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Hours result from appointment field
Thank you for the kind words. I do take into account a "lunch period" with Lines 3 - 10. But if it is consistent 1 hour for you then a simple step2 -1 can also work.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hours result from appointment field
Looks like you have two date/time fields (Day Start and Day End), so let us work with what you have. You can try something like: let step1 := number('DAY END' - 'DAY START'); let step2 :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Gruppierungen in einer Tabelle berechnen
Google Translation: Wie hängen diese beiden Tabellen (Rechnungen und Kosten) zusammen? In welcher Tabelle befindet sich dieses Formelfeld? Ich bin mir nicht sicher,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Close to giving up on Ninox
Yeah, now the iOS version is even further behind as some v3.6 features still haven't been implemented.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: New Version 3.7 - 2 things that irritate me.
I hear about a new print engine, but with 3.7 announced and no mention I would think that we won't see it for another quarter or so. 3.6 came out 3 months ago. 3.5 - 10 months. 3.4 - 1 year.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Add existing records to table automatically
Can you post your code for the view element?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Rafael That would be nice. One of my favorite vacations was to your beautiful country. I was last in Madrid in 2001. We spent most of it in the south in La Herradura,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Rafael said: ok for now in the screenshot you saw two Real Dates ready FechaR3 3Aug and FechaR4 20Aug, on _CONTROL_PANEL saw the two Dates but need the Document Name and Code Once you have the link…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Rafael said: I have Reference form CONTROL_TABLE to DOCUMENTOS 1:N Ok, then the next issue is the direction. It sounds like you created the link in Documentos to CONTROL_TABLE,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Close to giving up on Ninox
For me I use the MacOS app and only for personal reasons so the nagging issues are something I put up with. The price and availability for MacOS is the main reason I use Ninox.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Rafael said: I have Problem on line 29 (Field not found months at line 29 column 19 Sounds like CONTROL_TABLE is not linked to Documentos, so then you have to use a select command.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
Since the date fields are all in one record it took me some time to figure out how to check them. So I came up with this button code that goes in the main table (I think Documentos for you.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
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

1 105 106 107 108 109 148

Welcome to the Ninox community

Fred

My Posts

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Hours result from appointment field

Re: Hours result from appointment field

Re: Gruppierungen in einer Tabelle berechnen

Re: Close to giving up on Ninox

Re: New Version 3.7 - 2 things that irritate me.

Re: Add existing records to table automatically

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Close to giving up on Ninox

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

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

Overview