Fred

San Francisco, USA

3609
568
5

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

My Posts

Latest Posts

Re: If the value is not different from the previous one
Sure, please post your current code so we can see what is going on.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Best practice to duplicate a record
@Vermaji said: Actually at many places things are not very well explained in Ninox and there is not enough documentation Yep that is the state of Ninox.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Best practice to duplicate a record
@Vermaji said: 2. Does "Do as server" have to be the first statement in the code? It does not, you can mix in do as server on parts of your code that you need it done.
- Fred
- 9 mths ago
- Get help
- Reported - view
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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
@Shawna I think the transition is complete.
- Fred
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Get help
- Reported - view
Re: Ninox App Settings
Great idea. You should send an email to Ninox support.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Is Ninox down for anyone else?
I have no issue here in San Francisco, USA.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Video Field versus Image Field
check out@Sotirios Zormpas ' update:
- Fred
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Get help
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas You are da Man!
- Fred
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Get help
- Reported - view

1 22 23 24 25 26 145

Welcome to the Ninox community

Fred

My Posts

Re: If the value is not different from the previous one

Re: Best practice to duplicate a record

Re: Best practice to duplicate a record

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

Overview