Jacques TUR

Jacques_TUR

Ninox developper

France

Joined: Sat Nov 14 09:45:24 UTC 2020

https://www.umangenius.com

La perfection est atteinte, non pas lorsqu'il n'y a plus rien à ajouter, mais lorsqu'il n'y a plus rien à retirer.

My Posts

Latest Posts

Re: Order by descending
Sean, maybe to solve your problem you could try to create a global variable? To do this you create a GlobalVars table in which you add a "Vendros" formula which contains for example :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Oops, here is the English translation ! Yes I agree, it's a lot to take in at once :o) Can you give me the thread where Alain talks about what can be given to the Ninox interpreter?…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Yes I agree, it's a lot to take in at once :o) Can you give me the thread where Alain talks about what can be given to the Ninox interpreter? Ninox is written entirely in JavaScript and can be…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
And here are the other things I found: It is possible to create an array of JSON objects: var Table := (select Contacts).{ "LeNom": Nom, "LeNom": 'Prénom', "Departement": substr('Postcode', 0, 2), id:…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Thanks Sean, I've been inspired by the different ways of coding I've found in this forum and especially by yours. Your many posts helped me a lot when I first started with Ninox and I think they help…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Order by descending
Oops, I made a mistake in this line : var sortedTable := (Table order by (
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Hello everyone, you can use this solution to sort a table by multiple fields and each in ascending or descending order. Just change the < or > symbols to change the sorting direction of each field.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
I found one error when value is "a" to "f" beacaus hex array contain uppercase char and the value come with lowercase char. You must to replace hexa array by this in the code : var hexa :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
It same way with DynamicMultiChoice : The code behind add button is : 'Sale Team' := setMultiChoice(number(Customer), string('Sale Team'), "add") For remove and toggle button,…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
This code could be help you to understantd en use codeing en décoding MultiChoice and DynamicMultiChoice flieds : function applyBinaryOp(value : number,mask : number,op : text) do var r := 0; var n :…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Auto populate fields with the value from the previous record?
Hi Ben You can duplicate a record, either by the user interface with the "duplicate" button (which is between the bin and the plus button), or by the code with function duplicate(this) (cf : https:…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: I can't no more post a screen shot on the forum
This bug has been known for 2 months already :o(We all look forward to fixing it.
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: I can't no more post a screen shot on the forum
Ce bug est connu dpeuis déjà 2 mois :o(Nous attendons tous avec impatience qu’il soit corrigé.
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Image editor

Hello everyone, I need to modify size or crop of picture.I'm looking for a editor solution that I could incorporate into Ninox.The best would be to have a popup editing window when you click on a…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- 281
- Get help
Re: How do you find if a value is present in a table ref
Do you tried one request like that ? count(Custmer.Contacs.access where User = user())>0; => return true if count is > 0.
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
You can try it on Console : 1+0.000000000000001 => 1(1+0.000000000000001)=1 => No
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Programmatic CSV import/export
Here are the three solutions that come to me: 1 - Use Zapier between Ninox and a CSV reader like Google Sheet. 2 - Use the Google Sheet macro to call the Ninox API.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
It's an interesting case that happens frequently in other languages. To better understand it, it is necessary to know that a floating point number is composed of a mantissa part and an exponent part.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
Hi Crhis, I recieved your screenshot.I not saw Sessions.Camera.Id on form. Where is ? I think the right way is use Camera.ID of Film : let MyCamera := Film.Camera.ID.
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
Could you send me the definitions (screenshot) of LensPairings and Camera by e-mail ? jacques.tur@neuf.fr. ps : the last trigger line has the wrong name of var MyLensID : Lens := MyLensIDLens.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
Did you try with round function ? let t1 := round(i.'Invoice Amount IC',2)let t2 := round(total + i.'Delivery Costs IC',2)
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
No problem Chris. There are people who help me too and they have a lot of patience with me . In the trigger and in the function, the ':' at line: Lens := MyLensID is missing.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
As I understand it, 'Select Lens' is the ID of another record in the same LensPairings table. Is 'Select lens' a number or a table pointer?If it's a number,…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
'Select Lens' is a pointer to which table in first(select LensPairings where 'Select Camera' = MyCameraID and Type > 1).'Select Lens' ?
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
There miss ":" in last line Lens := MyLensID;
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view

1 27 28 29 30 31 32 33

Welcome to the Ninox community

Jacques TUR

My Posts

Re: Order by descending

Re: Order by descending

Re: Order by descending

Re: Order by descending

Re: Order by descending

Re: Order by descending

Re: Order by descending

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Auto populate fields with the value from the previous record?

Re: I can't no more post a screen shot on the forum

Re: I can't no more post a screen shot on the forum

Image editor

Re: How do you find if a value is present in a table ref

Re: Inconsitancy by data aggregation

Re: Programmatic CSV import/export

Re: Inconsitancy by data aggregation

Re: Default value for subtable reference field.

Re: Default value for subtable reference field.

Re: Inconsitancy by data aggregation

Re: Default value for subtable reference field.

Re: Default value for subtable reference field.

Re: Default value for subtable reference field.

Re: Default value for subtable reference field.

Overview