Fred's Profile | Ninox community

Badges

Latest Posts

Re: If the value is not different from the previous one
@iliper LTD said: The point is that I need to record the time when the information was changed I don't remember if you in the cloud, but if you are then you can use the _md command to access the…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 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

1 32 33 34 35 36 155

Welcome to the Ninox community

Fred

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

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

Overview