Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn and share
Get help
Webinars
Service status
Documentation
All topics
Contact
Privacy
Overview
Profile
jonfusa
jonfusa
21
0
0
Joined: Wed Jan 01 00:00:00 UTC 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 and share
Get help
Webinars
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics