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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3614
569
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
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
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
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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths 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
Fred
11 mths ago
Get help
Reported - view
Re: Filter records help please
hmm, i thought where is only used in select statements. I couldn't get a where to work in with a reference field. If you are using links then you just use the square brackets.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Dynamic Print Help
Here is what is going on. In your code you have: let vObj := vTbl.{ vDat: format(Date, "DD.MM.YYYY"), vHour: format(From, "hh:mm"), vProj: Projects.'Project Name', vDom: text(Domains), vDatArr:…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Dynamic Print Help
@Rafael can you post a sample of your JSON results?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Dynamic Print Help
what does your JSON look like? can show the doc file used to create the tables?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to change the alignment of a button of an alert
@Sotirios I think the issue is if you accidentially double click you close the window and then create a new record.
Fred
Fred
11 mths ago
1
Get help
Reported - view
Re: Print and Delete buttons are not active
@Vermaji All software comes with their own limitation. You have to learn to live within the current boundaries or find another software that does what you need for this case but may not meet other…
Fred
Fred
11 mths ago
Get help
Reported - view
1
26
27
28
29
30
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
Usage overview
Process monitor
View all topics