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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
www.rosoft.be
Follow
Joined
Sun Sep 30 17:18:00 UTC 2018
1611
posts
218
likes received
5
followers
Badges
Latest Posts
Re: Problem with HTML
@Rafael Which field do you want to show from the WBS table? , now you get the recordnumber(36) change the first line to: let ipc := first(select WBS where IPC = 1).fieldYouWantToDisplay;
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: Problem with HTML
@RafaelI was editing this post, you saw the old version....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: Problem with HTML
@Rafael If you use a select() function you get an array. To get a record, you have to use let ipc := first(select WBS where IPC = 1) I also removed the text() in this select because 1 is not present…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: How do you display information from a record on a website?
You can make a webpage for this, but you also need make.com for the connection with Ninox... (Yes you can do this without make.com and use the API of Ninox but your API key would be displayed public…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
1
Get help
Reported - view
Re: Create a zip file of all invoices generated with printRecord()
@Sébastien Guillet said: Please note however that the zip file is deleted from 'Fichier zip' and will be moved to the paperclip. Did you check the removeFile() function?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: Create a zip file of all invoices generated with printRecord()
First you need to create all your PDF's because of the lag between the actual PDF is created and the availability of this file. Then you need a second image field where you would put your .…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: How to implement a button function in Ninox: Create a new record and pop it up?
@我是我的我 I guess that's the reason why the big "Ninox CRM" (due to modularity, only available on private cloud) is using the "second way" version, so Table triggers would still work ...…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
1
Get help
Reported - view
Re: How to implement a button function in Ninox: Create a new record and pop it up?
@我是我的我 Yes, by using ui.openTable: let x := tableId("ADD"); html(" <head> <style> .szButton { border: 1px solid #566eb1; color: #566eb1; background-color: transparent; padding: 2px 20px; font-size:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
2
Get help
Reported - view
Re: How to implement a button function in Ninox: Create a new record and pop it up?
@我是我的我 I tried different approaches, even in a button. It's probably a bug in the app version. Maybe someone smarter can sort it out?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: How to implement a button function in Ninox: Create a new record and pop it up?
@我是我的我 There is a trick to do this by using a hidden field where the code is in the trigger after update to create a new record and open it. I have updated your database with an example of this:…
Attachment
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: Issue with adding products to the cart and creating invoices
@Fred True
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Get help
Reported - view
Re: Issue with adding products to the cart and creating invoices
@iliper LTD I suppose your CartClosed is a Yes/no field? Then you should know that such fields have 3 states: true, false and null. So if you want to check if the CartClosed is "No" it will probably…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
1
Get help
Reported - view
Re: Submit button with required fields notification.
@Michal Bor@Fred There is also a shorter version, see attachment of Fred's adapted example database (open Dashboard and Field Check tab). Also easier to expand if fields need to be added or if you…
Attachment
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
2
Get help
Reported - view
Re: JSON in dynamic fields
@Fred Strange, I get this but I'm on private cloud using chrome browser.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Learn and share
Reported - view
Re: JSON in dynamic fields
@FredAre you on version 3.14.1 ? It works on my end though?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
Learn and share
Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas @Fred Seems like the bug "text( MC)" is solved with the version 3.14.1
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
11 mths ago
1
Learn and share
Reported - view
Re: How to lock columns on the left ?
This would be a good feature request for Ninox as this is not available. For now, maybe@Sotirios Zormpas 's Dashboard template can provide a solution if this feature would be possible in his table…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: Who has set up email sending via SMTP in Ninox? Please share your experience!
You can use the mail-module in a make.com scenario.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
1
Get help
Reported - view
Re: VIEWING IMAGE SIZE
@PetraTest You're right. Seems like a bug. I'll report this to Ninox. Thanks.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: VIEWING IMAGE SIZE
@PetraTest what do you mean with "not the real" modified date? Isn't the file date not the last modified date of the file? Or does this function gives another date else than the file date?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: Show modified by for a specific field
You can have a text field and fill that in via the trigger after update of your checkbox. textfield := "changed by " + userName() + " on " + text(today())
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
1
Get help
Reported - view
Re: Spotify API Request
@francesco.stefanello To help you debug, you can open the console of the browser and see if you have errors there. If you have CORS errors, it's certainly because you need to use "do as server".
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: Spotify API Request
@francesco.stefanello see this example, sorry, change it to this... https://docs.ninox.com/en/api/http-function#example
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: Spotify API Request
you need to write "do as server": let response := do as server http("GET", "https://api.spotify.com/v1/artists/" + artistId + "/albums", { Authorization: "Bearer " + token, 'Content-Type':…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Fred If I may suggest something and just FYI, it is better not to use loops in the construction of the JSON. Especially when this formula is used in a global function and called with API.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
1 yr ago
1
Get help
Reported - view
1
2
3
4
5
65
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
View all topics