Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
I agree that spell check on the forum would be great. Since I can't see the pics, 1) is your ParentName reference field in the Child table set to be a composition of Parent?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicate some fields in a final summary ? How to do ?
Hi Fabien - Is your form in one table and the final summary fields in another? Do you need to create a new record in the final summary table first?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to enter text field value from a list of 'acceptable' values in a listbox
If the Provider field in Payments is a reference field to Providers then it will default to Popup and show you all the records in Providers. If you edit the Provider reference field in Payments you…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two bases Ninox side by side on an ipad ?
Since you use iCloud you can not open two instances of Ninox. If you look at the product page for Ninox it describes the different offerrings.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Two bases Ninox side by side on an ipad ?
If you use iCloud for storage then no. If you use the cloud then yes, but not through the Ninox app. You will have to open one db in the a browser then the other in Ninox app.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Sales Tax Issue
In a formula on a field in your Invoice Table you can do something like: let curRec := this; let xTax := (select 'Purchased Items' where Invoices = curRec and 'sales tax' = 1);…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: user id
Can you describe what you want to happen, with table and field names?
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: Help needed with invoicing
You reference an auto fill date code but didn't post it. Since you removed it have you had any issues? The other code you posted don't seem to touch any date fields so I don't see anything there.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Help needed with invoicing
Hi Michael - Do you have any trigger code or do you only notice this when you go to your Reports dashboard? What is the code you have in your Reports table view?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Dependant Table Actions
Hi Andrew - How are your TableA and TableB related? That is a lot of things to do. Why don't we start with creating one record in Table C from Table A. First create a button in Table A,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Bundled Product Circular Reference
You might have to consider making another table raw materials or something like that. Then you could make it a child of products. Then you can make a product that has many raw materials.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Bundled Product Circular Reference
Can you post a sample of your code?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Can I use two field contents as choices?
Dynamic choice fields are based on records in a table not on fields.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Re-reading my last comment and I am embarrassed that I wrote it. I am very sorry for it. you deserve to be treated with dignity.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
You made Noms(colonne14) = 0. So what do you think would happen when you did that? Just change everything back. I was talking about changing the Formule doublons Noms,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
What did you change? Just change whatever you just did back.
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 136 137 138 139 140 145

Welcome to the Ninox community

Fred

My Posts

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

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

Re: Duplicate some fields in a final summary ? How to do ?

Re: Is there a way to enter text field value from a list of 'acceptable' values in a listbox

Re: Two bases Ninox side by side on an ipad ?

Re: Two bases Ninox side by side on an ipad ?

Re: Sales Tax Issue

Re: user id

Re: Help needed with invoicing

Re: Help needed with invoicing

Re: Dependant Table Actions

Re: Bundled Product Circular Reference

Re: Bundled Product Circular Reference

Re: Can I use two field contents as choices?

Re: Bigger or equal…

Re: Bigger or equal…

Re: Bigger or equal…

Overview