Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

'execute an action on a set of rows' but with auto-filled data in key column

Hello everyone,

I am currently using a form (Update Device Data) to update the owner of a device in another table (Devices Data) based on the asset tag (which is key in both tables). 

But I have some device types that don't have an asset tag label on them and are identified only based on serial number.

Both 'asset tag' and 'serial number' columns have a data validity condition based on the device type selected in the form. Knowing this, I can't have the asset tag autofilled based on serial number so on form submit the key value will be blank.

I tried to create an action that checks and updates the asset tag BEFORE updating the owner of the device, but I guess that doesn't work (or maybe I'm not doing it right).

Checking the 'monitor' option of the automation bot I can see the asset tag is correctly updated (see below), but when running the 'update owner' action the output data is blank. Also when testing the bot, this specific action returns a generic error.

 

"Failed: Error: 'Execute an Action on a Set of Rows' Data action 'Update Owner' for table 'Update Device Data' failed with exception Cannot get key values when Parent or ChangeImage are null. "

Based on how many times I got this error I understood that the parent key is "null", but I'm not sure why it detects it as null if it's not at the moment the action is ran.

 

 

NOTE: the action works if manually ran from the app, I already tested this to make sure my action formulas are correct

To give you an example, this is what I want to do:

- user fills the form and selects device type (i.e. Windows laptop), selects a serial number or asset tag (based on what the device has in the 'devices data' table) and an owner for it.
- an automation runs and updates in 'devices data' the 'owner' for that specific device

This works if I have only one condition to be checked. If I look for serial number x, I need 'device data' to have 'serial number' as key column, otherwise I get an error. 
Same logic applies for 'asset tag'.

I need to be able to update owner for a specific device based on either serial number or asset tag.

Am I missing something or having a blank key value, even for a short time, doesn't work?

Thank you!
Razvan

 

0 1 189
1 REPLY 1
Top Labels in this Space