Dear experts,
I want to make field Tax Registration ID required but a single space or multiple spaces should still be considered valid input
I implemented following event handler: RowPersisting, FieldVerifying, FieldUpdated but the value of this field is always null even though I input a space character “ “
I don’t know if Acumatica might be automatically trimming whitespace inputs to null during data processing.
Have you experience this kind of issue?
Best answer by jinin
Hi
Could you please try the following?
#region UsrField1
[PXDBString(250)]
[PXUIField(DisplayName="TextField", Required = true)]
public virtual string UsrField1 { get; set; }
public abstract class usrField1 : PX.Data.BQL.BqlString.Field<usrField1> { }
#endregion
protected void SOOrder_RowPersisting(PXCache cache, PXRowPersistingEventArgs e)
{
var row = (SOOrder)e.Row;
if (row == null) return;
// Check if CustomField is null or empty
if (string.IsNullOrEmpty(row.GetExtension< SOOrderExt>().UsrField1))
{
// // Replace null or empty with whitespace
cache.SetValue<SOOrderExt.usrField1>(row, " ");
}
+13Hi
You can use field verifying event and check for null or whitespaces values as below
protected void _(Events.FieldVerifying<Location.taxRegistrationID> e)
{
if (e.NewValue is string input)
{
// Check if the input is null or whitespace
if (string.IsNullOrWhiteSpace(input))
{
//your logic
}
}
}Hope, it helps!
Hello
I input space character (“ “) but e.NewValue returns null.
What I expect: input space character (“ “) → somehow e.NewValue return “ ” instead of null
Hi
[PXDefault(PersistingCheck = PXPersistingCheck.Null)] will make make your field required and allow whitespace.
Hello
thanks for your suggestion but unfortunatelly, it doesn’t work. I input whitespace then save. I also attach screen recording in case you want to check
+11Hi
Could you please try the following?
#region UsrField1
[PXDBString(250)]
[PXUIField(DisplayName="TextField", Required = true)]
public virtual string UsrField1 { get; set; }
public abstract class usrField1 : PX.Data.BQL.BqlString.Field<usrField1> { }
#endregion
protected void SOOrder_RowPersisting(PXCache cache, PXRowPersistingEventArgs e)
{
var row = (SOOrder)e.Row;
if (row == null) return;
// Check if CustomField is null or empty
if (string.IsNullOrEmpty(row.GetExtension< SOOrderExt>().UsrField1))
{
// // Replace null or empty with whitespace
cache.SetValue<SOOrderExt.usrField1>(row, " ");
}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
