RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

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
Re: Send array of object json with httpr
You can also make your JSON like this for example: let w := something; let js := (select yourTable where condition = w ).{ label1 : Field1, label2 : 'Field 2' ....... }
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Learn and share
- Reported - view
Re: Need the Diferent Between Two dates, Without Weekend and Holidays
@RafaelMade an example
Attachment
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: About signature Questions
Maybe this can help you... https://forum.ninox.com/t/35hrz2z#m1hrax5
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: print view
Or you can use the dynamic print engine:
Attachments
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: join with conditions
@Alex Fransen Heb je een cloud abonnement? Dan kunt u mij eventueel eens uitnodigen bij uw team - dan bekijk ik het even - ik heb zelf ook een pro abonnement zodoende verliest u geen gebruiker.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: join with conditions
@Alex Fransen Iets in deze aard? let ei := "Verzekeringseis: "; let ad := "Advies: "; join(for p in range(0,cnt('prijsopgaaf offerte mail'.aantal)) do if item(text('prijsopgaaf offerte mail'.…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: join with conditions
@Alex Fransen Als ik het goed begrepen heb is "eis" een keuzeveld (choice field) met twee opties A en B ? In het ene geval moet er de tekst "verzekeringseis" voorafgaan en in het andere geval…
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
Here you find the execution context: https://docs.ninox.com/en/script/transactions/execution-context
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- 1
- Get help
- Reported - view
Re: join with conditions
Can you provide the full code so we can get more information about what you want to achieve?
- Ninox partner
- RoSoft_Steven.1
- 1 yr ago
- Get help
- Reported - view
Re: About the copy problem
@我是我的我 for non-cloud, you have to remove the do as server line and the end at the last line
- 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: 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

Re: Send array of object json with httpr

Re: Need the Diferent Between Two dates, Without Weekend and Holidays

Re: About signature Questions

Re: print view

Re: join with conditions

Re: join with conditions

Re: join with conditions

Re: Trigger after update & Alert anomaly

Re: join with conditions

Re: About the copy problem

Overview