RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1605
214
5

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

https://www.rosoft.be

My Posts

Latest Posts

Re: Ability to make field layout in form "static"
This is a great example of applying layout elements: https://forum.ninox.com/t/m1hrt29
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: POS System / Restaurant / Food Truck
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Sum related field with specific criteria issue
Since Proposals is a child of your Projects table, you don't need the select() function. It should work like this: sum(Proposals[Awarded].'Total Cost')
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Ninext : Debug Tracer
As always, @Jacques TUR you've been great again. Thanks for all the effort and time you put into this! Happy holidays everyone !
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Send reminder SMS
@Jack Fleming Glad you managed to get it working
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Child record table with dynamically header
This looks like an example of a CSS/JS hack, something @Jacques TUR might be able to help with?
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Select an element of choice dynamic in formula
I hadn't taken it that way anyway @Fred because I hadn't even paid attention to the above codes. Until you pointed it out and then indeed I saw it, you were also right.…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Select an element of choice dynamic in formula
@Fred You're right, the last code does work , it takes always the same value from the TabB.(with ID 4) My code takes the value from the current record in TabA where the button is pressed.…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Creating record from another table
Example code to do this : let value1 := 'field_weight_T2'; let value2 := 'field_size_T2'; (for example if you have a second field 'size') let i := create T1; i.…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Select an element of choice dynamic in formula
let y := number(Year); let c := (create TabA); c.(Year := y)
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Every day
You could add a timestamp or date when you create a new client in their form and then filter on that to get the results you want. e.g. Using a view in a dashboard or filter the table view.
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Different results using Checkbox vs Button to update text field with today() using the exact same code
It may have something to do with the execution of the triggers i guess. https://docs.ninox.com/en/script/appendix/transactions/execution-context Not sure if a trigger of a checkbox is executed on the…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Start with date in a multi line test field
@J. Espí My small contribution: You can use a second text field to fill your multiline textfield: Using this allows you to add comments through the textfield.…
Attachment
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Hiding the child table
If you want to hide tables from the left-navigation, you need to check the option 'Hidden' in the preferences of that table.
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Copy table including line items from subtable, to another table and subtable)
Yes, you forgot one line after NO := no (at the end of your code) PO := i This links the new created Line Items with the new created PO Steven
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic coloring of a number field
@Martin Mueller Create a formula field (which you can hide) and name it Double for example: let n := IdentifikationsNummer; cnt(select 'ProjektStückliste' where IdentifikationsNummer = n)>1 Then you…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Copy table including line items from subtable, to another table and subtable)
This could help you let issu := 'Issued by'; let i := (create PO); i.(Issuer := issu); for k in 'Line Items' do let no := k.NO; let qty := k.Qty; let desc := k.Description; let cost := k.…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table
You could also use the google API, then you don't need a table. Several years ago I once created a google example API database which you can find here. More info about the google distance API can be…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: Create Button PDF
@Rafael You only need one line of code: Emisiones := importFile(this, printAndSaveRecord(this, "Report_1"), "EmisionesReportOrWhateverYouWant" + ".pdf"); optional,…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Add userEmail() or field to dialog
@Alan Cooke oops, forgot to translate should have been 'EMAIL TO' instead
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Add userEmail() or field to dialog
@Alan Cooke I extended the code to check if the field CC is empty or not. If Empty the code stops to fill the CC field. function sendmail(send : text,ccReceiv : text,receiv : text,subj : text,repo :…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Sum of "Hours" up to "todays hours"
May I also suggest folowing videos Ninox recently adds new videos from time to time.
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Add userEmail() or field to dialog
Not sure if I understand your question... Do you want to know who the user is with the userEmail() function and display his email in a formula field? Do you want it to popup in your dialog?…
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@Kent Signorini Thanks for the perfected addition
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view
Re: OpenAI - GhatGPT
Well, it is even useful to generate Regex code...
- Ninox partner
- RoSoft_Steven.1
- 2 yrs ago
- Get help
- Reported - view

1 16 17 18 19 20 65

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: Ability to make field layout in form "static"

Re: POS System / Restaurant / Food Truck

Re: Sum related field with specific criteria issue

Re: Ninext : Debug Tracer

Re: Send reminder SMS

Re: Child record table with dynamically header

Re: Select an element of choice dynamic in formula

Re: Select an element of choice dynamic in formula

Re: Creating record from another table

Re: Select an element of choice dynamic in formula

Re: Every day

Re: Different results using Checkbox vs Button to update text field with today() using the exact same code

Re: Start with date in a multi line test field

Re: Hiding the child table

Re: Copy table including line items from subtable, to another table and subtable)

Re: Dynamic coloring of a number field

Re: Copy table including line items from subtable, to another table and subtable)

Re: Mileage Chart Spreadsheet to Ninox Table

Re: Create Button PDF

Re: Add userEmail() or field to dialog

Re: Add userEmail() or field to dialog

Re: Sum of "Hours" up to "todays hours"

Re: Add userEmail() or field to dialog

Re: Two Serious Problems... Required Fields & Trigger on new record/update

Re: OpenAI - GhatGPT

Overview