RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1552
200
4

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

https://www.rosoft.be

My Posts

Latest Posts

Re: Copy Data from one for into another then open that new record
Something in the line of: for i in select tableOne do (here we take all the Id's from tableOne one at a time in variable i and loops one by one) if i.Archive = "Yes" then (this checks if the current…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Copy Data from one for into another then open that new record
openRecord(i)
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: how do i achieve nested grouping?
In table view you can create a extra column (chose formula in the show/hide menu if you click on a column header)with the concatenation of the two columns you wisch to order.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
Another approach would be to use a formula field which give a warning there are duplicated fields, which would not require triggers. let a := upper(myField1); let b := upper(myField2);…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Best incremental Invoice formula
I use a separate table with the numbering for the invoices, estimates,orders. Example: https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: One Other Question....
Why two invoice tables? You could also hide some irrelevant fields for this user in the Display field,if settings of the fields. So the layout simplifies more. Steven.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Field type changing
This one does: https://ninox.com/en/manual/tables/update-multiple-values Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: POS System / Restaurant / Food Truck
Nick, findings?
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Learn and share
- Reported - view
POS System / Restaurant / Food Truck

Posted a POS System template in the WEBINAR EN 2021 team. Take orders from 48 products divided over 6 categories. Easily compose your own products.With login system for employees.Print bills easily.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- 5replies
- 748
- 1
- Learn and share
Re: Test if File(this,file.png) exists
contains(concat(files(this)), "Image Name") should work. Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT
Maybe this workaround ? It's not that pretty but it could work....…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Emoji list.
It's also in the EN Team: 0_instructions ninox
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Autonumber a filtered list
Second line: text(record(Counters,1).Result) Doesn't it work with this?: i.(Number := text(record(Counters,1).Counter)); Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Email question...
Michael, If you put the email adresses in your choice field instead of the names, you could use this code: let sender := userEmail();let receiver := text(ChoiceFieldContainingTheMembersEmail);…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Make an image flash (repeat)
Once you put your picture in a image field, you can chose to share (you get a link) your picture in the top right menu of your image field. I guess this would do the trick?
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Trying to filter an if statement, I've tried pretty much everything I can think of...
In a formula field in the customers table:let me := this; let c := cnt(select Ads2 where Id= this and Stage = 1); if c < 3 then styled("Order shortage!","red") end : this is not tested,…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Make an image flash (repeat)
Mel, You could use CSS to do that and display it in a formula field. Here's an example: Put this in a multiline text-field (which you can put in a settings-table so you need only one general text…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auswahlmenü und Script
Hallo, Sie können diese Formel im Trigger nach Aktualisierung des Feldes Kategorie verwenden: switch Kategorie docase 1: 'Produkte-Nr.' := nullcase 2: ( let c :…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Background Color
Maybe because the formula field is styled in the settings of that field...(where you can chose also the style of the border etc.)
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How to display a date based on a choice field
Is it a choice field or a multiple choice field? How would it return one date with a multiple choice field if more can be selected.... This works for me with a choice field: let d := Date;…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How to display a date based on a choice field
while weekdayName(weekday(Date)) != ....
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How to display a date based on a choice field
Something with: while weekday(Date) != text(Days) do Date := Date + 1 end this is not tested, it might need some tweaking... Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field as a switch question.
Alain, At first glance I thought this wouldn work but yeah, it also works your way. chosen(Lined_Per_Width,"Interlining") gives Yes if the button is active and No if it's not.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field as a switch question.
Michael, This works: let c := 0;let mc := text(Lined_Per_Width);if contains(mc, "Interlining") then c := c + 25end;if contains(mc, "Curtains over 2.7") then c := c + 55end;if contains(mc,…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field as a switch question.
It should be : let mc := text('Multiple Choice');
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view

1 32 33 34 35 36 63

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: Copy Data from one for into another then open that new record

Re: Copy Data from one for into another then open that new record

Re: how do i achieve nested grouping?

Re: How I can prevent duplicate records being added?

Re: Best incremental Invoice formula

Re: One Other Question....

Re: Field type changing

Re: POS System / Restaurant / Food Truck

Re: Test if File(this,file.png) exists

Re: HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT

Re: Emoji list.

Re: Autonumber a filtered list

Re: Email question...

Re: Make an image flash (repeat)

Re: Trying to filter an if statement, I've tried pretty much everything I can think of...

Re: Make an image flash (repeat)

Re: Auswahlmenü und Script

Re: Background Color

Re: How to display a date based on a choice field

Re: How to display a date based on a choice field

Re: How to display a date based on a choice field

Re: Choice field as a switch question.

Re: Choice field as a switch question.

Re: Choice field as a switch question.

Overview