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
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3747
594
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Ninox App Settings
Great idea. You should send an email to Ninox support.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Is Ninox down for anyone else?
I have no issue here in San Francisco, USA.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Video Field versus Image Field
check out@Sotirios Zormpas ' update:
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice fields in dynamic print layout
If you are using a simple choice then you can use the text() command. There is no other data besides the choice number and the text associated with the choice.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Trigger After Update does not get Triggered
@John Halls i stand corrected. I know there is a situation where they don't get triggered.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Trigger After Update does not get Triggered
Triggers after update are only activated by a manual selection. Scripts don’t trigger after update.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dashboard Template
@Sotirios Zormpas You are da Man!
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Colorcoding an appointment in calendar
this works for me: switch mC do case 1: styled(text('Rich text'), "green") case 2: styled(text('Rich text'), "blue") end mC is a simple choice field. Rich text is an old (pre 3.13) rich text field.…
Fred
Fred
1 yr ago
Get help
Reported - view
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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
1
28
29
30
31
32
150
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
