Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

jonfusa

jonfusa

21
0
0

Joined: 01 Jan 2014

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
- 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
- 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
- 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
- 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
- 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
- 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
- 8 yrs ago
- Get help
- Reported - view
Re: Formulas
Not = Note if someone can edit the post
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 8 yrs ago
- Get help
- Reported - view

Back to top

Overview

View all topics