Fred

San Francisco, USA

3614
569
5

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

My Posts

Latest Posts

Re: Help needed for dynamic print function
@Johanna Schmidt Fotografie If you are satisfied with the answer, please mark the post answered when you have a moment.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas One way, if I needed a choice field of all years in a table (i.e. my invoice tables). You could create a static list, but then you have to update it every year.
- Fred
- 7 mths ago
- 1
- Learn and share
- Reported - view
Re: Help needed for dynamic print function
@Johanna Schmidt Fotografie turn off test print.
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: How to filter selection in dynamic choice field according to selection in another choice field.
Can you post a sample DB?
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help needed for dynamic print function
Did you run a test print? Ninox shows you what the template is not the final document filled in with data. You can also see my post about Carbone Studio.…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas said: It looks like you can get the caption by referring to the field name without the text(). Well what do you know. But if you do a debugValueInfo() on a dC or dMC then you get…
- Fred
- 7 mths ago
- Learn and share
- Reported - view
Re: How can I link 2 separate database?
@Pascal P. Now there is do as database for private cloud or on-prem DBs.
- Fred
- 7 mths ago
- Learn and share
- Reported - view
JSON in dynamic fields

So I've been testing out the new JSON in dynamic fields and ran into a few issues. I emailed Ninox and got this response: Thank you for reaching out and for sharing the details about your use of JSON…
- Fred
- 7 mths ago
- 31replies
- 511
- Learn and share
Re: Multiplу Choice - Hide / Show Buttons
@iliper LTD If you don't want to have to remember a year later what 1, or 2 is then you can do: contains(text(MCfield),"WhatsApp")
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Locked out of our private server !
@我是我的我 That is very nice of you to say. Maybe I have too much time on my hands.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: SUBTABLE SHOW AS "FIELD" can't scroll down when it reach it's limit.
Yeah, there are no scrollbars in a reference table when shown as a field and the data overflows the space provided. Never thought to display my tables as a field so I never tried.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Multiplу Choice - Hide / Show Buttons
Is your multiple choice field a simple MC field? If so, let us say WhatsApp = 1, Viber = 2, and Telegram = 3. If so then you can try in the Display, only if for the WhatsApp button:…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Register data in a underlaying child-table
Are the CC and BCC tables built as a many to many (N:N) between E-post and E-postadresse? Also the CC and BCC tables are the many side (N:1) to E-post and E-postadresse, correct?…
- Fred
- 7 mths ago
- Learn and share
- Reported - view
Re: Locked out of our private server !
Ninox doesn't really check the forums. It is surprising that a company that "provides" 99.95% uptime doesn't have tech support over the weekend.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Open a Table using the TableID
Try looking at@UweGroegor great tool and see what he does.
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Open a Table using the TableID
Do you have to use tableID? Have you tried openTable()?
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Register data in a underlaying child-table
Are E-postadresse, CC, and BCC reference fields? I can guess where E-postadresse is linked to but where is CC and BCC linked to? You have variable e & h linked to the same field,…
- Fred
- 8 mths ago
- Learn and share
- Reported - view
Re: Register data in a underlaying child-table
What is the table name this script is running in? Is it in a trigger or button? What is the relationship between the table that the script is in and E-post?…
- Fred
- 8 mths ago
- Learn and share
- Reported - view
Re: Sort and display all times in order.
@我是我的我 said: The current issue is that the local version isn’t working... Yeah, it looks like the app with local stored DB doesn't like using JSON data to build html.…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 said: When I click on a list item, it doesn’t correctly navigate to the corresponding item, oops, sorry, my mistake. I shouldn't have used 'id' for the JSON key name.…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 so I did a bit more poking around to see why your code doesn't work. I copied your code into a text editor, Sublime Text, and I got: Notice all the html code for non breaking space.…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 I don't know what is up. I have: let getTimeRecs := (select Data); let getTime1 := getTimeRecs.Time1; let getTime2 := getTimeRecs.time2; let allTimesSorted := sort(array(getTime1, getTime2));…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 said: I've tried multiple times, but Xstbody indeed doesn't return any data. Am I doing something wrong? 1) for the xstbody formula field, change the debugValueInfo() to:…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 You need the whole bottom part with html(). Take your code posted that was having issues. Then take my part and replace it the top part (matching the lines).
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: Sort and display all times in order.
@我是我的我 I think you uploaded the wrong version. I dont see a 3 in test.
- Fred
- 8 mths ago
- Get help
- Reported - view

1 15 16 17 18 19 145

Welcome to the Ninox community

Fred

My Posts

Re: Help needed for dynamic print function

Re: JSON in dynamic fields

Re: Help needed for dynamic print function

Re: How to filter selection in dynamic choice field according to selection in another choice field.

Re: Help needed for dynamic print function

Re: JSON in dynamic fields

Re: How can I link 2 separate database?

Re: Multiplу Choice - Hide / Show Buttons

Re: Locked out of our private server !

Re: SUBTABLE SHOW AS "FIELD" can't scroll down when it reach it's limit.

Re: Multiplу Choice - Hide / Show Buttons

Re: Register data in a underlaying child-table

Re: Locked out of our private server !

Re: Open a Table using the TableID

Re: Open a Table using the TableID

Re: Register data in a underlaying child-table

Re: Register data in a underlaying child-table

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Re: Sort and display all times in order.

Overview