Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Ninox 4
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3939
posts
639
likes received
5
followers
Badges
Latest Posts
Re: Hide the trash, duplicate and add buttons globally
@fmedeiros For my DB, I am the only user, but as I started using dashboards I find they are faster and easier to enter/adjust my data than going directly.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Retrieve a field from one table in another
@giuseppe I would recommend that you use the reference field to Contratti matrimoni instead of doing a select. Reference fields are always much faster. first('Contratti matrimoni'.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs ago
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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
Re: Some help here
@Rafael please post your new code.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Some help here
@Rafael So use that relationship to do your sum().
Fred
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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…
Fred
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
1
36
37
38
39
40
158
Ninox-Website
Overview
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
Ninox 4
View all topics