Forum Discussion
AdamKeever1
6 years agoQrew Commander
You can use grid edit to copy & paste or on a table page you can use search & replace (you would want to make sure the report is only showing the records you want to search and replace in):
------------------------------
Adam Keever
------------------------------
------------------------------
Adam Keever
------------------------------
MarkShnier__You
Qrew Legend
6 years agoRick, I have a couple of other suggestions that I will post soon.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
Rick, I re-read your question.
I think we should start with the basics, like Adam suggested. Have you ever used Grid Edit? There are other options I can help you with if you wanted say a button to click to change the location of the record to "Studio", but it sounds like when they are put back in inventory, that there could be many different possible locations so a button solution won't work as you need to enter the location.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- RickPutnam6 years agoQrew CadetHi, Mark,
Thanks for the reply. Based on Adam's suggestion I've been experimenting with the Grid Edit. It is certainly a solution that will work though I was hoping for something still easier from a UX perspective -- but that may not be possible.
You are correct that a button that just does "Move to Studio" is probably not flexible enough for my use case. However, if you're game, I would welcome a high-level hint on how one might implement something like that.
Thanks again for taking the time to respond.
Cheers,
Rick
------------------------------
Rick Putnam
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Here is an example of the code required in a formula URL button to update a record and refresh the page.
var text URL = URLRoot() & "db" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_99=" & URLEncode("Studio");
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
In the example above field ID# 99 is being updated with the word Studio and then the page will refresh.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------