Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Making a field writable based on a condition
@Vermaji That is so weird. Looks like the Writable if is kind of wonky. If you create a formula field with something similar: if text('To Wallet') = "OTHER" then "YES" else "NO" end it works fine.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Making a field writable based on a condition
@Vermaji can you upload a sample db that isn’t working?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use setItem in a button?
I just tried it again and now it works fine. 😫
- Fred
- 1 yr ago
- Get help
- Reported - view
How to use setItem in a button?

I'm having difficulty using setItem to modify a JSON in a text field with a button. I have a text field called json. It has a simple json object which is created with another button.…
- Fred
- updated 1 yr ago
- 1reply
- 33
- Get help
- Answered
- Answered
Re: Inconsistency with 'Readable If' and 'Writable If'
@S Moore Here is a mock up. Skip the Page. There is two versions. One where each security table that you do a select for has a parent table with only 1 record.…
Attachment
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Inconsistency with 'Readable If' and 'Writable If'
@S Moore I was thinking along the same line, but instead of creating a global variable. You can create a parent table above your security tables. The parent will have only 1 record and all of the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Making a field writable based on a condition
I can confirm that I am able to make toAddress writable/not writable in both public cloud and Mac app with local DB with: text(toWallet) = "Other" toWallet is a simple choice field,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: do as deferred
The solution of using do as deferred was not mine.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sort by Nb Numerical Size
Just remember that JSON data is always treated like text, or technically any. So you have to explicitly convert numbers before using them. In your first example if you don’t use number(Nb),…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Hide multiple elements at once
@Vermaji I'm unsure what you mean by "once place"? For this question, the solution is to modify the Display Only If part of From_Address and Other_Wallet_Address to look at the data from From_Wallet.…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Performance Issues on Ninox – Has Anyone Experienced This?
Take a look at this post. I make a reference at the beginning to how I first tried to do stats and how it ruined my DB. Let us know if you are trying to do something similar and maybe we can help…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Field from newest (sub)record
You can do it in two steps: let maxYear := max(year.year); year[year = maxYear].'Total revenue'
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Hide multiple elements at once
@Vermaji said: Thank you all for the reply, but I am actually looking for a way to hide/unhide multiple elements in runtime based on certain condition/criteria and all of them from the same place so…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Hide multiple elements at once
You have to edit each field's 'Display field only' if at least once to put in the code to do the checking. Now the big question is how to make the checking more flexible.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with a bit of code
if you want to create a booking for each month of the year then you can try something like: let xYear := year('Insert Date'); let xMonth := month('Insert Date'); let xDay := day('Insert Date');…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr ago
- 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
- 1 yr ago
- 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
- 1 yr ago
- 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 7replies
- 110
- 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
- 1 yr ago
- Get help
- Reported - view

1 17 18 19 20 21 154

Welcome to the Ninox community

Fred

Re: Making a field writable based on a condition

Re: Making a field writable based on a condition

Re: How to use setItem in a button?

How to use setItem in a button?

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

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

Re: Making a field writable based on a condition

Re: do as deferred

Re: Sort by Nb Numerical Size

Re: Hide multiple elements at once

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

Re: Field from newest (sub)record

Re: Hide multiple elements at once

Re: Hide multiple elements at once

Re: Help with a bit of code

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

Overview