# 🤔 How to? (w/ pics): Create Action to search rows (based on user specific info), select result to copy/paste to another row **URL:** \ **Category:** Ask for Help\ **Created:** [May 12, 2024, 7:28pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301 "2024-05-12T19:28:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [May 12, 2024, 7:28pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/1 "2024-05-12T19:28:26Z")
Hello. We need to create an Action that will: 1. use the input of the Ticker and Expiration columns to give us a result. 2. copy the Order ID from that search and 3.Paste it into the Matching Trade column before we submit. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5de685f3a4084c65daf4fccbbe265dfbc484aa9.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/884850d712d9c242bc3ce9fd9e7356b8d8ff9c5d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df32d2a99833c2675974bdaca3468f05d0dd4ab1.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 13, 2024, 12:32am UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/2 "2024-05-13T00:32:59Z")
How do you “search” though? If it’s through a query, your Iron Condor action can retrieve info from that Query (via Single Value columns), and set that value to the entry column(s) through a set column action. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [May 20, 2024, 7:41pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/3 "2024-05-20T19:41:14Z")
By “query” are you meaning creating a query column in the table (versus “query” meaning filter on the screen)? For the set column action, do you have input on how to properly execute the action. I see where to copy to clipboard, but I don’t see how to paste to another row. Thanks for the reply! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 20, 2024, 11:34pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/4 "2024-05-20T23:34:31Z")
I mean a query in the table. You would have a query targeting the table where you store trades, and filter by Expiration Date and Ticker (I assume this is what you mean). Then what do we do with the Entry Timeframe, Transaction Type, Live or Sim, Strategy Type? Next, what if you have multiple rows that match your “search”? Which rowID do we take? ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [May 20, 2024, 11:45pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/5 "2024-05-20T23:45:10Z")
Thanks for the clarification. _**TD: You would have a query targeting the table where you store trades, and filter by Expiration Date and Ticker (I assume this is what you mean).**_ Yes. That is correct. _ **TD: Then what do we do with the Entry Timeframe, Transaction Type, Live or Sim, Strategy Type?** _ In this case the Expiration Date and Ticker are usually going to show just ONE other rowID. In this situation, the two transactions are “sharing” a dollar amount and only two can share that amount at the same time. Multiple rows are unlikely to match the search so based on the query only two should appear, that is either side 1 or side 2. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 21, 2024, 11:07pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/6 "2024-05-21T23:07:12Z")
Then you can use the query approach, use a single value column to get back the order ID tied to the result, and use a set column action (providing the user clicks a button) to set it to the matching trade column. Though I’m not sure why you need a matching trade entry. Can you explain that? ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [May 22, 2024, 5:20pm UTC](https://community.glideapps.com/t/how-to-w-pics-create-action-to-search-rows-based-on-user-specific-info-select-result-to-copy-paste-to-another-row/73301/7 "2024-05-22T17:20:36Z")
Thanks for the information. To answer your question: The matching trade entry was being used to connect the trades together when searched. The Matching ID is the Order ID from the 1st trade. If we are searching for Trade 2, the Matching ID would tell us which was Trade 1. This is useful because both sides are not always entered on the same day, so Matching ID helps to quickly find Side 1.