Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

Re: Filter by date in a sub database
@alfonso. mino. arribas Just to be clear, 1 record in Accounts is linked to many records in Accounting. @alfonso. mino. arribas said: In accounts database,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Filter by date in a sub database
@alfonso. mino. arribas Your picture shows the Accounts table. Is the subtable in question, a sub of Accounts? Do you want to show the year data of the subtable in the Accounts table view?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Filter by date in a sub database
@alfonso. mino. arribas said: For example, the one that groups the total accounts cannot be filtered by month, or quarter, or year. How can it be done? First you probably want to create month,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: View from another database
That would be the do as database function. Only available to on-prem or private cloud users.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox App Settings
Great idea. You should send an email to Ninox support.
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Video Field versus Image Field
check out@Sotirios Zormpas ' update:
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas You are da Man!
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view

1 26 27 28 29 30 149

Welcome to the Ninox community

Fred

My Posts

Re: Filter by date in a sub database

Re: Filter by date in a sub database

Re: Filter by date in a sub database

Re: View from another database

Re: Ninox App Settings

Re: Is Ninox down for anyone else?

Re: Video Field versus Image Field

Re: Choice fields in dynamic print layout

Re: Trigger After Update does not get Triggered

Re: Trigger After Update does not get Triggered

Re: Dashboard Template

Re: Colorcoding an appointment in calendar

Re: Hide the trash, duplicate and add buttons globally

Re: Retrieve a field from one table in another

Re: Video Field versus Image Field

Re: How to track the selected item in a DCF

Re: Retrieve a field from one table in another

Re: Hide the trash, duplicate and add buttons globally

Re: Retrieve a field from one table in another

Re: Some help here

Re: Some help here

Re: Retrieve a field from one table in another

Re: Retrieve a field from one table in another

Re: Some help here

Re: Retrieve a field from one table in another

Overview