RoSoft_Steven's Profile | Ninox community

Badges

Latest Posts

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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Choice field as a switch question.
let c := 0; let mc := concat('Multipe Choice'); if contains(mc,"Extra Length") then c := c + 25 else if contains(mc,"Extra width") then c := c + 55 else if contains(mc,"Option 3") then c := c+ 33 ...…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Fx Field to Display Date or Text Depending on If Statement
let dateAsTxt := text(format(date(Orders.'Date Deposit Paid'), "DD/MM/YYYY"));
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Fx Field to Display Date or Text Depending on If Statement
Try this: let wavDep := text(Orders.'Waver Deposit');if wavDep = "Yes" then "N/A"else if wavDep = "No" then text(Orders.'Date Deposit Paid') else if wavDep = null then "Incomplete" end endend Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: follow up on previous question and problem with equation
Indeed, the previous post combined with this one gives Alains' result... thanks Alain.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: follow up on previous question and problem with equation
let LastDate := max('Rope Inspection Record'.'Inspection Date');first((select 'Rope Inspection Record' where 'Inspection Date' = LastDate).Result) It's possible you don't need the first() in the code.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Variables: let vs var
If you have a cloud subscription, I can invite you to that team, All I Need is your Email linked to Ninox.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
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

1 36 37 38 39 40 66

Welcome to the Ninox community

RoSoft_Steven

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.

Re: Choice field as a switch question.

Re: Fx Field to Display Date or Text Depending on If Statement

Re: Fx Field to Display Date or Text Depending on If Statement

Re: follow up on previous question and problem with equation

Re: follow up on previous question and problem with equation

Re: Variables: let vs var

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?

Overview