Hi there,
We are trying to update field2 based on field1’s value via list action (Trigger the list action when field1 is changed). And it works well when we add the value to field1 manually. However, the list action hasn’t been triggered when we are using import data function.
Can this be fixed? And is there any alternative solution? Thanks.
@Mcyc Yes, currently import data will not trigger the list action. Please pre-fill the data in excel before importing.
@frank Thanks for your confirmation.
Lucky, I was able to figure an alternative solution out. Here to share with someone who is facing the same issue.
Although import data will not trigger the list action, we can achieve this via listen to the automatic numbering column in Sub List.
We can first set corresponding list action for the automatic numbering column in Sub List. The custom code will execute and fill the row number to the automatic numbering column after the data is imported. When the column is filled, change is detected, then the list action will be triggered.
For automatic numbering column creation, please refer to this post:
https://support.yeeflow.com/en/articles/8656682-using-custom-code-to-execute-automatic-numbering-for-sub-lists
Cheers.
