- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 10:21 AM
I am trying to import data in Hardware [alm_hardware] table. There is one field on the form called 'stockroom' (referenced from alm_stockroom). I am not able to update this field. Any suggestions as in why it is happening would be great. I am importing data from excel and in import set the data is coming correctly in the source field.
As this is a reference field, tried to get the sys_id from the referenced table by using onBefore script but still it is not updating.
One strange behaviour observed though that when i try to upload same data again this field value is getting updated. But i want it to update at the first attempt.
Solved! Go to Solution.
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-25-2020 12:42 AM
I am able to update the stockroom field. Making asset state to In use and then updating the stockroom value from onBefore script helped.
Also , updated choice action to 'ignore' and referenced field value to 'name'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 11:50 AM
I do this exact upload, State field must be updated with "In Stock" and then the stockrooms need to be already created in your table. Just upload with a "stockroom name" already created. If you are not using actual stockrooms from the table then I wouldn't use it in the upload. But to put it In Stock you have to reference a Stockroom. Then I use choice action reject since I am picking from my stockroom reference table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-25-2020 12:42 AM