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: Multiply a number to get a status
You can use floor('Chiffre d’affaires'/600)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Variable in a text field
It is possible using the replace() function. let myvar := TextField(multiline); myvar := replace(myvar,"<name variable>", 'First name'); myvar := replace(myvar,"<code variable>",…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: Creating a Record from a Button Sending an Email
if you use variables in your sendEmail() function, you can reuse them to create a record. e.g. let sender:= userEmail(); let receiver := ClientEmail; let subj := Subject; let txt := Textfield;…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: Printing in a grid with photos
Seems like a good example to use the Dynamic print solution. Link that could be useful. The manual here. Or the more detailed manual from carbone.io here.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: RTF -> .rtf File or Print output
Maybe this tread could be useful.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: script syntax
let fa := 'FILTRE Anné'; select 'Commandes Fournisseurs' where year('Date Achat') = fa Should do it...
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: For each record
Would try this: for i in select SalesHeader do do as server let url := "https://fakeadress.com/" + i.'OrderNo'; let APIKey := "XXX"; let response := http("GET", url, {Authorization: APIKey,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: openFullscreen
@UKenGB Yeah, seems like a bug. It's like the fullscreen is connected to the record where you opened the fullscreen, and with the creation of a new record in that fullscreen,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: openFullscreen
You can use a Yes/No field (let's say FULLSCREEN, i use a toggle slider) and put this in the trigger after update: if FULLSCREEN then openFullscreen(this) else closeFullscreen() end The setting…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: VIEWING IMAGE SIZE
@PIERRE M If you want to know the filemetadate of a Imagefield, you can use this formula: let i := fileMetadata(this, last(split(text(Imagefield), "/"))) <--this gives an array of the filename,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: attach an attachment directly when sending an email
@Alain Maybe this post can help you for code examples. Check this video or this link to the manual for more info about the sendEmail function. NOTE: You need a cloud subscription in order to send…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: No plot null values
You can use the choicefield Charttype and choose Steppenareachart for a Bar Chart. Not sure if you can use more types of chart than these three with zero values,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Remove the repeated values from CutOff
@Rafael 👍 Glad you sorted it out
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Remove the repeated values from CutOff
let check := dialog(" Warning ", " ¿Confirm the Update Progress Project? ", ["Yes", "No"]); if check = "Yes" then for loop1 in select CutOff do CutOff_ := loop1.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: how to eMail with attachment on the Mac version
@Carlos Maybe this post can help you for code examples. Check this video or this link to the manual for more info about the sendEmail function. NOTE: You need a cloud subscription in order to send…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: maximum user roles
@Robbie You could add a subtable in your products-table where you add which franchisee can order that product. So only the products where they are in, they can order from.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: No plot null values
Here's the database with 3 different types of google charts, selectable with a choice field. More about google chart types here. The chart is in the table 'Avances' in the record-tab 'Chart'.
Attachment
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: No plot null values
@Rafael yes, I'll post it here tomorrow... with a second type of graph.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: No plot null values
@Rafael I made it work with Google Charts: Code in the GoogleChart formula field: let ti := "['Date','Accumulado Plan','Accumulado Real'], "; let chartdata :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: CHANIFY
I can't get it to work with the application (I guess you need a node.js or something?) Alternatively, if you send the shared url in the text, the users can follow the link to the file and the image…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: No plot null values
https://forum.ninox.com/t/q6hbwyp Wasn't the problem solved?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: CHANIFY
Suppose you have a table with 2 text fields: 'Token' and 'Message' If you put the right token in your Token field and a Message you want to send, putting this in a button will work: Simple Method:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: Static AND Dynamic Google Map with Multiple Markers
@Kruna Yes it is possible. You can build an array of places like for example your contacts table and put it in the url where the places variable should be.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Learn and share
Reported - view
Re: Get count of chosen values from different table
Then you can use the eval() function in combination with your formula: let a := "Jim"; let b := "norm"; let c := "count(select Timetable where text(" + a + ") = ""+b+"")"; eval(c,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Get count of chosen values from different table
formula should be: let a := "norm"; cnt(select Timetable where text(Jim) = a)
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
1
13
14
15
16
17
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