Fred

San Francisco, USA

3699
591
5

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

My Posts

Latest Posts

Re: Order by date from text field
I would agree that you need a new formula field that converts the data in the text field into a date format. I hope your data is in a consistent format in the text field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Auto Number by ComboBox
Since you already have an if statement I like to use a switch above it so it looks cleaner. I get lost when there are too many nested if statements. You said Ordered is a choice field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create a new record from a table directed to a specific TAB
There is a issue, at least on the MacOS version, with the openRecord where if the default view does not have the record in the found set then Ninox will not open the record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
How to create a unique list of records

Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
- Fred
- 2 yrs ago
- 12replies
- 1021
- 2
- Learn and share
Re: Auto Number by ComboBox
Is Ordered the name of a choice field or is it a Yes/No field? or Is Ordered a choice in a choice field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: ANOTACION EN PDF
Here is what the docs say: Preview and annotate PDFs View, annotate, add shapes, insert attachments, fill and sign, etc. .pdf files in Ninox with the help of an in-built tool: preview .…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create a new record from a table directed to a specific TAB
Sadly only popupRecord works with tabs: see this doc page.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Filter an array based on a Multichoice using another Multichoice
Looking back at the post that start all of this I realized that Jacques had already answered this question. var a := numbers('Select characteristics'); select Contact where (var b :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: chartanalyses
Can you provide us a bit more detail? Table names Reference field names Field names
- Fred
- 2 yrs ago
- Get help
- Reported - view
No sort/filter in view element in iOS v3.7.8

I just tried to filter a view element (or subtable view) in my iOS devices for an iCloud stored DB and I get no response. Nothing pops up. So I can't even add or hide columns.…
- Fred
- 2 yrs ago
- 4replies
- 84
- Get help
Re: Formula with calculation between two different times
i use the app as well.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula with calculation between two different times
weird. it works for me. can you post a sample of your DB?
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to show all fields at once?
I don't know any other program that automagically creates the views you want with just the fields you need. There is always some manual input into what fields you need to show in any given moment.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How do make a record creation step precompile a table with "Link from?"
Sounds like you have two questions. We will start with just the first one. When I insert a new replacement part I would like the machine already inserted in the intervention on the replacement parts…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to show all fields at once?
For display purposes, I would say that having over 100 fields in one view would make the view unwieldy to use effectively. I would create different views showing different fields.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula with calculation between two different times
Try these changes: if time() > time(9,59) and time() < time(10,59) then "Yes, the hour is in between 10 and 11" else "No" end Check out this post in the Ninox docs for tips on the time function.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Filter an array based on a Multichoice using another Multichoice
Thanks, Jacques. It is nice to know I was on the right track. I wasn't sure if I could do the count in another count.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Filter an array based on a Multichoice using another Multichoice

So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…
- Fred
- 2 yrs ago
- 3replies
- 197
- Get help
- Answered
- Answered
A new version and no release notes, again.

Just got informed from the Mac App store that there is a new version of Ninox for Mac. It has been upgraded to 3.7.8. But, of course, there is no info about what has changed.…
- Fred
- 2 yrs ago
- 81
- 2
- Learn and share
Re: How to create a field that displays all gigs worked within a range of dates?
@Rafael said: In Dasboard table I place one tab with the name table is a table in HTML look very good but don't know integrates the event_staff_join to see the staff Name, is possible ?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
@Thomas said: Well if I do: let a := (select table_A where bakery = "" or bakery = null); let b := (select table_B); let c := a[(var t := this; count(b[email = t.email and telefon = t.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
oops forgot that part. sadly Ninox won’t display the results with just c since these are the results of a select you need to tell Ninox what to do with the results so you would have to write…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show form of combined select (or array) logic
So records in A have email and telephone numbers fields to match? You could do something like: let a := select table_A[bakery = null]; let b := select table_B; let c := a[(var t := this;…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR You are a funny man, Jacques. Oh and a pretty good programmer to boot.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: NEW: Dynamic print layouts for public cloud
Sadly it sounds like they will not be making any major changes to their own print engine so for us app users we are left out. :(
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view

1 101 102 103 104 105 148

Welcome to the Ninox community

Fred

My Posts

Re: Order by date from text field

Re: Auto Number by ComboBox

Re: Create a new record from a table directed to a specific TAB

Re: Auto Number by ComboBox

Re: ANOTACION EN PDF

Re: Create a new record from a table directed to a specific TAB

Re: Filter an array based on a Multichoice using another Multichoice

Re: chartanalyses

No sort/filter in view element in iOS v3.7.8

Re: Formula with calculation between two different times

Re: Formula with calculation between two different times

Re: How to show all fields at once?

Re: How do make a record creation step precompile a table with "Link from?"

Re: How to show all fields at once?

Re: Formula with calculation between two different times

Re: Filter an array based on a Multichoice using another Multichoice

Filter an array based on a Multichoice using another Multichoice

Re: How to create a field that displays all gigs worked within a range of dates?

Re: Show form of combined select (or array) logic

Re: Show form of combined select (or array) logic

Re: Show form of combined select (or array) logic

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: NEW: Dynamic print layouts for public cloud

Overview