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: JSON: add a block based on a given condition
I would make the formula/codeblock in a text-format (where you can use the if...then) and then use the eval() function to execute the code.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: NEW: Dynamic print layouts for public cloud
If this helps... You could also make an json without the API with a select function. For example: (select 'users benelux').{ eml: email, Firstn: Firstname, Lastn :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: NEW: Dynamic print layouts for public cloud
@Jérôme Leleu Since you only need one record from your tableB, You could also put formula fields in your TableA with the last record-fields you need. Then you can use those fields in your…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Database Search
@orsadoc You can also share a view as HTML (if you have cloud subscription) Or make a webpage and import the data as json with a fetch() function. (Also requires a cloud subscription).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: All-day 'Appointments'
@andrew Did you know if you use the month view, you get the wanted result? I know, your solution is kinda cumbersome but works. There is no other solution for now I guess.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: The New IPhone Display Mode
@Roger Ninox has recently released a universal version of the Ninox app on ipad and iphone. The old 'legacy' version will no longer be supported/updated soon. Not sure which version you have though...…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Server Not Responding Rant
Fred on what pricing plan are you on? Seems that Starter doesn't do email support?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: HTML/Rich Text does not work on print record
@Daniel Marine If I remember it right, you could ask Ninox support to change the print engine. Maybe ask your question directly to support@ninox.com with your login mail and the Team name.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Server Not Responding Rant
@Fred It must have been very frustrating. Everything okay now?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: How to print a linked image from print layout?
@Sébastien Guillet If I remember it right, you could ask Ninox support to change the print engine. Maybe ask your question directly to support@ninox.com
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: member access and security
@gary You need to take a manual backup of the database, then go to the manage backups and download to your computer. Then you go to the other team and upload the database again.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: member access and security
The simplest way to do this is to create a new Workspace and just put the database 'Household' in there. Then invite your employee to this Workspace. He will only be able to see this database.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Learn and share
Reported - view
Re: Matching Phone Area Codes to Region
That's weird. Can you post a sample database? Or give some screenshots of your table? You may also invite me to your team (as admin) to have a look at it if you want.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Multiply a number to get a status
@Sébastien Guillet you would need some kind of trigger to do that and since a formula field isn't able to trigger or change any data field, you need a static field that holds the Niveau de fidélité…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Matching Phone Area Codes to Region
Since I use formula fields, they are automatically filled. If you want to do this with static fields, you can use this in a Button or in the console to update all the static fields (here I use…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Matching Phone Area Codes to Region
You could change the formula like this: let a := substr(Phone, index(Phone, "(") + 1, index(Phone, ")") - 1); first(select 'Area Codes' where 'Area Code' = a).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Matching Phone Area Codes to Region
Create 2 formula fields in your Leads table with folowing code: Region: let a := substr(Phone, 1, 3); first(select 'Area Codes' where 'Area Code' = a).Region Timezone: let a := substr(Phone, 1, 3);…
Attachment
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Clean field when i duplicate table
Before the openRecord(c) line, you can add this for the numbers that needs to be empty: c.(number1 := null); c.(number2 := null); ....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: Send mail with attachments from different tables
@Sébastien Guillet The attachments should be an array, can you try : let attTotal := array(attCGV,attDonnees,attSante,attDocs);
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
1
Get help
Reported - view
Re: Select result if more then one - Rest API
denominazione is in the soci group in your example .json, so I think you need to put this in the code: 'Rappresentante Legale' := text(response.result.data.detttaglio.soci.denominazione);
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
Re: OPENAPI
Did u try the url with postman? Did you get results? you can also test the result by adding codeline: alert(text(result)) Sorry, I can't test now on my ipad because of vacation trip.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
2 yrs ago
Get help
Reported - view
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
2 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
1
12
13
14
15
16
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