Forum Discussion

Mer's avatar
Mer
New Contributor II
2 years ago

Import form cells using excel template - Validations help request

Hi All!  We're trying to import form data via excel template, but the load is not validating certain tokens such as WF assigned entities and template name. Is there a way of adding validations/stati...
Forms
ckattookaran's avatar
ckattookaran
VIP

There is a readtable range method in the brapi utilities, you could use that and then get the field values and perform a validation. I guess you might have to do this in the event handler to prevent the next step (depending on how you are loading the data).

Mer's avatar
Mer
New Contributor II
2 years ago

Thanks! The problem is that BRApi.Utilities.ReadExcelTableRangeContent and BRApi.Utilities.SaveTableRangeContent are only available for type TableRangeContent, and not for FormRangeContent.

  • jrk's avatar
    jrk
    New Contributor III
    8 months ago

    Mer - Were you able to resolve this? Even with Can Load Unrelated Entities set to False and Entity Assigned to parent WF, this setting only works for Import type.

    I hope OS enables, Can Load Unrelated Entities even for Input Form like adjustment type which has this option enabled from V8