Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

3012
454
4

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

My Posts

Latest Posts

Re: Video Field versus Image Field
It can probably be done in html? What do the HTML experts think?@Sotirios Zormpas maybe a new update to your dashboard?
- Fred
- 6 hrs ago
- 1
- Get help
- Reported - view
Re: How to track the selected item in a DCF
@Vermaji said: itemName := text(rec.'Order Items'.'Item Name'); on 'Sale Order' table returns an array of the record numbers in the DCF (I guess). to be sure you can create a new formula field in…
- Fred
- 14 hrs ago
- Get help
- Reported - view
Re: Retrieve a field from one table in another
@giuseppe @giuseppe said: The “Lavorazioni” record has a field called “Nome job relativo” which must be identical to a field in the “Contratti matrimoni” record called “Nome matrimonio in contratti”.…
- Fred
- 15 hrs ago
- Get help
- Reported - view
Re: Hide the trash, duplicate and add buttons globally
Another way to work around this is to uses dashboards/pages to create a UI for your users to use. That way you only need to hide it tables that they actually open.
- Fred
- yesterday
- Get help
- Reported - view
Re: Retrieve a field from one table in another
@giuseppe Lavorazioni is the one to the many of Contratti matrimoni. Which means one record of Lavorazioni can be linked to many records in Contratti matrimoni.…
- Fred
- yesterday
- Get help
- Reported - view
Re: Some help here
@Rafael here is what i have done to your DB: 1) the links to from Equipos to Partidos have been renamed to reflect if they are local or visitor. 2) the totalGF, totalGC,…
Attachment
- Fred
- yesterday
- Get help
- Reported - view
Re: Some help here
@Rafael I'm confused on what you are asking. 1) You have to manually enter the goals scored by each team. 2) that will run the trigger after update to update puntos.…
- Fred
- yesterday
- Get help
- Reported - view
Re: Retrieve a field from one table in another
@giuseppe said: Unfortunately, it does not work because the records are not associated. How can they not be "associated" when you said that there is a link between processing and contracts?…
- Fred
- yesterday
- Get help
- Reported - view
Re: Retrieve a field from one table in another
@giuseppe said: I can in the table “processing” retrieve data from the table “contracts” If you want to get delivery date in contracts from processing then something like the following in a formula…
- Fred
- yesterday
- Get help
- Reported - view
Re: Some help here
@Rafael said: To update the teams' table with the points earned from the matches, I need use a script that loops through all the matches, evaluates the result,…
- Fred
- yesterday
- Get help
- Reported - view
Re: Retrieve a field from one table in another
Is there a link to contracts in the processing table? Can you list the direction N:1 or 1:N between the tables in events and in processing? When you edit the reference field it shows you the…
- Fred
- yesterday
- Get help
- Reported - view
Re: Some help here
@Rafael You may want to think about renaming <_Partidos1 & 2. Maybe <_PartidosL and <_PartidosV. If you do that then you can change the code to: sum(<_PartidosL.'Ptos L') + sum(<_PartidosV.'Ptos V')
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Some help here
@Rafael said: sum((select Partidos).'Ptos L') + sum((select Partidos).'Ptos V') but this plase the same result in all game, in the Equipos need the points for each teams.…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett said: The question is really how to set the MC field as part of the code in an add new record trigger. It doesn't seem to work. If you are initiating from table2 then it is doing…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett The debugValueInfo is not supposed to be in your button code. See my post about how to use it. See the post to how to update the button. When you say "app" are you talking about MacOS,…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Some help here
@Rafael please post your new code.
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Some help here
@Rafael So use that relationship to do your sum().
- Fred
- 2 days ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett said: I think, by clicking a bin icon, but there doesn't seem to be a way of doing this now It has been awhile since I tried to delete choices.…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Formula for table ' Choice Dynamic'
what platform are you using? I can't duplicate it when I'm in the Cloud.
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Some help here
@Rafael said: This Formula SUM the same for all Teams need, need for each team. You are correct. Why don't you use the relationship link to Partidos? That way you only get related records?…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
I'm sure that until recently it was possible to delete a row from the options of a multiple choice field. Now I can only edit the text and re-order the options.…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji said: I have been advised by the veterans in Ninox and Ninox technical support that it is not a good idea to filter records using reference in a DCF element as it creates a chaos during data…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@Michael Cornelissen I've modified the DB to: 1) added a Yes/No field in Articles called Sub that allows you to specify if it is a subassembly. 2) I stuck with the material table as I just has…
Attachment
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Table or Sub-Table?
Here is something I made awhile back that show what could be done for your work orders as product/supply mgmt. It is made for 1 level between supplies and product.…
Attachment
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Populate text field based on selected option from a DCF
I suspect you are seeing a blank alert() is because when you do a select Ninox with no fieldname, Ninox always returns what appears to be blank but isn't. Ninox just doesn't know what to show you.…
- Fred
- 5 days ago
- Get help
- Reported - view

1 2 3 4 5 121

Back to top

Ninox-Documentation

Overview

View all topics