Skip to main content

Ninox-Documentation

RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1,299
93
2

Joined: 30 Sep 2018

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.
- 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.…
- 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.
- 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é…
- 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…
- 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).…
- 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
- 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); ....
- 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);
- 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);
- 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.…
- 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
- 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).…
- 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…
- Ninox partner
- RoSoft_Steven.1
- 3 wk ago
- Get help
- Reported - view
Re: No plot null values
- 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)
- 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>",…
- 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;…
- 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.
- 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.
- 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...
- 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,…
- 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,…
- 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…
- 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,…
- Ninox partner
- RoSoft_Steven.1
- 1 mth ago
- Get help
- Reported - view

1 2 3 4 5 52

Back to top

Ninox-Documentation

Overview

View all topics