Start free

Ask Jev for Yes, No, a score or a pick

After this lesson you can add a Yes / No, Score or Pick one column that asks Jev a question about each row, and filter on the answers.

1:31 video with captions, written steps and transcript. Checked against Duckrow on October 3, 2026.

0:00 / 1:31

Narration: preview voiceA private equity team maps add-on targets for an HVAC platform. The companies are example data.

The short answer

Click Add column and choose Yes / No, Score or Pick one. Write the question Jev asks about each row; for Score, list the levels lowest first, and for Pick one, the options. Each row's answer is a plain value, so you can filter on it. It costs 1 credit an answer on Duckrow's Jev, charged only when Jev answers, and nothing with your own Jev key.

Step by step

  1. 1Add the columnAdd column, then Yes / No, Score or Pick one under Enrich (1 credit a row).
  2. 2Write the questionJev reads the row's other columns. Score: list levels lowest first, one per line (2 to 10). Pick one: options, one per line.
  3. 3Run on new rowsTurn it on to answer imports and searches as they arrive.
  4. 4Run and filterRun from the column header. Answers are plain values: filter with Equal to.
  5. 5Use your own keyIn the dialog, choose Use your own key, paste your Jev API key and save; answers are then free.

Try it in Duckrow

About five minutes, in your own workspace.

  1. Add a Yes / No column to a table with company names.
  2. Ask a question you could check by hand.
  3. Run it on a few rows and check two answers yourself.

You're done when your table has a Yes / No column you trust enough to filter on.

Check what stuck

Three quick questions. Nothing is saved.

  1. 1. You want to rank leads Low, Medium or High. Which column?

  2. 2. Jev can't answer a row. What does it cost?

  3. 3. How do you keep only the Yes rows?

Transcript

0:00One question, every row

Some questions just need a yes or a no. Jev columns ask one question about every row, and give you an answer you can filter.

0:10Three kinds

Click add column. Under Enrich, there are three Jev columns: yes or no, score, and pick one, each one credit a row. Choose yes or no.

0:22Write the question

Type the question Jev asks about each row, using its other columns: does it do commercial HVAC work? The question becomes the column name. Run on new rows answers new imports as they arrive. Then add the column.

0:39Run and filter

Run it from the column header. Each cell shows running, then a plain yes or no. That means a filter, equal to yes, keeps exactly the commercial firms.

0:51Score and Pick one

Score works the same way, with levels you list lowest first, such as low, medium and high. Pick one chooses from your options, one per line.

1:02What it costs

Each answer is one credit on Duckrow's Jev, charged only when Jev answers. With your own Jev key, answers are free.

1:12Recap

To recap. Yes or no, score and pick one ask Jev one question per row. The answers are plain values you can filter. One credit an answer, free on your own key. Next, spend nothing on rows Jev rules out.