Fred's Profile | Ninox community

Badges

Latest Posts

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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Extract color or icon from styled field/var
@Vermaji see my response in your other post.
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Ninox forgetting entries
Are you in the cloud or local storage? I notice that in the cloud you can not check/uncheck dynamic multiple choice fields quickly. It takes the browser a second to register the click.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Vermaji When I troubleshoot a line that has many components to it. I strip it back and see where it problem is. So I would start with: let orderTotalAmount :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Styled number field maintaining it numerical?
@Sotirios Zormpas I don't think that is what the post is about. It asks to style a number while keeping it a number. Since the numbers are shown to be left aligned it has been turned into text.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Date field does not remain empty
@Leo Woer sadly once it is enabled you can't go back. so if you have an old DB then it will be ok, but any new ones will have it enabled. But didn't you say you created a new DB and it didn't have…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Files and File Links on Google Drive
Here is what you can do with Make in Google Drive.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date field does not remain empty
@Leo Woer I forgot that Ninox implemented Timezone Independent date awhile back. The iCloud DB that I have no issue does not have this feature turned on.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox data schema
@Jacques TUR I love it! Just a couple of thoughts. 1) with the little square dots in the upper right corner of each table, does that mean we can move the table around?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
This post explains why you can't use styled() data directly. It seems kinda convoluted but I was able to get this to work: Formula 2 is a field that sums then applies a style: let x :…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Change a field alignment in script
There is a style section for formula fields and you can set alignment. Is that what you want?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date field does not remain empty
@Leo Woer Well I tried: In a local DB and with a button that sets the Date field to be null, it still shows the Jan 1, 1970 date. In an iCloud DB, with a button that uses Date :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date field does not remain empty
@Leo Woer When you say declare it false do you actually use the word false? Have you tried null?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date field does not remain empty
@Leo Woer I still see the problem v3.12.8. Again only on local DBs, I don't have this problem with iCloud stored DBs.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: urlOf(this) won't work in iPhone App
@Shawn Bishop I would email Support and see what they say.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: urlOf(this) won't work in iPhone App
What version of the app are they running? I tested in v3.12.8 on my iPhone and the formula field with the urlOf() code does not show anything. There is the field name but no data.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month
@Sam VillanoThe code @John Halls wrote that begins with function goes into the Global Function. 1) open your DB 2) go to admin mode 3) click on Options 4) under Global functions paste the code 5)…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 38 39 40 41 42 157

Welcome to the Ninox community

Fred

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

Re: Ninox forgetting entries

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

Re: Styled number field maintaining it numerical?

Re: Date field does not remain empty

Re: Files and File Links on Google Drive

Re: Date field does not remain empty

Re: Ninox data schema

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

Re: Change a field alignment in script

Re: Date field does not remain empty

Re: Date field does not remain empty

Re: Date field does not remain empty

Re: urlOf(this) won't work in iPhone App

Re: urlOf(this) won't work in iPhone App

Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Overview