Fabio's Profile | Ninox Community

Latest Posts

Re: Control records Access by user.
Hi Carlos. In the expenses table settings -> Readable if, put this:--user() = 'Created by'-- Fabio
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Learn and share
- Reported - view
Re: Create n records in a subtable at once
Hi MP. Try this: -- let xcli := field1;let xdata := field2;let xnp := (create PARCELLE);xnp.( fieldA := xcli; fieldB := xdata);let newPrestazione := (create PRESTAZIONI);newPrestazione.…
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Get help
- Reported - view
Re: Consistency check formula
Hi Giovanni. If you want to make it work with 0.01 use John's code by rounding the calculation, like this: - if abs(round('Total Activity-Related Budget (IC)' - ('Total Direct Costs (IC)' + 'Total HQ…
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Get help
- Reported - view
Re: problemi di stampa dei report
Ciao. È necessario cambiare il motore di stampa. Scrivi a support@ninox.com che ti risolvono il problema. Fabio
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Get help
- Reported - view
Re: Hiding a multiple choice field
Hi Giovanni. Put this in "Diplay field only if" in your Date field: - not chosen('Multiple choice', "A") - Fabio
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Get help
- Reported - view
Re: TRIGGER problem - Help please!
Hi Anna. Try this: --- if 'Courier Type' = 1 then 'Courier Charge' := 29.99; 'Insurance Value' := 1else if 'Courier Type' = 2 then 'Courier Charge' := 34.99; 'Insurance Value' := 2 endend --- Fabio
- Sviluppatore Ninox
- Fabio
- 4 yrs ago
- Get help
- Reported - view
Re: Open tab with button ?
Certainly. From the manual:https://ninox.com/en/manual/calculations/reference-of-functions-and-language ---openTable(tableName, viewName) --> opens a table view--- Example: if the table is:…
- Sviluppatore Ninox
- Fabio
- 5 yrs ago
- Get help
- Reported - view
Re: Open a record with a button
let lastRecord := last(select 'Contacts edition');popupRecord(lastRecord)
- Sviluppatore Ninox
- Fabio
- 5 yrs ago
- Get help
- Reported - view
Re: Open a record with a button
Hello Administrateur. Try this: --- let lastRecord := last(select 'Contacts edition');popupRecord(record('Contacts edition',lastRecord)) --- Fabio
- Sviluppatore Ninox
- Fabio
- 5 yrs ago
- Get help
- Reported - view
Re: Dates issue Ninox app vs browser
Hi Marc. In fact even Chrome has the same problem. I hope the Ninox support will fix it as soon as possible. Thank you for your information Fabio
- Sviluppatore Ninox
- Fabio
- 5 yrs ago
- Get help
- Reported - view
Re: Dates issue Ninox app vs browser
Hi. I have the same issue: did you solve it?
- Sviluppatore Ninox
- Fabio
- 5 yrs ago
- Get help
- Reported - view
Re: Concat Formula
Hi. Try this: --- let myArray := ['Sample 1', 'Sample 2', 'Sample 3', 'Sample 4'];join(myArray, "") --- Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: HTML text
Hi Emanuel. Same problem on rich text. Have a look on change requests list, CR 1785 Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Show Date as Year Only
Hi year(Vintage) or format(Vintage, "YYYY") to Formats a date as a string
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Creating many to many relationship between two tables
Try now.
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: How to get the last two digits of the current year？
Hi. Try this: format(today(), "YY") Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Lesson plan
You're welcome Matteo. I used a N:M relationship between tables ;). Have a look here: https://ninoxdb.de/en/manual/tables/table-references-and-relations Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Lesson plan
Hello. See if this gets closer to your needs :) https://www.dropbox.com/s/mfotvoulr8zcgf2/Lezioni%20v2.ninox?dl=0 Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: How to get the last two digits of the current year？
Hello. Suppose that "Invoice N. " is the field (text format) where you enter the invoice number: substr('Invoice N.', index('Invoice N.', "-") + 2, 2) Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Lesson plan
Hello Micrologus. Have a look at this model: https://www.dropbox.com/s/7ee9c4wov4dty5m/Lezioni.ninox?dl=0 Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Opening the Calendar upon opening a db
Hi Nick. This is a change request and will be implemented in an upcoming update. Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Multi criteria filter
Perfect it works, thanks Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Accounting Tutorial
Thank you Nick :) !!!
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Multi criteria filter
mmhh.. in some cases, filters can not be implemented through the mechanisms described in the Filtering Values section.. In these cases the trick is to define the filter over an additional calculated…
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view
Re: Text Formatting on print
Hello. Try using a Rich text: you can specify text as: bold, italic or underline text. Fabio
- Sviluppatore Ninox
- Fabio
- 6 yrs ago
- Get help
- Reported - view

1 2 3 4 5 6 7

Welcome to the Ninox community

Fabio

Re: Control records Access by user.

Re: Create n records in a subtable at once

Re: Consistency check formula

Re: problemi di stampa dei report

Re: Hiding a multiple choice field

Re: TRIGGER problem - Help please!

Re: Open tab with button ?

Re: Open a record with a button

Re: Open a record with a button

Re: Dates issue Ninox app vs browser

Re: Dates issue Ninox app vs browser

Re: Concat Formula

Re: HTML text

Re: Show Date as Year Only

Re: Creating many to many relationship between two tables

Re: How to get the last two digits of the current year？

Re: Lesson plan

Re: Lesson plan

Re: How to get the last two digits of the current year？

Re: Lesson plan

Re: Opening the Calendar upon opening a db

Re: Multi criteria filter

Re: Accounting Tutorial

Re: Multi criteria filter

Re: Text Formatting on print

Overview