RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Programmable fields?
Or you could use a formula field to label your field (those are programmable) and hide the labels of the fields theselves. you even can style the labels with the formula fields.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Count Function
Try this: cnt( select 'Class Pupil event attendance' where Attended = "Yes") Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Problem with last()
Something like this? let last:= last(select Table) select Table where Id= last . Amount Need some tweaking i guess, can't try here. I'm on my phone... Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
In order to het the tags the color, you must assign the color in the multiple choise ( buttons) field itself. But if jou use the join method, you can use the style configuration of the formula field.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
Does the code consist of 2 lines as above? Because between the two " there is a hard return to get another line in the result.Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
Ps: you can scroll in that formula field also.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
Try this: join(chosen('Multiple choice')," ")in a formula field. Also make sure the hight of that field is high enough. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
You can use a formula field to show wich choises are chosen if that's more suitable for you. Just put that fields name in the formula and you get a list of the selected items. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to count the records and percentage
Are you always starting with the first left selection of the Multiple choice field? Is so, you can use this little hack. Make sure the highest value is for the first selection,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Neuen Wert bei Mehrfachauswahl hinzufügen
No problem, we have all kind of languages here...😊
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Neuen Wert bei Mehrfachauswahl hinzufügen
Versuchen Sie dies mit einer Taste (button): Mehrfachauswahlfeld := if contains(concat(numbers(Mehrfachauswahlfeld)), "2") thenunique(for i in numbers(Mehrfachauswahlfeld) doif i !…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Problems using an image field
Mr. K. , It's also a change request database where you can put ideas or wiches for future updates.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Problems using an image field
Mr. K. Best is to send an email to support and ask for an invitation for the Ninox BETA team. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How do I get this space field to the left of the image field?
See : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/problems-using-an-image-field-5dc76da62b59cc4051a282b8?post=5dc7ef2939e54c3dd149d8ba&page=1 Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Problems using an image field
You can shift an image field more right with another image field. I use an spacer image with RGB background 238 to imitate the grey background of the form,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Protecting Editable Fields - Best practice
Which version do you use? If it's the cloud (thus web) it's better to use the build in user roles. Else if it's a stand alone version (Ipad,Mac), you will need a sort of login screen first with an…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
Sure, Let's say we make use of a seperate table for settings with only one record called SETTINGS and a Yes/No field called EDITTABLE. Then you can put this in the "writable if" section of the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
You can make the whole table also "writable if"....
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Protecting Editable Fields - Best practice
Halio, I would go for option 3 , but I would make use of the field option 'writable if' in combination with a Yes/No field to protect those fields from input instead of using an extra equivalent…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: exclude equal date
To count only unique values in that list is much easier , use this:cnt(unique((select Table1).Date)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Ah, misunderstood your question first, try this in a formula field: let c := 0;let dates := unique((select Table1). Date;for i from 0 to cnt(dates) doif cnt(select Table1 where Date = item(dates,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Sorry...
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
Uh Oh, Nick again....😵
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: exclude equal date
cnt(select Table1 where Date != d) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 54 55 56 57 58 65

Welcome to the Ninox community

RoSoft_Steven

Re: Programmable fields?

Re: Count Function

Re: Problem with last()

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: How to count the records and percentage

Re: Neuen Wert bei Mehrfachauswahl hinzufügen

Re: Neuen Wert bei Mehrfachauswahl hinzufügen

Re: Problems using an image field

Re: Problems using an image field

Re: How do I get this space field to the left of the image field?

Re: Problems using an image field

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: Protecting Editable Fields - Best practice

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Re: exclude equal date

Overview