Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
1,299
93
2
Joined: 30 Sep 2018
Follow
https://www.rosoft.be
My Posts
Latest Posts
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
6 days ago
Learn & 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
7 days ago
Learn & 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
8 days 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
8 days 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
8 days 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
8 days 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
8 days 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
9 days 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
10 days 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
10 days 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 wk 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 wk 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 wk 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 wk ago
Get help
Reported - view
Re: No plot null values
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
3 wk 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
4 wk 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
4 wk 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth ago
Get help
Reported - view
1
2
3
4
5
52
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics