Forum Discussion

SystemAdmin7's avatar
SystemAdmin7
Qrew Cadet
6 years ago

Adding to UserList using webhooks or automations or URL

Hello! I am trying to use an API_EditRecord to add a user to a userlist.
Background: I have a table of Sales Appointments, there can be multiple people assigned to an appointment, and we need confirmation from each of them. The goal is to create a form rule stating that unless the user has confirmed the appointment they are unable to see the contact details. The confirm button would either trigger the user details to be input in to a "Confirmed by Rep" field, or to create a record in a second table that captures the record owner details and then takes that data and pushes it back to the Sales Appointments table.

Problem, any time I use the "Edit Record" call it replaces any user that was already in the "Confirmed by Rep" field. Is there way to add a webhook or an action or use a different call to append the new user instead of replacing the existing user?

------------------------------
Amanda Luna
------------------------------
  • I suspect that the API is doing what you are telling it to do which is to populate a field the the value of the field.  Instead, you should make a new formula field which combined the existing user list with the new value and then puts that into the field.

    The formula would be something like

    ToUserList([your existing user list field], ToUserList([Additional User field]))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • SystemAdmin7's avatar
      SystemAdmin7
      Qrew Cadet
      Worked great! Thank you!

      ------------------------------
      Amanda Luna
      ------------------------------