> ## Documentation Index
> Fetch the complete documentation index at: https://formhug.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Public Query

> Let participants look up their own scores, results, or status without contacting you — turn any form into a secure, self-service query page.

**Public Query** turns your form submissions or Excel data into a shareable lookup page. Visitors enter their ID, email, or any field you choose — and see only the one record that matches. No account needed, no browsing other people's data.

<img src="https://mintcdn.com/formhug-8bc4ebd1/jqNWpxPOb-DUimlg/images/public-query/public-query.jpg?fit=max&auto=format&n=jqNWpxPOb-DUimlg&q=85&s=6bf523c07673c026dd64052ae9b108df" alt="Public Query overview" width="2774" height="1876" data-path="images/public-query/public-query.jpg" />

For a product-level overview of lookup pages, see <a href="https://formhug.ai/public-query" target="_blank">Public Query</a>. If your data starts in Excel, read <a href="https://formhug.ai/blog/build-lookup-page-from-excel" target="_blank">how to build a lookup page from Excel</a>. For results-style pages, the examples on <a href="https://formhug.ai/blog/share-exam-scores-competition-results-online" target="_blank">sharing exam scores</a>, <a href="https://formhug.ai/blog/share-race-results-with-participants-online" target="_blank">race results</a>, and <a href="https://formhug.ai/blog/share-training-course-results-without-student-portal" target="_blank">training course results</a> show common lookup patterns.

## What You Can Do with Public Query

| Scenario            | Search by               | Result shows                         |
| ------------------- | ----------------------- | ------------------------------------ |
| Competition results | Participant ID          | Ranking, total score, judge feedback |
| Exam scores         | Student ID + Email      | Score, GPA, program details          |
| Registration status | Registration ID         | Status, event details, next steps    |
| Application results | Application ID or Email | Status, reviewer notes               |

## How to Create a Public Query Page

<Steps>
  <Step title="Choose a data source">
    Select a data source for your Public Query page:

    | Source           | Best For                                     |
    | ---------------- | -------------------------------------------- |
    | **Select Form**  | Query data collected through a FormHug form  |
    | **Import Excel** | Query data you already have in a spreadsheet |

    <img src="https://mintcdn.com/formhug-8bc4ebd1/jqNWpxPOb-DUimlg/images/public-query/create-public-query.jpg?fit=max&auto=format&n=jqNWpxPOb-DUimlg&q=85&s=b5b8c54bde610a7ea1d5423394b7a6c1" alt="Create Public Query — choose a data source" width="2068" height="1580" data-path="images/public-query/create-public-query.jpg" />
  </Step>

  <Step title="Import your data (Excel only)">
    <Note>
      If you selected **Select Form** in the previous step, skip this step — FormHug maps the fields automatically and takes you straight to Step 3.
    </Note>

    Upload your Excel file, preview the data, then assign a data type to each column (Name, Short Text, Number, etc.) and click **Import Data**.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/jqNWpxPOb-DUimlg/images/public-query/create-from-excel.jpg?fit=max&auto=format&n=jqNWpxPOb-DUimlg&q=85&s=b8f1a39358b3111f4ec0b7214aed628d" alt="Excel import — set column types" width="1588" height="1238" data-path="images/public-query/create-from-excel.jpg" />

    Excel file requirements:

    * Format: `.xls` or `.xlsx`
    * No merged cells
    * File size: 5 MB or less
    * Rows: 6,000 or fewer
    * Columns: 100 or fewer
  </Step>

  <Step title="Set search conditions">
    Choose which fields visitors must enter to look up their record — for example, Participant ID alone, or ID + Phone for added security.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/jqNWpxPOb-DUimlg/images/public-query/pulic-query-setting-search-condition.jpg?fit=max&auto=format&n=jqNWpxPOb-DUimlg&q=85&s=d0d014849d7132253733811b9c3b7f81" alt="Public Query search page" width="2490" height="1666" data-path="images/public-query/pulic-query-setting-search-condition.jpg" />

    <Tip>
      Use fields that are unique to each person — like a registration ID or phone number — so only the right person can access their record.
    </Tip>
  </Step>

  <Step title="Configure results display">
    Choose which fields to show in the result. Each field has three display options:

    <img src="https://mintcdn.com/formhug-8bc4ebd1/jqNWpxPOb-DUimlg/images/public-query/public-query-setting-results-display.jpg?fit=max&auto=format&n=jqNWpxPOb-DUimlg&q=85&s=82233b50ad4444c2ce81092f0e01a78c" alt="Results display settings" width="2240" height="1942" data-path="images/public-query/public-query-setting-results-display.jpg" />

    | Setting                            | Description                                                                                                    |
    | ---------------------------------- | -------------------------------------------------------------------------------------------------------------- |
    | **Field Highlight**                | Pin a key field (e.g. Ranking, Score) to display prominently at the top of the result, with large colored text |
    | **Privacy Protection**             | Partially mask the field value — for example, a name displays as `Emm*****son`                                 |
    | **Allow users to edit this field** | Let the visitor update this field directly from the result page                                                |

    Fields not included in the result are never exposed to visitors.
  </Step>

  <Step title="Share your query page">
    Your Public Query page gets a dedicated shareable URL (e.g. `formhug.ai/os/EOGiNy`). Copy the link from the top bar and distribute it — anyone with the link can open it and search, no account required.

    <Card title="Try a live example" icon="arrow-up-right-from-square" href="https://formhug.ai/os/EOGiNy" target="_blank">
      Open a real Public Query page — enter participant ID **P001** to see a sample result
    </Card>
  </Step>
</Steps>

## Related

<CardGroup cols={2}>
  <Card title="Booking" icon="calendar-check" href="/features/scenes/booking">
    Accept appointments and manage availability
  </Card>

  <Card title="Form Data & Submissions" icon="table" href="/features/data/submissions">
    Manage and export form submission data
  </Card>

  <Card title="Build a Lookup Page from Excel" icon="file-excel" href="https://formhug.ai/blog/build-lookup-page-from-excel" target="_blank">
    Turn spreadsheet rows into a private, self-service search page
  </Card>

  <Card title="Share Exam Scores Online" icon="graduation-cap" href="https://formhug.ai/blog/share-exam-scores-competition-results-online" target="_blank">
    See how Public Query works for score and result lookup pages
  </Card>
</CardGroup>
