Auto-assigning records with a button

Question

Hi Everyone,I'm looking to add a function whereby users can click a button and the result is that a record is assigned to the user that clicked the button. The catch is, there are several parameters that users will have to evaluate on their end that we also have to find a way to evaluate on our end. The records are transcription assignments and for now I just want to test different buttons based on the length of the audio file. Length is important because all transcription assignments are typically due same day. So if it's 3 pm, then a transcriber knows they can only accept an assignment that's no longer than 25-minutes to have turned around by the time they sign off at 5 pm.So, is there a way to create a button that says, search all records on the assignments table where the status equals "Awaiting Transcription" and the audio length is less than 25, then sort for the record that was uploaded the earliest, and then assign that record to the user that clicked the button?Does anyone else do something like this?------------------------------Daniel Johnson------------------------------

MarkShnierYou · Answer

You can have a sort and filter on a report of the Unassigned Transcripts. Quickbase know the current time
ie ToTimeOfDay(now()) and so you can subtract form 5:00 pm and know if the record qualifies to pass the filter at the time of day that the report is run. So the user can be instructed to take the first one at the top of the report.

If you need a button to set a field to the current user, then you could use a URL formula for that. If you need help with that you can post back but you have to let me know how our user would assign a record manually to themselves. What kind of field are they updating?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community