Jacques TUR's Profile | Ninox community

Badges

Latest Posts

Re: Inconsitancy by data aggregation
You can try it on Console : 1+0.000000000000001 => 1(1+0.000000000000001)=1 => No
- Ninox developper
- Jacques_TUR
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
There miss ":" in last line Lens := MyLensID;
- Ninox developper
- Jacques_TUR
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
Maybe this code https can help you : https://www.w3schools.com/code/tryit.asp?filename=GMJXIP6OLQIB From HTML and JS code, it display all teams, databases, tables, records and fields.…
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: I don't understand Ninox API. Please help me
You can try with Advenced REST Client. This software help you to test your API methode. When is right, it provide you samples codes in differents langage (HTTP, JavaScript, Phyton, C...).…
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Two formulas updating two seperate fields in a choice field.......Help
And also : switch 'Num of Curtains' do case 1: (Wide_W := "1 x" + " " + Wide_Widths; Num_of_Width := "1 x"+" "+ Curt_)case 2: (Wide_W := "2 x" + " " + Wide_Widths / 2; Num_of_Width:…
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Error: Expression does not return multiple values
oups : Could you try with : sum(select 'Subject Allocation'[Year = "1"].'Points Earned')
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Error: Expression does not return multiple values
Could try with : sum(select 'Subject Allocation'[Year = "1"].'Points Earned') ?
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Error: Expression does not return multiple values
I think to understood :XrefSubject is both field of 'Subject Allocation' and one table. If you want to make sum of the table, write sum(select XrefSubjects.'Subject Allocation'[Year = "1"].…
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Error: Expression does not return multiple values
What types of value is 'Ordre d''inscription' and Year ?
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to have choice and multi choice fields where editors can enter new values directly into the field, rather than having to pre-define all values?
(I wrote in english for all other people, although my English is not very readable 😂) Hi Robert, Uwe will put data base on Webinar. But if you send me your email,…
- Ninox developper
- Jacques_TUR
- 5 yrs ago
- Get help
- Reported - view

1 32 33 34 35 36 37 38

Welcome to the Ninox community

Jacques TUR

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 !?

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

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

Re: Two formulas updating two seperate fields in a choice field.......Help

Re: Error: Expression does not return multiple values

Re: Error: Expression does not return multiple values

Re: Error: Expression does not return multiple values

Re: Error: Expression does not return multiple values

Re: Is it possible to have choice and multi choice fields where editors can enter new values directly into the field, rather than having to pre-define all values?

Overview