I would like to create a global variable that I can use in other component. below is the code inside the custom manipulator.
last_name := substring(form_name1, find_dash +1, find_space -1);
@last_name := last_name;
In a different component, I would like to call it. this is the code for the custom filter: text like '%@last_name%';
I would like to keep records that contain that last_name value. It could be in the beginning, middle or the end.
Will appreciate any help with why the codes are not working at they should. Thank you!