Fred

San Francisco, USA

3614
569
5

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

My Posts

Latest Posts

Re: Ninext project
@Jacques TUR Thanks, but that wasn't what was happening in my picture. I need to get an animated gif maker. :) I was just opening a record and the record view popped out to the left in the table area.…
- Fred
- 4 mths ago
- Learn and share
- Reported - view
Substitutions for ui.popupRecord

Hi all - What are the other solutions to ui.popupRecord? Ninox said back in v3.8 that it, and a bunch of other commands, are being depreciated. Though it hasn't yet.…
- Fred
- 4 mths ago
- 10replies
- 143
- Get help
- Answered
- Answered
Re: Ninext project
@Fred Now it is happening in Chrome (Win).
- Fred
- 4 mths ago
- Learn and share
- Reported - view
Re: Ninext project
Found an issue with 3.15. When I open a record in a table it opens like: I tried another DB and had no issues. Then I took out the Ninext opening script and reopened the DB and all was fine.…
- Fred
- 4 mths ago
- Learn and share
- Reported - view
Re: Ninox 3.15
Congrats to Ninox for actually putting out a bug fix report. Look forward to it to v3.15.
- Fred
- 5 mths ago
- 1
- Learn and share
- Reported - view
Re: How to Track Client Changes in Ninox (Audit Log Table)
Are you doing the data entry in the machine registry table or in a dashboard?
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Problem to add sign + and -
you don't need to repeat the if: let diffValue := number(prep) - number(comparison); let sign := if diffValue > 0 then "+" else "-" end; let myDiff := "" + sign + format(diffValue, "#,##0.00 €");
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Use Ninox as a backend with an online ordering system
@Vermaji I'm sure it can be done, but this is not my field. Off the top of my head you would need a website or google form and some middle-ware like Make or Zapier.…
- Fred
- 5 mths ago
- Get help
- Reported - view
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
- 5 mths 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
- 5 mths ago
- Get help
- Reported - view
Re: How to use setItem in a button?
I just tried it again and now it works fine.
- Fred
- 5 mths 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 5 mths ago
- 1reply
- 26
- 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- Get help
- Reported - view
Re: do as deferred
The solution of using do as deferred was not mine.
- Fred
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- Get help
- Reported - view

1 8 9 10 11 12 145

Welcome to the Ninox community

Fred

My Posts

Re: Ninext project

Substitutions for ui.popupRecord

Re: Ninext project

Re: Ninext project

Re: Ninox 3.15

Re: How to Track Client Changes in Ninox (Audit Log Table)

Re: Problem to add sign + and -

Re: Use Ninox as a backend with an online ordering system

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'

Overview