Fred

San Francisco, USA

3524
550
4

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

My Posts

Latest Posts

Re: How do I get dynamic Choice field towork?
your formula: ProviderCategory.Category where ProviderCategory.Provider = Payments.Provider should look something like this: let curRec := this; <-- curRec can be any name you wantselect…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: I think we have a new record for spam posts
I sent an email to Ninox support as the company doesn't seem to look at the forums. Looks like they have cleared out the most recent spam.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Automatically change a value when a date is equal to today
Maybe you can try using the Trigger after open? You find this by clicking on the DB name, after you open it. Click on the red wrench. Click on Options. To the best of limited knowledge there is no…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: how many end users
I don't know what the max is, but Ninox charges $10/user/month for non-enterprise users. You have to call them for enterprise pricing. https://ninox.com/en/pricing
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching two numbers
Ok, if your field only has one number in it and you are in a table view that you now want to filter only the 8's and 10's then you need to use an "or" not an "and".…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Automatically change a value when a date is equal to today
You can try something like this in a button: if [date field] = today() then [field name] := [state] end You would put the exact name of the date field and field name for [date field] and [field name]…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching two numbers
I am unsure what you mean by base? Are you trying to find records in your view that have either 8 or 10 in a number field? or Are you saying that you have a record that has a field that has multiple…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox App is Crashing on my iMac
May I recommend that you email Ninox support directly as they rarely check these forums. Good luck.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
Let me see if I can help out here. Now we will add a new table called Payments. Add a number field called Amount, or whatever. Then add a reference link to Payments, Categories, and Services.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
Hi there - I hope I can add some clarity. You say: There are three ‘parent’ tables, which could have a number of fields, only one of which as relevant. My tables in this category,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create an invoice for a collection of orders?
Damn, John beat me again. Just as I figured out a way to create an invoice for each customer of the current shipment in a button: let curRec := this;let xCust := Customers;let arrCount :…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Add line number to subtable
Have you looked at Trigger on Create? Select a table, Edit Fields, look at Trigger on Create.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Fields, "Show as: Embedded" - can you select which fields to display?
Hi Karen - It looks like Embedded just shows you first View from the Colors table. If you select any other Show As you can control what fields are shown by clicking on Edit Columns: Hope that helps.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create an invoice for a collection of orders?
As always, John is much more elegant.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create an invoice for a collection of orders?
Just to double check. You want a button that goes through your Shipments table and creates a record in your Invoice table? Do you need to do this everytime you push the button?…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Change timepicker format to 24h
I thought it would depend on the system setting of your computer, but when I switched my computer to 24HR time the time field still shows as AM/PM. Maybe the web version is different,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: A little help for a button script
Looking at your screenshots, the button is "not doing anything" because Couleur in Table2 has not data to match in Table1.Couleur. "Nothing" is linking because Ninox can't find any matches.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Overwrite function with Combobox
You can do something like this: if Combobox != null then Price*Combobox else your previous code end If you combobox has text then you will need to either change them to just numbers or create a…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
If you want to be more flexible, then you can change your select: let xVar := (select Clients)
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: A little help for a button script
Remember to make sure the field names in formulas match exactly to your field names. So in Table2 the field name is spelled "Couleur", so you need to make sure line 2 reads: let myRec := i.Couleur;
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Hi Jesper - if you put your selection into a variable, let xVar := (select Table1 where field1 = true).field1. Then you can rsort, rsort(xVar). You can put that in a variable, let xRSort :…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: A little help for a button script
It just came to me, I thought you are running in iCloud, so you can drop the do as server. It doesn't hurt it but it is not needed.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: A little help for a button script
I recreated your DB and this is the code that worked for me: for i in select Table2 do let myRec := i.couleur;<--I didn't capitalize this field name let mySup :…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
You are correct that the forum only supports picture formats, so your earlier PDFs don't show properly.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
Ok, first let us look at your tables. You said you have a Parent table with a field called Names. I'm guess it is a simple text field (it has a T icon).…
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 132 133 134 135 136 141

Welcome to the Ninox community

Fred

My Posts

Re: How do I get dynamic Choice field towork?

Re: I think we have a new record for spam posts

Re: Automatically change a value when a date is equal to today

Re: how many end users

Re: Searching two numbers

Re: Automatically change a value when a date is equal to today

Re: Searching two numbers

Re: Ninox App is Crashing on my iMac

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Re: How to create an invoice for a collection of orders?

Re: Add line number to subtable

Re: Dynamic Multiple Choice Fields, "Show as: Embedded" - can you select which fields to display?

Re: How to create an invoice for a collection of orders?

Re: How to create an invoice for a collection of orders?

Re: Change timepicker format to 24h

Re: A little help for a button script

Re: Overwrite function with Combobox

Re: Order by descending

Re: A little help for a button script

Re: Order by descending

Re: A little help for a button script

Re: A little help for a button script

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Overview