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: Calendar Options Tab?
On my Ipad it displays this: Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: One to many relationship
Ben, Could this be of some help? : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-can-i-automatically-link-two-fields-from-two-tables-5c8cfc004a46f37365e3968f
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Is it just me, or has the Ninox updates and new feature releases gone... Stagnant?
I think we will jump straight to version 3 when an update comes out...
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Technical Question/ How to choose the lowest value from several fields in a record?
I your approach. Thanks Sean.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Products by date
Maybe it's a good idea to explore the build-in Invoices template. There you have a products table, customers and sales. Instead of using customers, you can use a date instead to get what you want.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Email send/sent help needed
Note that the "from" email always has to be the user-email you use to login for Ninox, maybe that's the problem?
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Technical Question/ How to choose the lowest value from several fields in a record?
Did a copy/paste too much(Ipad heh), it should be like this: let rgex:= extractx('Item price 1', 'Item price 2', 'Item price 3', 'Item price 4', regex-formula);let m := min(rgex);…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Technical Question/ How to choose the lowest value from several fields in a record?
Now I have to reach out to Sean because i thing it can be done with a regex expression and i'm not familiar with those.What I would try is to make an array with zero excluded and from that array take…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Generate list of unique choices from linked table
Yes Sean, but then you wouldn't get the records which are tripple A or double B. Only the records where A or B apear only once(unique). If that is what you mean i suppose...…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Technical Question/ How to choose the lowest value from several fields in a record?
Hi, you can use something like this: let m := min('Item price 1', 'Item price 2', 'Item price 3', 'Item price 4');if 'Item price 1' = m then'Supplier Code 1'elseif 'Item price 2' = m then'Supplier…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: scope of variables
Mel, see here : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-i-set-and-use-global-variables-5c8d389b4a46f37365e396a9?post=5c8d66b84a46f37365e396b3&page=1 Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?
If I may Sean... And this?sum((select Revenue where 'Credit To:' = 1).'Rev-Amount') 'credit to' has to be a number field or a choice field. If it is a text field you have to use number('Credit To:…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: if true then formula?
Bruce, Your solution is also right.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: if true then formula?
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Justify Form Elements with common top line
You could ajust the height of that formula field. Still this is a buggy solution because the height of that view is variable I suppose.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Formula outcome in the calendar
note: i.datefieldincalender := appointment(datetime(number(i.importeddatefield)), datetime(number(importeddatefield) + 1000 * 60 * 15)) is one line
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Formula outcome in the calendar
First, is your importeddatefield of the Date/Time type(You should see a date and the time in that field: 06-02-2020 12:00 )? datefieldincalender must be of Appointment type.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: print Ordered
Maybe in the trigger after update of the Item Status choice field. But personaly i would prefer a button.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How to remove the duplicate button in a form view?
Here's an example of an invisible formula field to hide the close form X (black background) :…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: How to remove the duplicate button in a form view?
Sorry my mistake, don't hide it, In stead You can style the formula field in a way it becomes invisible... (Background & text rgb 238 and hidden label)
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: How to remove the duplicate button in a form view?
Yes, the hidden formula field should be on every form you use where the buttons must be hidden. You could also use a global function to prevent repeatedly typing the script and call that function on…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Simple delete button for the current record
Oops...
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Simple delete button for the current record
let result := dialog("Warning", "Are you sure?", ["Yes", "No"]);if result = "Yes"alert("Deleted"); delete (this) elsealert("Canceled")end Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: if true then formula?
if checkbox then 'number field' end
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Formula outcome in the calendar
You can use the console or a button for that since triggers won't fire on importing. Afterwards you can delete the button. Something like this: for i in select yourtable doi.datefieldincalender := i.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 46 47 48 49 50 63

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: Calendar Options Tab?

Re: One to many relationship

Re: Is it just me, or has the Ninox updates and new feature releases gone... Stagnant?

Re: Technical Question/ How to choose the lowest value from several fields in a record?

Re: Products by date

Re: Email send/sent help needed

Re: Technical Question/ How to choose the lowest value from several fields in a record?

Re: Technical Question/ How to choose the lowest value from several fields in a record?

Re: Generate list of unique choices from linked table

Re: Technical Question/ How to choose the lowest value from several fields in a record?

Re: scope of variables

Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?

Re: if true then formula?

Re: if true then formula?

Re: Justify Form Elements with common top line

Re: Formula outcome in the calendar

Re: Formula outcome in the calendar

Re: print Ordered

Re: How to remove the duplicate button in a form view?

Re: How to remove the duplicate button in a form view?

Re: How to remove the duplicate button in a form view?

Re: Simple delete button for the current record

Re: Simple delete button for the current record

Re: if true then formula?

Re: Formula outcome in the calendar

Overview