Fred

San Francisco, USA

3380
533
4

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

My Posts

Latest Posts

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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 mths ago
- Get help
- Reported - view
Re: Dynamic Print Help
@Rafael can you post a sample of your JSON results?
- Fred
- 6 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
- 6 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
- 6 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
- 6 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Vermaji I understand what you are being asked to do. I'm pointing you in a direction that it can be done. The user doesn't need to see the raw tables. The user just needs to be presented with the…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Vermaji You still can not modify the style of text/number fields either as a default or through code. I don't see why they haven't added the ability to set the style of a text/number field manually.…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Print and Delete buttons are not active
You can't print from the Table View. You could create a dashboard for the owner where they can set the parameters then print the records they need.
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD Do you want Daily Estimations linked to GM TABLES? You have it setup to be N:1 from Daily Estimations to GM TABLES. It would work better if it was switched,…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD In your workflow, do you always create hourly estimates for all tables? do you want the ability to select the tables you want to create hourly estimates for?…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
Take a look at the attached DB. It will open to a dashboard. You can play around with the selecting a GM TABLE record then a table record then you can click on Create Hourly Estimate and see that it…
Attachment
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
Are GM TABLE records differentiated by Date? So there is only 1 record in GM TABLE for each day? Your Daily Estimation table seems a bit redundant if your GM TABLE is also daily.…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: let d := format(Date, "DD.MM.YY"); (select 'Table2')[format(Date, "DD.MM.YY") = d].number if ш use this formula, having previously created the 'Date' fields,…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: I created a new field, I thought to add a button, but it creates a record, but when I open a new day, it is empty. I'm looking at the new DB you uploaded and I can't find any other…
- Fred
- 6 mths ago
- Get help
- Reported - view

1 17 18 19 20 21 136

Welcome to the Ninox community

Fred

My Posts

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

Re: Filter records help please

Re: Dynamic Print Help

Re: Dynamic Print Help

Re: Dynamic Print Help

Re: How to change the alignment of a button of an alert

Re: Print and Delete buttons are not active

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: Print and Delete buttons are not active

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Overview