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
1638
posts
235
likes received
5
followers
Badges
Latest Posts
Re: BULK Edit values with a button
for i in select yourtable do i.'yes/no-field' := false end @gary
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: Send mail with attachments from different tables
@Sébastien Guillet I think someting like : let att1 := record(Documents,number(AddDocFacture).Document; let att2 := record(Documents,number(AddDocAnnexe).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
1
Get help
Reported - view
Re: Send mail with attachments from different tables
You can select attachments from another table like this: let attachment := first((select Tablex).attachmentfield) see…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
Re: No plot null values
👍
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 yrs ago
Get help
Reported - view
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
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
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics