We're on Vantage 8.03 and I am trying to implement a customisation that will allow entry on an unbound field that updates to another table on Kanban Receipts. This all works fine but I want to reset the field to null or .0 after the entry and all I can get is it to default to 0.0.
I don't want the leading 0 as in the past we've had too many errors with data entry not noticing where the cursor is, etc - can anyone help? Thanks.
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, Mar 17, 2015 at 9:05 AM, tracy.smith@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p></p><p><span>We're on Vantage 8.03 and I am trying to implement a customisation that will allow entry on an unbound field that updates to another table on Kanban Receipts. This all works fine but I want to reset the field to null or .0 after the entry and all I can get is it to default to 0.0.</span></p><p><span><br></span></p><p><span>I don't want the leading 0 as in the past we've had too many errors with data entry not noticing where the cursor is, etc - can anyone help? Thanks.</span></p><p></p> </div> <div style="color:#fff;min-height:0;"></div>
Make the unbound field a character field. Then convert that character-number to a numeric field in your code.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 17, 2015 9:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Set Decimal to Null or .0
We're on Vantage 8.03 and I am trying to implement a customisation that will allow entry on an unbound field that updates to another table on Kanban Receipts. This all works fine but I want to reset the field to null or .0 after the entry and all I can get is it to default to 0.0.
I don't want the leading 0 as in the past we've had too many errors with data entry not noticing where the cursor is, etc - can anyone help? Thanks.
Jose - It's not an issue the value being in the data but we've had issues in the pasts where when the cursor defaults to the left side of the 0 and they just type the value when they and tab off without checking! I know it's down to user attention at point of entry but we have experienced issues with operators in the past and I was just trying to minimise problems. I appreciate your response.
Thanks Vic, I'll look into that option.
From: "tracy.smith@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Tuesday, March 17, 2015 9:35 AM
Subject: RE: [Vantage] Set Decimal to Null or .0
#ygrps-yiv-1020026559yiv2488380424 .ygrps-yiv-1020026559yiv2488380424ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424photo-title
a,
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424photo-title a:active,
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424photo-title a:hover,
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424photo-title a:visited {
text-decoration:none;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424attach-table div.ygrps-yiv-1020026559yiv2488380424attach-row {
clear:both;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424attach-table div.ygrps-yiv-1020026559yiv2488380424attach-row div {
float:left;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424ygrp-file {
width:30px;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424attach-table div.ygrps-yiv-1020026559yiv2488380424attach-row div div a {
text-decoration:none;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424attach-table div.ygrps-yiv-1020026559yiv2488380424attach-row div div span {
font-weight:normal;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 div.ygrps-yiv-1020026559yiv2488380424ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1020026559
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424 –
#ygrps-yiv-1020026559yiv2488380424ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp hr {
border:1px solid #d8d8d8;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp #ygrps-yiv-1020026559yiv2488380424hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp #ygrps-yiv-1020026559yiv2488380424ads {
margin-bottom:10px;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp .ygrps-yiv-1020026559yiv2488380424ad {
padding:0 0;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp .ygrps-yiv-1020026559yiv2488380424ad p {
margin:0;}
#ygrps-yiv-1020026559 #ygrps-yiv-1020026559yiv2488380424 #ygrps-yiv-1020026559yiv2488380424ygrp-mkp .ygrps-yiv-1020026559yiv2488380424ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1020026559