Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
www.rosoft.be
Follow
Joined
Sun Sep 30 17:18:00 UTC 2018
1634
posts
234
likes received
5
followers
Badges
Latest Posts
Re: New Email Button creating a new record in subtable
Last line should be : popupRecord(record('New Email',i.Id)) forgot a '
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: New Email Button creating a new record in subtable
Nick again..... 🤣
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: New Email Button creating a new record in subtable
Halio, Try this: let currRec := Id;let i := (create 'New Email');i.(Emails := currRec);popupRecord(record(New Email',i.Id)) Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Rich text formatting disappears in final PDF file
Best solution i guess is to contact support@ninoxdb.de and ask to change the print engine of the cloud team you're working in. I think that might help. Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Frustrated with poor help guides- Is there a full guide to formulas anywhere?
Something like this? In a formula field: cnt(select TableName where Field = a certain value) Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: date function
Haha Nick, 😇
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: date function
Hi, In this example, the field for the year is a number field 'Year' and the two other fields are date fields 'Begin' and 'End'. You can put this code in the Trigger after update of the 'Year' field…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Impression d’une mise en page
Vous pouvez le faire en utilisant un bouton et en utilisant des conditions. Tutoriel : printRecord(recordId, layoutName) Example: if a = true then printRecord(this,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Joining selected records from a table
@Ivan, it's best to send an email to support@ninoxdb.de with the dates you want the archive. You'll get the links then.Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Pulsante Apri tabella
Utilizzare openTable(tableName,viewName) nella formula del pulsante. Esempio: openTable( "Fattura", "Tutto") Vedere https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language per…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Reformatting text via a formula
Strange, i've tested it in the ipad and the web version, both are working. Do you use the trigger after update of the field itself? Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Reformatting text via a formula
Robert, Use capitalize(Firstname) instead. Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Ability to reorder tabs on forms or insert a new tab in the middle of the tabs?
When you go in the "Edit Fields" , the left column are the fields on your form and you can drag and drop these to rearrange the order. Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Learn and share
Reported - view
Re: Wanting a single record instead of the array.
Try using first() in your code(code goes betweed brackets) Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Change field label text depending from another field Value
You could make labels with a formula field e.g. : if language=1 then "Street" else "Rue" end Here is language a choice field with 2 options.(English and French in my example) And just name the…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Create a button to send an email with a file
** (only available in Ninox Cloud/Ninox Server teams) See: https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Display multiple records in one line in formula
Does this work in your situation? : join(InventReference.VendTable.Abbreviation + " " + InventReference.Reference," ") Didn't try myself (lack of time) Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How do I do a text calculation (e.g., First Name & " " & Last Name)
Does your suffix field comes from a dropdown selection? Then you must use: text(Suffix)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Have also a look at this thread : https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Bug in webversion?
@Birger, I've demonstrate it in a past webinar, if I use firefox(v.69.0 64bits) on PC Windows 10, i have this problem, with Google Chrome on the same pc I have no problem.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Learn and share
Reported - view
Re: Create new record in the table with a button?
You're welcome. A small correction, you can delete the first line, this is not necessary (let currRec := Id;) It's just a habit when I make longer code. 🥴
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Print view: invoice form calculations
For the slide up, see this thread : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/creating-an-address-block-from-different-fields-5cf46a93cdd5bd2503245b15?…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Create new record in the table with a button?
Hi, you can use this code for your button in a table called e.g. Category (change this by the name of your table): let currRec := Id;let i := (create Category);openRecord(record(Category,i.Id))
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to show tables marked hidden ?
Are you sure you're in administration mode? (Wrench topright must be RED) In the database model you can see all the tables where you can even select that table and unselect the hidden checkbox.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Print preview vs pdf
I have the same problem with the webversion. I don’t have a problem with the Ipad version. So that’s my solution for now. Hopefully solved with the new version coming soon...
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
1
56
57
58
59
60
66
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics