RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Create subrecord automaticaly
You can do it like this: place a button in your Appointments table with the code as below: let currRec := Id;let i := (create Treatments);i.(Appointments:= currRec); i.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Displaying Multiple Image Attachments from Multiple Records
Sure, here it is.... https://www.dropbox.com/s/cmiytrif694x2oa/Enhanced_Invoices.ninox?dl=0 Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Feedback desired on database template
Birger, too bad it's locked, it would otherwise be a very good learning experience for many. But I understand it, with all the work you've put into it... Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Displaying Multiple Image Attachments from Multiple Records
PS: Used example database is the built-in Invoices template
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Displaying Multiple Image Attachments from Multiple Records
Something like this? Create as many formula fields with the code displayed like above as needed but increment the highlighted number. Let me explain: the first line 'let currRec := this;…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create subrecord automaticaly
Sorry for asking, but why would you create an emty subrecord for each appiontment? It only creates a bigger database size this way. But still, it is possible on the 'Trigger on create' field of the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Leading zero's in a number field
I think you have to format the number in the last line: let i := number(max((select Invoices).'Invoice #'));'Invoice #' := format(i + 2,"0000") Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for YTD Calculations
Shouldn't there be a 'select' statement before Invoice? sum(select Invoice where year('Date Completed' = y).'Invoice Sum') Not sure but it's worth a try. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Copy/paste fields into new tab?
When you go in administrator mode (red wrench top right) and go to edit fields, you can drag and drop (up/down) the order of the existig fields, also to your new tab. Hope that helps. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Feedback desired on database template
Thanks for sharing Birger.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
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

1 54 55 56 57 58 65

Welcome to the Ninox community

RoSoft_Steven

Re: Create subrecord automaticaly

Re: Displaying Multiple Image Attachments from Multiple Records

Re: Feedback desired on database template

Re: Displaying Multiple Image Attachments from Multiple Records

Re: Displaying Multiple Image Attachments from Multiple Records

Re: Create subrecord automaticaly

Re: Leading zero's in a number field

Re: Formula for YTD Calculations

Re: Copy/paste fields into new tab?

Re: Feedback desired on database template

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

Overview