Clay Icon
Join the Community
02 Support

Updating Cells in a Table by Replacing Existing Values

Avatar of Tyler C.Tyler C.
Ā·
Ā·

Can you write to a secondary table but instead of starting a new row it replaces a cell in an existing column and row?

5 comments

  • Avatar of Clay T.
    Clay T.
    APP
    Ā·
    Ā·

    Hey Tyler, great question! Unfortunately, it doesn't behave in such way just yet but we've submitted requests to consider that an option.For now, combining it with Lookup Row or Multiple Rows would be the fastest way to append existing records based on a matching value

  • Avatar of Tyler C.
    Tyler C.
    Ā·
    Ā·

    So you can use the look up rows to change another table?

  • Avatar of Clay T.
    Clay T.
    APP
    Ā·
    Ā·

    It helps you append data, meaning pull values from one table to another based on a match.

  • Avatar of Clay T.
    Clay T.
    APP
    Ā·
    Ā·

    Here's a quick video about the integration -> Ā Here's a videoĀ and ourĀ docs page forĀ LookupĀ Record!

  • Avatar of Tyler C.
    Tyler C.
    Ā·
    Ā·

    Thatā€™s awesome. Iā€™ve used lookup many times before but never thought of using it to pull information into the table. Iā€™ve always used it as a database check. This will work perfectly.