Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Merry Christmas
Merry Christmas and a happy holidays to all as well.
- Fred
- 4 hrs ago
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR That is some cool new stuff. Thanks and hope you have a restful holiday season as well.
- Fred
- 22 hrs ago
- Learn and share
- Reported - view
Re: Trouble finding a column
@frsalabert Try this code instead: let key := this; if 'Commandé?' = true then (create 'Lignes Commandes').( OPTIONS := key; 'Désignation' := key.'Fiche Option'.Designation; FRN := key.'Fiche Option'.…
- Fred
- yesterday
- Get help
- Reported - view
Re: Formula for the button
It looks like you want to use Invesment in Project as your join table. To make that work the Invesment in Project table has to be the many (M) side of the relationship.…
Attachment
- Fred
- yesterday
- Get help
- Reported - view
Re: Trouble finding a column
Ok, let me see if I understand what you want. I would like to select those options with a selection button: What table are you thinking this new dynamic multi choice field would be created in?
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Trouble finding a column
@frsalabert can you put in some sample data?
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Trouble finding a column
@frsalabert Thanks for the update. I am unclear about: I would like to select those options with a selection button: when selected, the option (with all infos and its link to ‘Fiche option’) should…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Formula for the button
@iliper LTD I read about creating relationships between tables, but I couldn't figure it out. Your Invesments table is another possibility to use as the JOIN table between PROJECTS and Investors.…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Formula for the button
Looking back at your past post you have asked similar posts. I would ask that you try to write the code first and post it. No better way to learn then to do it.…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Formula for the button
Looking at your DB the Investors tab in the PROJECT table is empty except for a reference field. You will have to be more specific about what you are looking for.…
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Slow Mac App
@Kim Schacht Ninox is hearing it on the German side as well. I'm sure they will try again. But I feel you.
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
@Graham Brown I would say that it is not really a "dummy field" as you had to create a 2nd formula field anyways.
- Fred
- 5 days ago
- Get help
- Reported - view
Re: “Is there a way in Ninox to get the display name of the current table through a script? I don’t want the tableId (which returns a unique ID)
Since there is no command to do it there are work arounds. I saw@Andy demonstrate a solution where you have a table that stores the table name and then you have the appropriate record in table name…
- Fred
- 5 days ago
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
@Graham Brown said: but I am referencing an MCD where there is a choice of "select" functions and addressing the field from another routine. I think @John Halls was talking about is to put the same…
- Fred
- 5 days ago
- 1
- Get help
- Reported - view
Re: Trouble finding a column
@frsalabert said: What I wanted to do is to select (with a selection button) a record or many and copy it or them in the ‘table ligne commande’ with all its columns so I can gather many ‘ligne…
- Fred
- 6 days ago
- Get help
- Reported - view
Re: button to make an record in the table
oops, sorry for mis-reading the issue. Try: let thisRec := this; let projRec := record(Project1,number(Project3)); if projRec != null then var share := shareFile(thisRec.…
- Fred
- 9 days ago
- 1
- Get help
- Reported - view
Re: button to make an record in the table
You will need two create() commands. Something like: let thisRec := this; let projRec := record(Project1,number(Project3)); if projRec != null then let newProj := (create Project1);…
- Fred
- 10 days ago
- Get help
- Reported - view
Re: sum up the amount of expenses
If you only want to look at the subtable then you don't need the select or the for loop: let c := Expenses; let x := sum('Expenses name'[Expenses = c].Amount);
- Fred
- 10 days ago
- Get help
- Reported - view
Re: Trouble finding a column
@frsalabert it looks like Offres is the many side of the relationship, so Ninox will always assume that multiple records will be returned. Even if you only have 1 record linked,…
- Fred
- 10 days ago
- Get help
- Reported - view
Re: How to rearrange fields in a form
There are two ways: 1) in Admin mode you can drag the fields around 2) in Edit fields, you can reorder the fields Or are you having some other issue?
- Fred
- 12 days ago
- Get help
- Reported - view
Re: Trouble finding a column
The reason why you need to remove 'Lignes Commandes' is because you are already in the Lignes Commandes table. You use the variable t. Which is a reference to the create() command a few lines above,…
- Fred
- 12 days ago
- Get help
- Reported - view
Re: Image Container does not update after edit
I am able to duplicate the issues in the public cloud, so I would send an email to Ninox support.
- Fred
- 13 days ago
- Get help
- Reported - view
Re: Dynamic Reports - Data from Different tables
Just a bit of background. Ninox only outputs the last line, command. So you last command is the JSON that shows the y data. That is why @RoSoft_Steven recommended that you put the y data into the x…
- Fred
- 13 days ago
- Get help
- Reported - view
Re: Menus Larger
@New Sun it wasn’t me. It was@RoSoft_Steven
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Menus Larger
@RoSoft_Steven That is great. I was stumped when he showed it was a dialog() command. Love this community!
- Fred
- 2 wk ago
- 1
- Get help
- Reported - view

1 2 3 4 5 153

Welcome to the Ninox community

Fred

Re: Merry Christmas

Re: Ninext project

Re: Trouble finding a column

Re: Formula for the button

Re: Trouble finding a column

Re: Trouble finding a column

Re: Trouble finding a column

Re: Formula for the button

Re: Formula for the button

Re: Formula for the button

Re: Slow Mac App

Re: Count items (all) in a dynamic multi choice field

Re: “Is there a way in Ninox to get the display name of the current table through a script? I don’t want the tableId (which returns a unique ID)

Re: Count items (all) in a dynamic multi choice field

Re: Trouble finding a column

Re: button to make an record in the table

Re: button to make an record in the table

Re: sum up the amount of expenses

Re: Trouble finding a column

Re: How to rearrange fields in a form

Re: Trouble finding a column

Re: Image Container does not update after edit

Re: Dynamic Reports - Data from Different tables

Re: Menus Larger

Re: Menus Larger

Overview