![]() You could put a check mark in the invoices you want to send out at the bottom/top/both you could click an action button that passes the invoice numbers as a parameter to a blank application, where a do… while or a for… each command would live. Ideally there would be a checkbox to the left of each record. You would like to be able to select invoices 1, 2, 4-6, 10, and 14 to send, but you don’t want to send the others right now. ![]() Imagine you have a grid with a list of invoices that are ready to be emailed out. So how do you create a text box, (and later on, a calendar selector box) to show up on the page, so I can enter data once, and have it ‘mass’ update certain rows via the run button? I have been using a simple grid.I might be missing the forest for the trees here, but I’m going to ask anyway. The user then hits the customized run button, which will update all the rows with a checkbox, with the value of “almost ready”. The user will then type into the “status_text_box” a value such as “almost ready”. Let’s call the text box: status_text_box.Ī user looks at the grid and puts a checkmark next to each row that will receive the same information. However, at the bottom (or top), I would like a single text box, which a user can type into. I have a grid, with checkboxes to select which records I want to update (via the run button). The only thing I need now, is how to add a text box to a grid, that does not go on every row. Thank you so much.Īlright, with a combination of sc_select and sc_exec_sql, I am very close to completing this project. I’ve been playing with this some more… I guess now I just need a simple tutorial on how to update the database field (for all rows checked).Įverything seems to work, but I’m a complete newbie on how to insert some type of looping: “update table inventory set status=‘Deployed’” line.
0 Comments
Leave a Reply. |