Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
jonfusa
jonfusa
21
0
0
Joined: 01 Jan 2014
Follow
My Posts
Latest Posts
Re: Formulas
3rd line is else "White" I have no idea why it keeps adding the "and year = 2006" when I attempt to paste the entire formula. Lol that's to funny
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Second line is else if Year >= 2006 and Year <= 2010 then "rgb(255,127,127)"
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
First line is 'Color Box' := if Year >= 2000 and Year <= 2005 then "rgb(0,63,255)
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
That's not the way I have it and it's not what I am pasting into the window Lol
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Lol Opps, yeah comic ... To funny I meant like this 'Color Box' := if Year >= 2000 and Year = 2006 and Year <= 2010 then "rgb(255,127,127)" else "White"
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Almost, I had to do it like this 'Color Box' := if Year >= 2000 and Year = 2006 and Year <= 2010 then "rgb(255,127,127)" else "White" Of course the White default was just a preference.…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
So, I am attempting to use a color box and set the color based on a calculation. Example: if field "year" is between 200 and 2005 I want the color box to be red,…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Not = Note if someone can edit the post
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Hi Leo, Kudos to you,the team,and Ninox.Your solution to the problem now works perfectly.I have made a not about the error behavior with the quotation marks when using Mac/iPad.…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Hello Leo, I cut n paste the code in and get, Error Unexpected symbol at line 1, column 9 I used the paste clip board and even just tried to cut n paste just the first line.…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
So, I have a field "SerialNumber" and a field "Year" The 4th digit of the serial number is a letter, and the letter signifies the year. Example: if the serial number is 24YG3A06498E,…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Also, is there a way for command a backspace or delete on a formula? Problem now is when 124 is entered and 123 was supposed to be entered, can we make a button to go back 1 space deleting the 4 so a…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Hi Alex, Thank you very much, my apologies, I was looking at this to logically & mathematically. Thank you again for tolerating my antiquated ways of thinking.
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Hi Alex, Could you collaborate please? The goal is to have 10 buttons numbered 0-9 If you press button 123 we want to put the number 123 in myfield Best Jon
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Formulas
Hi Frank, Can we build on Gsechi's post as follows. Suppose we want to make 10 buttons number 0-9 ( like a touch tone phone ) Getting the number 0-9 in field is pretty straight forward....…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Data Field Types
Hi Leo, No worries, I'm just trying to learn as much as I can and get up to speed on this coding language & protocols.Im an old MS Access database developer so this is a whole new programming…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Data Field Types
Hi Leo, Thank you for the response, here is the code that Birger Hansen emailed me which is working let thisid := _id; let m := (create ModuleID); m.(PacID := thisid); popupRecord(m.…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Function and Language Reference
Is there a command to open a table in the form view to add a new record to the table
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Data Field Types
Oppps, so it is creating a new record in the ModuleID table it's just not opening the form as if I pressed the + button in the little circle to add a record to the ModuleID table from the PacID form
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Data Field Types
I tried this command on button and can't seem to make it work. i have a table PACID with a related table ModuleID. So I added a button to the PACID and place in the button formula create ModuleID but…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Re: Data Field Types
So, I need a work around to capture duplicated entries before the record is added. The scenario: we have a inventory table which has a field for the inventory ID.…
jonfusa
jonfusa
8 yrs ago
Get help
Reported - view
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics