RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1544
197
4

Joined: Sun Sep 30 17:18:00 UTC 2018

https://www.rosoft.be

My Posts

Latest Posts

Re: Problem with unique() function
If there is a choice field involved, you must use text(ChoiceField) to get the text values. I guess in your case you can use unique(text('Project Codes'.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Select from array
Spam bots are really getting clever these days....
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Select from array
You can use a temp table, like ik did in the example below:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Free text
Formula fields can also be used for that and besides they are also interactive trough formula or even html text. e.g.: html("Today it's <strong>" + today() + "</strong>") Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Different behaviour of a formula in a batch update environment
Where do you try the 'batch' update? If you do it in a button or in the console you can try like this: (once done, you can delete the button) for i in select Table1 doi.(IMAGE := importFile(i,i.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Field label vs field name
https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/labels-in-different-languages-61697a56a58512448dffd756?post=61804412da391b16aad45e3d&page=1
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Labels in different languages
Or simplyfied without a Settings table: switch clientLang() docase "en":"Company"case "fr":"Interprise"case "de":"Unternehmen"end Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Labels in different languages
You can also hide the labels(but name them in the language of the developper) of every field and put formula fields instead for displaying the label with a value depending on the language setting.e.g.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Duplicate button
In the web(cloud) version is this possible with a CSS hack. See this tread : https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/fonts-colors-and-borders-61285d0639e48338717bcd64 Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) for the groups of Contacts
@ John, Like I said before in another tread, if you want to display a value from a table trough a Dynamic choice field in the print editor, use this:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Adding values between values in a (dynamic) choice field...

Ever wanted to add a value between values in a choice field? This is possible with a Dynamic Choice Field : >Formula in the MoveUp button: Number := Number - 1.…
- Ninox partner
- RoSoft_Steven.1
- updated 2 yrs ago
- 1reply
- 273
- 3
- Learn and Share
Re: Dynamic choice fields in prints/pdf fx field
John, This will only work if you are in the table where the dynamic choice field is. Looking at your first screenshots, Your choice field is called ZipCity I suppose ?…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic choice fields in prints/pdf fx field
record(Picklist,number(ZipCity)).Topic missed a )
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic choice fields in prints/pdf fx field
record(Picklist,number(ZipCity).Topic Should do it. Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) as view filter
Cascading dynamic multiple choice fields:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: my databases are not showing in web browser
No, this is normal, only in a native app you see the my databases tab. Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: transaction timestamp
You can use a formula field with _md or _cd in. _md stands for modification date and _cd stands for creation date. Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Tab navigation by script ?
from the manual : openRecord(recordId, tabName) - opens the record, jumps to the related table and opens the given tab https://ninox.com/en/manual/calculations/reference-of-functions-and-language
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Import csv with usernames as field
The 'user' field is sort of choice field and is used in situations where you have more than one team-member in your cloud-team. The field can't be filled with text.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Print only visible fields automatically
Another approach could be. If there are few fields that need to be made invisible, you may want to opt for different print layouts. Via a button ninox will then choose the right layout to print…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Print only visible fields automatically
You can create a formula field in the print editor and use a formula like this: if [condition to show field] then [the same formula used in the form] end This will show a blank field if the…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
In essence, you get an array with all the Id's of the table when you use a select statement e.g. [1,5,100,155,255,688,697,789,790,791,792] So we have now an array of 11 values.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Thanks Fred, didn't see that.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Off the cuff.... Try this: ('Emailsend' is an extra yes/no field if you haven't got one in your table Customers) let sendmails := select Customers where 'GDPR Status' = 1 and 'Send Email' and…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Change to: let xFirst := recipient.FirstName .... Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view

1 24 25 26 27 28 62

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: Problem with unique() function

Re: Select from array

Re: Select from array

Re: Free text

Re: Different behaviour of a formula in a batch update environment

Re: Field label vs field name

Re: Labels in different languages

Re: Labels in different languages

Re: Duplicate button

Re: Choice (dynamic) for the groups of Contacts

Re: Dynamic choice fields in prints/pdf fx field

Re: Dynamic choice fields in prints/pdf fx field

Re: Dynamic choice fields in prints/pdf fx field

Re: Choice (dynamic) as view filter

Re: my databases are not showing in web browser

Re: transaction timestamp

Re: Tab navigation by script ?

Re: Import csv with usernames as field

Re: Print only visible fields automatically

Re: Print only visible fields automatically

Re: emailing list of contacts not changing the firstname in list

Re: emailing list of contacts not changing the firstname in list

Re: emailing list of contacts not changing the firstname in list

Re: emailing list of contacts not changing the firstname in list

Overview