Fred

San Francisco, USA

3610
568
5

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

My Posts

Latest Posts

Re: Table architecture with a 3 levels or deeper hierarchy
It can be confusing in Ninox with grandchild tables, because it doesn't show it in the sidebar. It does show it in the data model: Here you can see penaltyAt is 5 levels deep from Leagues.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Ninox 3.13 available
@Mel Charles said: When I double click a cell on a main table - it goes into edit mode as expected. but i no longer see the little form slide in arrow thingy that you could click to exit edit mode…
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Is there any way to reduce the memory space occupied by the image?
You will have to look into an automation platform like Make, Zapier, or Relay. I know there is also a module you can load in Linux that you can run your own, but I don't remember the name.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: italic text
A simple text field can not be formatted by itself. You can create a new formula field that you can then set the style to show the text as italics.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Separating List into Objects
@S Moore said: I would like to convert them to objects, If you are manually typing out the string, you can make things easier by just putting the items into an array.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Ninox 3.13 available
@Vermaji or create a button that sets the relationship to 0.
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Ninox 3.13 available
@Rafael To be fair, they said that this year is all about UI customizations.
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Complex criteria for Select
@Chris Mullett 'this' generally refers to the current record. So I typically use the variable t to store that info. Now I can reference any field that is on that record.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Complex criteria for Select
Do your records in Film also have reference fields to Status, Camera, Film Stock, and Format? That will make filtering/search easier. @Chris Mullett said:…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Record reference numbers
With such a simple reference number, you can just use the Ninox record Id. If you create a new formula field you can put: Id and it will return the record Id.…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Add/Insert record on button click
@Vermaji said: customers is linked to both AccountReceivables and Orders tables separately, so doesn’t that mean that there is an inherent relation between all three tables.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Dynamic height of table view
Christian - Are you talking about the Ninox field size? If so then I don't there is a way to make that dynamic. I could be wrong but I haven't seen a way. I hope to be proven wrong.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren
@Robert D.I uploaded the wrong DB. Sorry. So your Ansicht view element is using: select Work Which will find all Work records regardless of association with the record in storage location.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren
@Robert D. said: I want the view with the table "work" I would recommend that you just follow the relationship back to the Work table. Something like: unique('work material'.'work on buildings'.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Add/Insert record on button click
@Vermaji said: Clarification: What does this signify here? does it refer to the whole table in context or the current record in that table (Orders table)? "this" points to the current record.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Add/Insert record on button click
i’ve found that “this” really only works when in a variable. There are moments that it works inside code but it is too inconsistent to try to remember when.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Extract color or icon from styled field/var
@Vermaji From experience, if you are using the same formula in many locations, you may want to consider creating another formula field that does the bit of code.…
- Fred
- 10 mths ago
- 1
- Learn and share
- Reported - view
Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren
You can reference a field in another table in the View form and view element. If you click on a column then click on Show column, you have a choice of the fields in the table,…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: using Choice in formula tab when trying to create a dashboard
According to your picture, there is no field called choice (the list of fields in the left column) in the table Dashboard.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Vermaji @Jacques TURwrote in the other post: Another solution is to use a non-visible intermediate formula containing only :sum(OrderItems.Subtotal) Then use this value to calculate ‘Order Charges’…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Vermaji I didn't use anything special. I just changed the last line to f so I can see what is being stored in the variable. You should be made aware of the debugValueInfo() command.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Vermaji I don't think it is a question of right/wrong. It is just having to deal with how the styled() function works. That is why I suggested you just do the sum of Order Items.Subtotal again.…
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Sotirios Zormpas It goes all the way back to Order Items.Subtotal as that is formatted with a dollar sign.
- Fred
- 11 mths ago
- Get help
- Reported - view
Re: Extract color or icon from styled field/var
@Vermaji see my response in your other post.
- Fred
- 11 mths ago
- Learn and share
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Vermaji Well then we need to go back further into the code. When we look at the variable 'f' we get: (the values will not match your posts as I choose a random record). {"text":"$30.…
- Fred
- 11 mths ago
- Get help
- Reported - view

1 25 26 27 28 29 145

Welcome to the Ninox community

Fred

My Posts

Re: Table architecture with a 3 levels or deeper hierarchy

Re: Ninox 3.13 available

Re: Is there any way to reduce the memory space occupied by the image?

Re: italic text

Re: Separating List into Objects

Re: Ninox 3.13 available

Re: Ninox 3.13 available

Re: Complex criteria for Select

Re: Complex criteria for Select

Re: Record reference numbers

Re: Add/Insert record on button click

Re: Dynamic height of table view

Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren

Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren

Re: Add/Insert record on button click

Re: Add/Insert record on button click

Re: Extract color or icon from styled field/var

Re: Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren

Re: using Choice in formula tab when trying to create a dashboard

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Extract color or icon from styled field/var

Re: Can't calculate the GST and Balance Pmt formula fields

Overview