RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Need help organizing some information
@BuffaloTony What if you use text(color(loop2.Position)) ?
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: I need to iterate a json object.
@Sotirios Zormpas Yes, correct.
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: I need to iterate a json object.
You can also use this code to get a list of your Json: let myobject := { myObject: { paul: 10, jack: 20, bob: 30 } }; for name, value in myobject.myObject do name + ":…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 3
- Learn and share
- Reported - view
Re: Compose not send e-mail with attachments
@Mel Charles 🫶
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Bulk edit yes/no
True, A Yes/No field has 3 states.
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Help with Google Charts in Ninox
I observed a strange behavior also with me. When opening the form, the chart was not visible. When closing and reopening the form the chart was shown. I do not know what causes this strange behavior.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Help with Google Charts in Ninox
At first sight, you are missing a comma after variabele 5. Also, i would use single quotes instead of double double quotes. You might also wrap your code in <htlm> ... </html> tags. Hope this helps.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Help with Google Charts in Ninox
As you can see in this example the data should be numbers. Can you upload a example database with dummy data if you don't get it to work?
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Thoroughly delete image elements with code
And for the code and an example database here. 😉
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Find special Codes
.... where contains('Audit Code',"_x1")
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: trying to add 6 months to a date
This works for me: date(year(Datefield), month(Datefield) + 6, day(Datefield)) And somehow Ninox takes in account if the sum of the month is bigger than 12, the year is adapted too.
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 1
- Get help
- Reported - view
Re: button to number records incrementally
you can try something like: let Y := Year; let c := 1; for i in select Candidates where Year=Y and text(Filter)="Chosen" order by DOBirth do i.number := c; c :…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: API RESULT
@Andrea let header := { Authorization: "Bearer MYTOKEN", Accept: "application/json", 'API-NUMBER': "MYAPI" }; let myURL := "https://company.openapi.com/IT-pec/xxxxx"; let response :…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: API RESULT
@Andrea parseJSON(JsonResult).first(data).pec
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@Fred https://docs.ninox.com/en/script/functions-overview/functions/replace
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack with an extra replace i guess: let txt := replace(substr(YourTextField, index(YourTextField, "-") + 1), """", ""); txt := replace(txt,""",""); txt where the middle one " of the """ is a curly…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@Rafael oops, the text 2 was my test yourtextfield and i forgot to rename it here in this example. So it should be replace(substr(YourTextField, index(YourTextField, "-") + 1), """", "")
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflacktry: replace(substr(YourTextField, index('Text 2', "-") + 1), """", "")
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?
Not sure it'll work but you can try the replace() function.(use in a trigger) replace(text1,"你好","nh") text1 is your text-field
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Creating Chart with Multiple Series
Maybe with google charts? https://forum.ninox.com/t/h7hrmm9?r=x2hbksh https://developers.google.com/chart
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Error to send Email
It must be a bug, I have reported this to Ninox
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: chiose table from a variable
I guess this could be possible with Ninox API... I also tried with the eval() function but that doesn't work...
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Return JSON
More simplyfied: >for the first status : let i := parseJSON(JSON); first(first(i.result.recordsets)).status >for the second status: let i := parseJSON(JSON); first(i.result.recordset).status
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Return JSON
If you want the first status, this works: (in this example, the data is held in a text field "JSON" and the code is written in a formula field) let i := parseJSON(JSON); let j := first(i.result.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: json add array
You could try: let myURL := ""; let myBearer := (select Einstellungen).'Bexio API-Token'; let contact_id := Kontakt.'Bexio ID'; let user_id := 'Projektleiter 1'.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view

1 5 6 7 8 9 65

Welcome to the Ninox community

RoSoft_Steven

Re: Need help organizing some information

Re: I need to iterate a json object.

Re: I need to iterate a json object.

Re: Compose not send e-mail with attachments

Re: Bulk edit yes/no

Re: Help with Google Charts in Ninox

Re: Help with Google Charts in Ninox

Re: Help with Google Charts in Ninox

Re: Thoroughly delete image elements with code

Re: Find special Codes

Re: trying to add 6 months to a date

Re: button to number records incrementally

Re: API RESULT

Re: API RESULT

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?

Re: Creating Chart with Multiple Series

Re: Error to send Email

Re: chiose table from a variable

Re: Return JSON

Re: Return JSON

Re: json add array

Overview