MS ADDINS- Optional processing of blank fields !!!

I'm not familiar with AP30, however, your requirement is generally how the Add-ins work if you are using the change function. I've found its actually more of an issue if there's data in the field, and you want to blank it out using the addins.

Thanks Stephanie.

I just tried it once more, What I am trying to do is Using AP30.1, I need to update a field on AP30.5 (description field). I added it as a hidden field on AP30.1 excel template. Now according to the requirement if the Description field is blank, It should not overide the data for that Field(Description) on AP30.5, But in this particular set up it is blanking the description field on Change if the Field(Description) is blank on the Excel Template.

Sorry I can't help any further - as I said, I'm not familiar with the AP30 (.1 or .5 screen), so I don't know how add-ins would work with those. It sounds like you would need to populate all fields instead of just the ones you want to change in order to accomodate your requirement in this situation.

It sounds like you're using an Excel formula to determine whether the Descirption field should be populated? if so, then it appears you are in fact passing a null value in your AGS call and overwriting the current value.

Thanks David !!!
I was just wondering if it is possible via MS addins. i.e. if the field is kept blank it not overwrite the lawson form value and if something is written only then it should overwrite form value. Here AGS call will be taking up blank value (if the field is kept blank) and updating the form with null vaue. I am not using excel formula here.

i haven't found that possible. it changes whatever is mapped. i sort and unmap those fields that should not change.
maybe the template can have the original data for the all the mapped fields to start. it'll be a busy template and will need real time data populated.
it'll be nice if there is a magic code.

Stephanie,

In this post, you mentioned trying to blank out a field using addins. I am trying to do just that with much difficulty. I am trying to use PA52 to blank out a benefit date for a group of employees that was loaded incorrectly. They should not have gotten a benefit date at all. When I enter it, it says change complete but it doesn't blank out the field. Do you have any suggestions on how to make this work?

try entering "*BLANK" (without the double-quotes) in the field you're trying to blank. That's the value that would be entered if the user made the change directly on PA52.

what i observed is, if we don't enter anything in that particular field and upload it ...... It will automatically blank it is database.