RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

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
- 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
- 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); ....
- 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);
- 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);
- 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.…
- 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
- 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).…
- Ninox partner
- RoSoft_Steven.1
- 2 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…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: No plot null values
👍
- Ninox partner
- RoSoft_Steven.1
- 2 yrs 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
- 2 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>",…
- Ninox partner
- RoSoft_Steven.1
- 2 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;…
- Ninox partner
- RoSoft_Steven.1
- 2 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.
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: RTF -> .rtf File or Print output
Maybe this tread could be useful.
- Ninox partner
- RoSoft_Steven.1
- 2 yrs 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
- 2 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,…
- Ninox partner
- RoSoft_Steven.1
- 2 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,…
- Ninox partner
- RoSoft_Steven.1
- 2 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…
- Ninox partner
- RoSoft_Steven.1
- 2 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,…
- Ninox partner
- RoSoft_Steven.1
- 2 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…
- Ninox partner
- RoSoft_Steven.1
- 2 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,…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Remove the repeated values from CutOff
@Rafael 👍 Glad you sorted it out
- Ninox partner
- RoSoft_Steven.1
- 2 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.…
- Ninox partner
- RoSoft_Steven.1
- 2 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…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view

1 12 13 14 15 16 65

Welcome to the Ninox community

RoSoft_Steven

Re: Matching Phone Area Codes to Region

Re: Matching Phone Area Codes to Region

Re: Clean field when i duplicate table

Re: Send mail with attachments from different tables

Re: Select result if more then one - Rest API

Re: OPENAPI

Re: BULK Edit values with a button

Re: Send mail with attachments from different tables

Re: Send mail with attachments from different tables

Re: No plot null values

Re: Multiply a number to get a status

Re: Variable in a text field

Re: Creating a Record from a Button Sending an Email

Re: Printing in a grid with photos

Re: RTF -> .rtf File or Print output

Re: script syntax

Re: For each record

Re: openFullscreen

Re: openFullscreen

Re: VIEWING IMAGE SIZE

Re: attach an attachment directly when sending an email

Re: No plot null values

Re: Remove the repeated values from CutOff

Re: Remove the repeated values from CutOff

Re: how to eMail with attachment on the Mac version

Overview