Fred

San Francisco, USA

3366
532
4

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

My Posts

Latest Posts

Re: SELECT with where doesn't work where [] does
Tried a couple of things and found that this works: let catNum := numbers('Category Filter'); select Expense where contains(catNum, number('Expense Category')) Seems like the app does not like text…
- Fred
- yesterday
- 2
- Get help
- Reported - view
Re: Inconsistency with 'Readable If' and 'Writable If'
Have you email Ninox support? I tried with a Yes/No field in another table and had no issues using just the name or = true or = 1.
- Fred
- yesterday
- Get help
- Reported - view
Re: SELECT with where doesn't work where [] does
@Luis Yes, I am able to reproduce the issue. On a local DB with the MacOS app, the where just finds all records while the square brackets find according to the selection.…
- Fred
- yesterday
- 1
- Get help
- Reported - view
Re: SELECT with where doesn't work where [] does
Can you upload a sample DB so we can take a look at it?
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Performance Issues on Ninox – Has Anyone Experienced This?
One thing that caught me out in the beginning is creating formulas and displaying them in the table view. If you can imagine doing that with your Financial table,…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Chart with "where" on subtable
To verify, you have a Page that has some fields that allows user to select a Month. On the page is a view element. Now you want the columns in the view element to be modified by data in the Page.…
- Fred
- 5 days ago
- Get help
- Reported - view
Re: v3.15 presentation
@Rafael Thanks, the Tuesday support team said that it wasn't going to be posted.
- Fred
- 5 days ago
- Learn and Share
- Reported - view
Re: v3.15 presentation
@Rafael said: A number of enhancements improve functionality, performance, and usability based on user feedback. This is what I want to hear more of.
- Fred
- 7 days ago
- 1
- Learn and Share
- Reported - view
v3.15 presentation

Hi all - Don't know who will be attending the v3.15 presentation on Thursday, but it is too early in the morning for me, 5am. If you are attending please consider spending a few moments after posting…
- Fred
- 7 days ago
- 7replies
- 83
- Learn and Share
Re: Issue with true value stored in number field
just noticed that round() has a bug and that it is confirmed by Ninox in their seminar. If you code round(9.405,2) it rounds to 9.4 not 9.41.
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Issue with true value stored in number field
@Mel Charles Happy New Years to you too.
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Issue with true value stored in number field
@Mel Charles said: if Qty > 0 then Qty * round ('Sell Price',2) end round() does not only affect what is displayed. If you use round() then that is the data that is stored.…
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Output format doesn't work for me
@Rafael What is your response to@John Halls question?
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Issue with true value stored in number field
Have you tried the round() command? So if you use the Mkup field in a formula you would do something like: 'Cost Price' * round(Mkup,2) or round('Cost Price' * Mkup, 2)
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Output format doesn't work for me
What kind of data is Total Hrs?
- Fred
- 7 days ago
- Get help
- Reported - view
Re: Location field & Google Maps issue
Can you use the mapping part of@Sotirios Zormpas Dashboard components?
- Fred
- 10 days ago
- Learn and Share
- Reported - view
Manual Restore of Entire Database, Table by Table

I download a copy of my DB in Ninox format and as a XLSX file every month (just in case Ninox disappears or I decide on another platform). I decided to test a manual restore of my database.…
- Fred
- 11 days ago
- 1reply
- 27
- Learn and Share
Re: Different color for field of text
check out the following posts: 1 2
- Fred
- 12 days ago
- Get help
- Reported - view
Re: Issues with sorting in an overview of linked fields from another table
@Edwin Thier When you get a chance please mark the post "answered".
- Fred
- 13 days ago
- Get help
- Reported - view
Re: Issues with sorting in an overview of linked fields from another table
if you put text() around the dynamic choice in the formula for the column then it will sort properly. Before: After:
- Fred
- 13 days ago
- Get help
- Reported - view
Re: Word Template Problem
@Rafael Have you tried creating a row at the end that has vTotal in it?
- Fred
- 13 days ago
- Get help
- Reported - view
Re: Word Template Problem
Here is an example from Carbone.
Attachments
- Fred
- 13 days ago
- Get help
- Reported - view
Re: file in .xlm format
@Vera Lelli have you tried formatXML
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Create a custom component in Ninox
@Vermaji Sadly there isn't anything put together that covers what you ask. You can check out this post by @Sotirios Zormpas to see what can be accomplished.…
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: file in .xlm format
Contact support and ask about their new eInvoice support .
- Fred
- 2 wk ago
- Get help
- Reported - view

1 2 3 4 5 135

Welcome to the Ninox community

Fred

My Posts

Re: SELECT with where doesn't work where [] does

Re: Inconsistency with 'Readable If' and 'Writable If'

Re: SELECT with where doesn't work where [] does

Re: SELECT with where doesn't work where [] does

Re: Performance Issues on Ninox – Has Anyone Experienced This?

Re: Chart with "where" on subtable

Re: v3.15 presentation

Re: v3.15 presentation

Re: Issue with true value stored in number field

Re: Issue with true value stored in number field

Re: Issue with true value stored in number field

Re: Output format doesn't work for me

Re: Issue with true value stored in number field

Re: Output format doesn't work for me

Re: Location field & Google Maps issue

Re: Different color for field of text

Re: Issues with sorting in an overview of linked fields from another table

Re: Issues with sorting in an overview of linked fields from another table

Re: Word Template Problem

Re: Word Template Problem

Re: file in .xlm format

Re: Create a custom component in Ninox

Re: file in .xlm format

Overview