RoSoft_Steven's Profile | Ninox community

Badges

Latest Posts

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
- 6 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
- 6 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
- 6 yrs ago
- Learn and share
- Reported - view
Re: Simple delete button for the current record
Oops...
- Ninox partner
- RoSoft_Steven.1
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: if true then formula?
if checkbox then 'number field' end
- Ninox partner
- RoSoft_Steven.1
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: print Ordered
Hi, Try this code in the button, is this what you're looking for? : delete (select 'Print Que');let curRec := this;let s := 'Item Status';let k := (select 'Invoice Items' where Invoice = curRec and…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: A few questions about form layout
For a button you can use a formula field, hide the label, style like you want and use the 'on click' event. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: print Ordered
De nada.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Assign RGB color to a choice field
You have to click on the big colored circle above the 'clear'-option
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Console vs Button on Click using Mac App.
Could it be that the script behind a button is executed locally and script via the console, on the server? can you execute your code in the button forced to be executed on the server and check the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: print Ordered
There may be other ways to do this but I've made an example with a sort of staging table 'Print Que' where you copy the desired records to and use this for printing out.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Script to set reference field to empty
With 0 (zero) i guess?
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Global script definitions
Is this what you're looking for? https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-i-set-and-use-global-variables-5c8d389b4a46f37365e396a9 Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to manage two-way multiple table references?
Have you already looked at the Invoice template? I think this could be comparable with your case, where 'plots' are invoices and 'inputs' are the articles. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
On my computer now. Did try this: let curRec := Estimation.Id;let me := first(select Estimation where Id = curRec);popupRecord(record(Estimation,me)) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
I see, it's because the relation is 1:N (more estimates are possible/invoice) maybe this will work: let curRec:= this;let me := first(select Estimation where Id = curRec);…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
Try this: popupRecord(record('Estimation',Estimate.Id)) Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Disable the create record on the left
I think not possible. Only both buttons with User management, identities and rights (Cloud version)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to pick up single value from related table
@dyrck, Is this thread similar to your situation? : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/formula-for-a-button-5e2c61c34e9f3771e468dd3e?…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Make colour of text in report change dependant on data in field
Maybe like this: Below the link to this example: https://www.dropbox.com/s/3utfz27wcw52flv/Colors.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create a button to open directly the pdf
Yes, printRecord(recordId, layoutName) - Creates a PDF from the given record and print layout name. e.g. printRecord(this,"Invoice") Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for a Button
Hi, you can use as many commands you like, just put a ; at the end of the line. eg. --- 'Payment term' := Client.'Payment term'; VATNo := Client.VATNo; 'payment method' := Client.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Creating a random serial number / reference number in inventory
An if you are using a cloud subscription, you could ask support@ninoxdb.de to add you to the Webinar EN 2020 team where you can find a lot of usefull examples.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 50 51 52 53 54 66

Welcome to the Ninox community

RoSoft_Steven

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

Re: print Ordered

Re: A few questions about form layout

Re: print Ordered

Re: Assign RGB color to a choice field

Re: Console vs Button on Click using Mac App.

Re: print Ordered

Re: Script to set reference field to empty

Re: Global script definitions

Re: How to manage two-way multiple table references?

Re: Formula Button to open a specific record

Re: Formula Button to open a specific record

Re: Formula Button to open a specific record

Re: Disable the create record on the left

Re: How to pick up single value from related table

Re: Make colour of text in report change dependant on data in field

Re: Create a button to open directly the pdf

Re: Formula for a Button

Re: Creating a random serial number / reference number in inventory

Overview