Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Best practice to duplicate a record
@Vermaji said: a) What data type should I give to the variable itm? That is the great thing about Ninox you don't need to pre-define the variable. It seems like a simple piece of code,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Best practice to duplicate a record
@Vermaji said: What is the best practice to create a new record (duplicate record) in a table? Currently I am doing "Do as server ... end". Is this a good practice?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
@Shawna I think the transition is complete.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Somewhere to share user templates?
@Shawna They had to remove everyone while they transitioned the workspace. It is just like Ninox not to tell everyone. Email support again.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Filter by date in a sub database
@alfonso. mino. arribas said: What I need is the balance sheet for 2016 Is that what the Balance Sheet table for? can you upload a sample db? it would make it easier to figure out what you want.
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 31 32 33 34 35 154

Welcome to the Ninox community

Fred

Re: Best practice to duplicate a record

Re: Best practice to duplicate a record

Re: Somewhere to share user templates?

Re: Somewhere to share user templates?

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: 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

Overview