Forum Discussion
AdinelB
Mar 21, 2023Copper Contributor
Data validation multiple criteria - Ticketing system
Hi, everybody, I'm trying to mimic a task system tracker using data validation and filters and I really got stuck. So, each time I select someone to do a task from a data validation list I want ...
peiyezhu
Bronze Contributor
AdinelB
Mar 30, 2023Copper Contributor
Hi, peiyezhu,
Well, from your video it looks great. Exactly what I was looking for.
There's a lack of experience from my side when it comes to Java Script, so I really don't know how I could get this done.
Do you have any suggestion from your side? I'm really looking forward to adopt it somehow if I can have your support on this. 🙂
Thank you for your time!
Well, from your video it looks great. Exactly what I was looking for.
There's a lack of experience from my side when it comes to Java Script, so I really don't know how I could get this done.
Do you have any suggestion from your side? I'm really looking forward to adopt it somehow if I can have your support on this. 🙂
Thank you for your time!
- peiyezhuMar 30, 2023Bronze Contributor
vistit this in browser,press f12 view javascript
data initate
http://e.anyoupin.cn/EData/?s=Activity
video
//select * from Activity_Planner; cli_add_php~~ $real_table="Activity_Planner"; insert_replace($real_table); $sql="select '<u>'||rowid||'</u>' rowA,* from $real_table order by rowid;"; $result=$db->query($sql)->fetchAll(); \multiquery\display_table($sql);?> <div><b> Data_validation_multiple_criteria</b> <span>新增记录</span></div> <form method="post" action="?p=Tools/DisTbl&g=sql" autocomplete="off" > <table id="oneline"><tbody><tr><td>rowid</td><td><input type="text" name="rowid" value=""></td></tr><tr><td>Date</td><td><input type="date" name="Date" value="2023-03-21"></td></tr> <tr><td>Engineer_assign</td><td> <?php $name="Engineer_assign"; $sqlDatalist="select a.Engineer_assign from Engineer_assign a left join $real_table b using(Engineer_assign) where b.status is null or b.Status='Completed'"; echo_datalist($name,$sqlDatalist); ?> </td></tr> <tr><td>Task_description</td><td><input type="text" name="Task_description" value="aa" required=""> </td></tr> <tr><td>Status</td><td> <?php $name="Status"; $sqlDatalist="select Status from Status_of_Work"; echo_datalist($name,$sqlDatalist); ?> </td></tr> <tr><td>Other_observation</td><td><input type="text" name="Other_observation" value="bb" required=""> </td></tr> </tbody></table><input type="submit" id="submitForm" value="保存" style="height:2em"> </form> ~; cli_add_script~~ const table = document.querySelector(".main_tbl"); for (let i = 0; i < table.rows.length; i++) { const cell = table.rows[i].cells[0]; const row=table.rows[i] cell.addEventListener("click", function() { let inputs=document.querySelectorAll('form input') for(let col=0;col<(inputs.length-1);col++){ inputs[col].value=row.cells[col].innerText } }); } ~;
- peiyezhuMar 30, 2023Bronze Contributor
excel template for data initiate