Forum Discussion

Roy-Wanyoike's avatar
Roy-Wanyoike
Qrew Captain
20 days ago
Solved

Using one field to collect data multiple times.

In quickbase, I have a field for user and datetime. There are several project status like pending, submitted, review,approved and denied.  Everytime in the status field change I want to record who d...
Pipelines
  • Roy-Wanyoike's avatar
    Roy-Wanyoike
    19 days ago

    I did manage this without having an extra table. I just created a multiline field and enabled log entries. Then I added an extra option in my status field eg when submitted turn to review. Am using a pipeline to listen to the changes and then stamp the user who submitted and time. 

Roy-Wanyoike's avatar
Roy-Wanyoike
Qrew Captain
20 days ago

Before building another table is it not possible to listen when the status changes and records the current user and date of submission.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
20 days ago

Yes, that is easily done. You trigger the pipeline when the status field changes and copy the value of [Last Modified By] into your tracking field as to who made the last change.   You can use the Jinja expression. {{time.now}} to populate the date field or else use the [Date Modified] field to populate your Date/Time of the change field.