Hello,I would like to record the changes made to a multiple choice text field, the data I would like logged is date and time, and quickbase user that modified the record. I have this already for two other tables. The table that i'm trying to add this automation to has an existing automation for this same action, but I am having difficulties replicating the change, I'm not sure what I'm doing wrong. At the moment the log will only record one of the multiple choice options, so everytime I change the status it will show the quickbase user who made the change, and the date and time of change but the status is the same. There are 6 multiple choice options, and the log will only record the details of choice 1.------------------------------Keji Dalemo------------------------------

If you were saying that the automation is only triggering when a particular choice is selected then I would review the automation and look at what your trigger conditions are.If you were saying that the automation is triggering properly except the information being written is incorrect then you need to look at the action step in the automation to see what it is set to do. If you still can't figure it out can you post some screenshots of the automation trigger and the automation step?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hello Mark, I hope you recall this issue, I attach the screenshots of the automation settings: The field that I want changes logged for is the 'CA Review' field. In screenshot 91, at the bottom, you see the log and that all changes recorded are only for one of the options for the 6 available in the multiple choice text field.. Regards ----------------------------------------------------------------------------------- Keji Dalemo (Ms) CTU Manager ICNARC Napier House 24 High Holborn London WC1V 6AZ Tel 020 7269 9288 Email keji.dalemo@icnarc.org www.icnarc.org Do not send patient identifiable data in any email correspondence. Attachments must meet NHS encryption requirements. See below for more details. This email (and any attachments) may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email in error), please notify the sender immediately and destroy this email. Any unauthorised copying, disclosure or distribution of the material in this email is strictly forbidden. In addition, please note that patient identifiable data (e.g. name, date of birth, NHS Number) should not be included in any email correspondence. Any trial/study patients should be referred to by their trial/study number. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________

Can you provide a screen shot which shows the filter. You will need to twist open the > to see the filter.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hello Mark, Do you mean the Action Filter Records: Regards ----------------------------------------------------------------------------------- Keji Dalemo (Ms) CTU Manager ICNARC Napier House 24 High Holborn London WC1V 6AZ Tel 020 7269 9288 Email keji.dalemo@icnarc.org www.icnarc.org Do not send patient identifiable data in any email correspondence. Attachments must meet NHS encryption requirements. See below for more details. This email (and any attachments) may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email in error), please notify the sender immediately and destroy this email. Any unauthorised copying, disclosure or distribution of the material in this email is strictly forbidden. In addition, please note that patient identifiable data (e.g. name, date of birth, NHS Number) should not be included in any email correspondence. Any trial/study patients should be referred to by their trial/study number. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________

Can you also show what the Trigger is?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Automation guidance for recording changes to a multiple choice field

11 Replies

MarkShnier__You
Qrew Legend
3 years ago
If you were saying that the automation is only triggering when a particular choice is selected then I would review the automation and look at what your trigger conditions are.

If you were saying that the automation is triggering properly except the information being written is incorrect then you need to look at the action step in the automation to see what it is set to do.

If you still can't figure it out can you post some screenshots of the automation trigger and the automation step?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- KejiDalemo
  Qrew Member
  3 years ago
  
  Hello Mark,
  
  I hope you recall this issue, I attach the screenshots of the automation settings:
  
  The field that I want changes logged for is the 'CA Review' field. In screenshot 91, at the bottom, you see the log and that all changes recorded are only for one of the options for the 6 available in the multiple choice text field..
  
  Regards
  
  -----------------------------------------------------------------------------------
  Keji Dalemo (Ms)
  CTU Manager
  
  ICNARC
  
  Napier House
  
  24 High Holborn
  
  London
  
  WC1V 6AZ
  
  Tel 020 7269 9288
  
  Email keji.dalemo@icnarc.org
  www.icnarc.org
  
  Do not send patient identifiable data in any email correspondence. Attachments must meet NHS encryption requirements. See below for more details.
  
  This email (and any attachments) may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email in error), please notify the sender immediately and destroy this email. Any unauthorised copying, disclosure or distribution of the material in this email is strictly forbidden.
  
  In addition, please note that patient identifiable data (e.g. name, date of birth, NHS Number) should not be included in any email correspondence. Any trial/study patients should be referred to by their trial/study number.
  
  ______________________________________________________________________
  This email has been scanned by the Symantec Email Security.cloud service.
  For more information please visit http://www.symanteccloud.com
  ______________________________________________________________________
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Can you provide a screen shot which shows the filter. You will need to twist open the > to see the filter.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Automation guidance for recording changes to a multiple choice field

11 Replies

Related Content

Odd question looking for guidance

Button: save the new record and edit the new record

How to add list of attachments on child record from parent record

Get latest child record on parent record

New Form - Show Create Record button

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection