RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Variables: let vs var
Quoted from the 0001_Ninox-Reference database: "The 'var' statement is used to declare a variable in Ninox by assigning a value to it. It automatically assumes the data type of the assigned value.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Return/Select Record ID of a sub table
last(select ...... order by date) adding order by date will give jou the latest date.. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Two formulas updating two seperate fields in a choice field.......Help
Michael, Does this work for you? if 'Num of Curtains' = 1 thenWide_W := "1 x" + " " + Wide_Widths;Num_of_Width := "1 x"+" "+ Curt_elseif 'Num of Curtains' = 2 thenWide_W :…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to Round up to .5 or full number.
Thank you Michael, and a Happy New Year to you too.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How can you call an Apple Shortcut from the Ninox iPad app? Found the answer 😊
This is also interesting like your use case for apple users.... https://ios.gadgethacks.com/news/always-updated-list-ios-app-url-scheme-names-0184033/
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Formula to Round up to .5 or full number.
let n := Number % 1;if n = 0 thenNumberelseif n < 0.5 thenNumber - n + 0.5elseif n > 0.5 then Number - n + 1 else Number endendend
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: A personal remark
Happy New Year ! 🥂
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Guidance to build my first database
Waste-bin after clicking on the empty line ?
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Guidance to build my first database
Gregg, Thanks for the heartening words. First I“ll let you play a little more to learn more about the database, but you need to know this: You have 3 MAIN Tables in my example: To start with:…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Guidance to build my first database
👍
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Guidance to build my first database
Hi Gregg, I made an example database where I“ve pulled all my tricks out of my sleeves, and maybe it”s a little overkill, but I think this is more what you want. You can download it here: https://www.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: What is the formula to trigger a yes/no option to set up a follow-up date field 30 days from that day?
Hi, you can put this formule in the trigger after update of your Yes/No field: if “Yes / No” = true thenAppiontmentField := appointment(datetime(number(now()) + 1000 * 60 * 60 * 24 * 30),…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Using Id as record counter
Use “Record Counter” := Id = is used to compare things not to assign a value.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How to select record in linked table on iPad
Problem seems to be solved with the latest Ipad version 3.2.4
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How to select record in linked table on iPad
Seems like a bug, I can“t eighter 😤 I”ll email support for that.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Function userLang() and userLang(user) ?
I can“t get something out of it, not in the cloud(browser) and nothing in the Ipad version. I tested it like this in a formula field: let me := user(); userLang(me) and also userLang() didn”t give…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Test on empty date field failed
Like Uwe said, Or to check if someting is empty you can also use null. “Date Field” = null “Date Field” != null Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: How to sort by descending
Maybe with rsort() or sort() ? Haven“t try though.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How do I find the storage address of an image / copy image outside of Ninox ?
Jaques, Do you have a cloud subscription? I can invite you to the Webinar DE 2020 team where you will find that Reference table and alot of other examples.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How do I find the storage address of an image / copy image outside of Ninox ?
Already tried the hamburger icon in the imagefield where you have an option : Share this file... With this you can create a url to that image. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Maybe the last question of the year, cough,cough.
Michael, Suppose your form(table) where you want the button is Customers and you have a subtable(child) called Payments... You can make a button to create a subrecord like this: let currRec := Id;…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: A big shout out to RoSoft_Steven Rooryck
wow, that just made my day, thank you for those heartwarming words Michael !
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Button Script needed to open Invoice and link a regular customer.
You could use the trigger on create field of your Invoices table where you can add something like: Customer := 43 for example where Customer is the name of the related custoler table and 43 is the Id…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Note: Query values of function fields via REST API
Very nice Uwe, Thanks for sharing! Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Looking for reference material to help understand coding.
Michael, https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/list-of-statements-and-syntax-5fca2397980cb7415a3a8c33?post=5fcb5802794d8413cb5d3a31&page=1 Are you already a member?…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 36 37 38 39 40 65

Welcome to the Ninox community

RoSoft_Steven

Re: Variables: let vs var

Re: Return/Select Record ID of a sub table

Re: Two formulas updating two seperate fields in a choice field.......Help

Re: Formula to Round up to .5 or full number.

Re: How can you call an Apple Shortcut from the Ninox iPad app? Found the answer 😊

Re: Formula to Round up to .5 or full number.

Re: A personal remark

Re: Guidance to build my first database

Re: Guidance to build my first database

Re: Guidance to build my first database

Re: Guidance to build my first database

Re: What is the formula to trigger a yes/no option to set up a follow-up date field 30 days from that day?

Re: Using Id as record counter

Re: How to select record in linked table on iPad

Re: How to select record in linked table on iPad

Re: Function userLang() and userLang(user) ?

Re: Test on empty date field failed

Re: How to sort by descending

Re: How do I find the storage address of an image / copy image outside of Ninox ?

Re: How do I find the storage address of an image / copy image outside of Ninox ?

Re: Maybe the last question of the year, cough,cough.

Re: A big shout out to RoSoft_Steven Rooryck

Re: Button Script needed to open Invoice and link a regular customer.

Re: Note: Query values of function fields via REST API

Re: Looking for reference material to help understand coding.

Overview