Validate Phone checks that a phone number is assigned to a carrier and shows its line type. It does not prove who owns the number.
Before you start
Account: a Loopster-provided ClearoutPhone account (listed on Connections) or your own ClearoutPhone account. A column's Account block shows which one it uses.
Input: the row needs a phone number.
Important: on Loopster's account, runs are paid from your wallet. Check Auto-run at the top left of the toolbar before you run anything. See Run columns safely: Auto-run, test one row, then run the rest.
How do I connect my own ClearoutPhone account?
ClearoutPhone already runs on a Loopster-provided account, listed on Connections with Account type Loopster-provided and Status Connected. To use your own account instead:
Open Settings, then Connections.
Click Create.
In the Connect an account window, find ClearoutPhone in the list and click it.
Follow the steps that open for ClearoutPhone.
Then open the column's settings: the Account block shows which account the column uses, with a Manage accounts link. See Connections: Loopster-provided accounts and your own.
How do I use Validate Phone?
Click Add column, then Add enrichment.
Open the Enrich tab and search for ClearoutPhone or Validate Phone.
Choose Validate Phone. It can also be listed as Validate phone number.
Map the input or inputs the panel shows: click an input, press
/and pick a column. See Map an enrichment's inputs.Click the arrow next to the main button and choose Add column without running.
Click the play button on one row, then double-click the cell to read the result.
To run the rest, click the play button on the column header, read the cost in the Run column dialog, and choose Run all N empty rows.
How do I check it worked?
Double-click a cell.
The details show the fields of the result. Hover a field and click Add to column to put it in its own column. See Put a result's fields into their own columns.
Troubleshooting
Quick answer
Auto-run is off, or the column was added without running.
A required input or setting has no value (the panel footer warns).
The cell says Error: open it and read the message. Then check the ClearoutPhone connection under Settings, then Connections.
Nothing happens, or the cells stay empty
What you see: The column exists, but no row has run.
Why it happens: Auto-run is Off (the app says "New rows and values will not run on their own"), or you chose Add column without running.
What to do: Click a row's play button, or use the column header's Run column dialog. See Why didn't my column run?.
The footer says "Select a column for … before running"
What you see: A warning such as "Select a column for … before running." in the panel footer.
Why it happens: A required input or setting (marked with *) has no value. An input can be empty even when a suggestion names a column.
What to do: Click the input, press / and pick a column from the list. Do not close the list with Esc: a / or @ is then left in the field as plain text.
My cells say Skipped
What you see: Skipped in the cells.
Why it happens: Skipped means "Did not run because of filters or missing dependencies."
What to do: Double-click the cell and read the message. Check that every input is mapped to a column, and look under Run Settings for Add run condition ("Only run if this formula resolves to true.").
My cells say Unsatisfied
What you see: Unsatisfied in the cells.
Why it happens: Unsatisfied means "Enrichment ran correctly, but output didn't match expected format."
What to do: Double-click the cell and read the message. Check the input values in that row, and test one row before you re-run many. See What a cell's message means.
A cell says Error
What you see: The cell says Error, and the footer shows a count such as "1 cell failed".
Why it happens: Error means "Crashed, something went wrong." The message is in the cell it happened in.
What to do: Double-click the cell and read the message. Then open Settings, then Connections, and check the Status of the ClearoutPhone connection. Read the line under each option in the Run column dialog before you re-run.
I am not sure which ClearoutPhone account a column uses
What you see: You want to know whether a column runs on Loopster's ClearoutPhone account or on your own.
Why it happens: ClearoutPhone can run on a Loopster-provided account or on your own account, and the column's Account block shows which account it uses.
What to do: Open the column's settings and look at the Account block. To add your own account, use Settings, then Connections, then Create. Connecting your own ClearoutPhone account avoids the charge for runs on it.
The result did not change after I edited an input
What you see: A finished cell keeps its old result after you change an input.
Why it happens: With Auto-run on, Keep existing results is ticked: "Only errored, empty and new cells run. A completed answer is left alone even when one of its inputs changes."
What to do: Double-click the cell and click Re-run this cell, or click the play button on the column header and choose Overwrite all N rows in the Run column dialog. Read the line under each option first.
What does it cost?
On your own ClearoutPhone account, nothing is charged from your wallet. On Loopster's account, runs are paid from your wallet. Look for a price next to the action in the Add enrichment panel (not every option shows one) and hover it: the tooltip says it runs on Loopster's account and is paid from your wallet. Before you run, the Run column dialog shows the cost: Maximum cost on a paid column. Connecting your own ClearoutPhone account avoids the charge. See Your wallet and keeping spend under control.
Good to know
Validate Phone is the only ClearoutPhone action in Loopster. It is in the Enrich tab.
It can be a waterfall step. See Find people's contact details with waterfalls.
It does not create rows in your table.
It does not write outside Loopster.