Clay Icon

how to get row number?

Β·
Β·

how to get row number?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To get the row number in Clay, you can use the row limit feature. Here's how: 1. Open your table 2. Click the Rows button in the toolbar at the top of your table 3. In the popup, you'll see options for Starting row and Row limit 4. The Starting row field shows you the current row number 5. You can adjust the Row limit to control how many rows are displayed This allows you to see and manage row numbers in your table. If you need further assistance, please ask to talk to a person for human support.

  • Avatar of Alex
    Alex
    Β·
    Β·

    how to get row number to be used in a filter condition

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To use the row number in a filter condition in Clay, you can follow these steps: 1. Click the Rows button in the toolbar at the top of your table. 2. Note the Starting row number in the popup. 3. Use this number in your filter condition. For example, if you want to filter rows based on their position, you can create a filter using the row number as a condition. This can be useful for conditional runs or filtering specific sections of your table. Remember, you can also use conditional formulas in the "Only run if" box of an enrichment column's Run Settings to create more complex filters based on row numbers or other criteria. If you need more detailed assistance, please ask to talk to a person for human support.

  • Avatar of Stefano
    Stefano
    Β·
    Β·

    Hi Alex, thanks for reaching out! You can filter a specific range of rows by clicking the "Rows" button in the top left corner of your screen. Enter the number of the first row you want to view, then specify how many rows to display after that.

    (84 kB)
    Image

    Let me know if this helps.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.