Jacques TUR's Profile | Ninox Community

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 283
- 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
Re: Default value for subtable reference field.
Hi Chris, You must initialise your reference to Lenses in Carmera when a new record is created. To do this, set a default value for your lens on the "Trigger on creation" function in the definition…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
Thank you both for your advice. Sean, I will be investing in the getVault feature. Anyone ever done this yet?
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
I found the solution: 1 - the following code returns all the declarations of all the database: tables, fields, function, layout elements, declaration and global parameters Inside there are all the…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
C'est impressionnant de voir que vous avez mis cela en place sans grande connaissance des langues du web. Puisque vous en êtes arrivé là avec JavaScript,…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
I’m not sure to understood Sean. I wrote it friday to try reading and manipulate images and PDF files (others fields formats seem easier to read). I used AdvencedRestClient and somes w3schools…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Server slowdowns !?
May be I had sent too much task with Do As Server function !?
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Server slowdowns !?
No. It came back on its own. It's all right now.
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view

1 29 30 31 32 33 34 35

Welcome to the Ninox community

Jacques TUR

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.

Re: Default value for subtable reference field.

Re: I don't understand Ninox API. Please help me

Re: I don't understand Ninox API. Please help me

Re: I don't understand Ninox API. Please help me

Re: I don't understand Ninox API. Please help me

Re: Server slowdowns !?

Re: Server slowdowns !?

Overview