How to Build a Web Intake Workflow with Claris Studio, FileMaker, and Claris Connect

Teams often ask for “an online form,” but that usually isn’t what they truly need.

What they really need is a workflow that collects information, checks it, sends it to the right place, adds details, updates records, and shows the current status to the right people.

This is why Claris Studio stands out when you see it as more than just a web form tool. You can share Studio forms with your team or anyone who has the link. Claris presents Studio as a platform for collecting, viewing, and analyzing data, which can also be used in custom apps.

For many implementations, the strongest pattern is:

  • Studio for capture
  • FileMaker for business logic and system-of-record behavior
  • Connect for orchestration and cross-system flow

A practical use case: vendor onboarding intake

Vendor onboarding is a good example because it has all the right ingredients:

  • external submission
  • inconsistent source data
  • duplicate risk
  • internal review
  • approvals
  • status tracking
  • follow-up tasks

That makes it better than a trivial demo.

The target architecture

Here is the core pattern:

External submitter

   ↓

Claris Studio form

   ↓

Claris Connect flow

   ↓

FileMaker

– validation

– dedupe

– vendor creation or update

– review tasks

– status management

   ↓

Claris Studio views/hubs

– intake queue

– review queue

– status visibility

This setup works well because Studio is great for easy, web-based data capture, while FileMaker is better for handling records and enforcing processes. Connect links the two when you need to move, change, or automate data.

Two valid data ownership models

Before building anything, decide where the real record begins.

Model 1: FileMaker-first
The Studio form writes into a FileMaker-connected data source, and FileMaker is the source of truth from the start.

Model 2: Studio-first, then promoted to FileMaker
The Studio form creates a Studio-side record first, and Connect later transforms that submission into operational records in FileMaker.

Both models can work. However, if your workflow involves important business data like vendors, clients, orders, or compliance records, starting with FileMaker is usually the safer choice for the long term.

Why Connect should be treated carefully

Claris Connect can be useful here, but the boundaries matter.

The Claris FileMaker connector works with hosted FileMaker apps and requires at least FileMaker Cloud or FileMaker Server 21.1.0. Claris also points out that the connector does not yet support direct access to Claris Studio tables. So, you should not expect one connector to handle every type of data in the same way.

Claris also documents that when working with FileMaker through Connect, the target app must have both Data API and OData privileges enabled, and those services must also be enabled on the host.

Details like this are important to highlight in a real implementation guide.

Design the schema before the form

A common mistake is building the intake form first and only later figuring out how the data fits into the system.

It’s better to define the operational schema before anything else. For a vendor onboarding workflow, a basic structure might be:

Intake_Request

– RequestUUID

– SubmittedAt

– SubmittedByName

– SubmittedByEmail

– CompanyNameRaw

– TaxIDRaw

– RequestType

– RawPayloadJSON

– ProcessingStatus

– ProcessingError

– RelatedVendorUUID

 

Vendor

– VendorUUID

– LegalName

– NormalizedTaxID

– PrimaryEmail

– Status

– CreatedAt

 

VendorContact

– ContactUUID

– VendorUUID

– FullName

– Email

– Phone

 

ReviewTask

– TaskUUID

– RequestUUID

– AssignedTo

– TaskType

– TaskStatus

– DueDate

 

StatusHistory

– HistoryUUID

– RequestUUID

– OldStatus

– NewStatus

– ChangedAt

– ChangedBy

Two fields here matter more than they may seem:

RawPayloadJSON gives you an audit-safe copy of exactly what came in.

ProcessingStatus and ProcessingError help you track the workflow, which is important when something goes wrong.

Build the Studio form for clean capture, not maximum data collection

Once you have the schema, designing the form gets easier.

A good intake form doesn’t try to gather every detail. It collects just enough clean information to start the process, leaving space to add more details later if needed.

That usually means:

  • Prefer controlled values over free text where possible
  • Separate public-facing labels from internal field naming
  • Avoid exposing operational fields on the intake form
  • Collect enough to deduplicate and route, not enough to re-create the entire back office

Studio forms can be shared broadly, including with anonymous users via a link, which is why form discipline matters.

A useful Connect flow pattern

Here is the shape of a practical flow:

Trigger: New intake record created

   ↓

Validate required fields

   ↓

Normalize values

– trim whitespace

– normalize email case

– strip punctuation from tax ID

   ↓

Check for existing vendor

   ↓

If vendor exists:

   update/attach to existing

Else:

   Create new vendor

   Create primary contact

   Create review task

   ↓

Write result back to intake record

– processed

– needs review

– duplicate found

– error

The real technical value isn’t in the visual flow, but in clearly separating each step.

Validation is not the same as normalization.
Normalization is not the same as deduplication.
Deduplication is not the same as approval.

The clearer you make these boundaries, the more reliable your workflow will be.

A FileMaker script parameter pattern worth using

When Connect or another process hands work to FileMaker, JSON parameters are usually cleaner than trying to overload single text parameters.

For example:

{

 “requestUUID”: “2C8A0A6E-85A3-4C3C-A8C0-41F9A88D4E10”,

 “submittedByEmail”: “ap@vendorco.com”,

 “requestType”: “New Vendor”,

 “source”: “Claris Studio”

}

Then the receiving FileMaker script can parse predictably:

Set Variable [ $requestUUID ; JSONGetElement ( Get ( ScriptParameter ) ; “requestUUID” ) ]

Set Variable [ $email       ; JSONGetElement ( Get ( ScriptParameter ) ; “submittedByEmail” ) ]

Set Variable [ $type        ; JSONGetElement ( Get ( ScriptParameter ) ; “requestType” ) ]

Set Variable [ $source      ; JSONGetElement ( Get ( ScriptParameter ) ; “source” ) ]

This isn’t advanced code, but it’s a reliable habit for implementation.

A dedupe pattern that is better than exact-match thinking

Relying only on exact matches is rarely enough for intake workflows.

A more useful pattern is to check some combination of:

  • normalized company name
  • normalized tax ID
  • primary email domain
  • known aliases or alternate names

This approach helps you handle different outcomes more effectively:

  • exact match, attach to existing
  • probable match, send to review
  • no meaningful match, create new

This is where FileMaker really proves its value. When cross-record logic is important, it’s best to keep the decision-making in the FileMaker app.

Make the workflow idempotent

This is one of the most practical lessons to include because many “working” intake flows fail here.

Never assume a submission is processed exactly once.

A safer design includes:

  • a stable external submission identifier
  • a processed timestamp
  • a processing status field
  • a retry-safe script or flow path
  • duplicate detection for the intake record itself

That way, if a flow retries or a user resubmits, the system can recognize the event without creating a mess.

Status visibility matters almost as much as capture

Once the workflow runs, Studio becomes useful again as the visibility layer.

You can create views or hubs that show:

  • Unprocessed intake
  • Duplicate review queue
  • Vendor setup in progress
  • Awaiting approval
  • Completed onboarding

That creates a much better operational surface than an email chain or a spreadsheet export.

Security and access notes

If you are using Connect with FileMaker, Claris documents that both Data API and OData access must be enabled appropriately. OData is a REST-based standard for querying and updating hosted FileMaker data, and the general OData workflow includes finding and modifying records, as well as running FileMaker scripts via API calls.

That does not mean every intake workflow should become an API-heavy project. It means your architecture should be intentional about privileges and integration points.

Closing thought

The right way to frame a Studio intake project is not, “How do we put a form on the web?”

It is, “How do we build a reliable intake pipeline?”

Studio gives you a clean web-facing start.

FileMaker gives you durable logic and operational control.

Connect gives you orchestration when the workflow needs to move, transform, or notify.

That is the version readers can actually implement.

 

AFD Case Study

 

OVERVIEW

 

AFD has been the leading provider of display showcases for over 100 years. They operate on a very large scale and can supply tens of thousands of cases upon demand.

AFD are a family-run company that provides a complete line of high-quality showcases, which can be used to display all kinds of products, including jewelry, antiques, collectibles, and more. Cases are rented for trade shows and exhibitions across the United States.

Exhibitors consider AFD to be the top choice for satisfying all exhibition needs; from thousands of display cases at major jewelry industry trade shows to a single showcase at a private auction, they provide exhibitors and show managers with personalized, professional service and high-end products. They are the official showcase provider for the country’s most renowned trade shows.

PROBLEM

 

AFD faced three situations calling for a change. First, their core order tracking system needed significant upgrades and did not have the required capabilities. Second, the company wanted to add a web portal to support clients, present their wide range of showcases, and allow online ordering. Third, the company wanted a new, modernized system to automate processes, track inventory and assist in these transitions.

TASK

 

In looking for a replacement system, AFD reached out to many vendors to offer alternative approaches for modernizing their system. A key requirement was having up-to-the minute inventory control over multiple warehouses and active venues at any given time. In addition, since the company offers rentals not final sales, the company required a sophisticated inventory forecasting system to know the availability of every case for many months in advance.

The primary task was for Kyo Logic to develop a design for this tracking system in conjunction with AFD leadership. The business requirements were very detailed and precise reflecting the century of experience that AFD has in this business. In addition, Kyo Logic planned the design interface for a customer portal that would allow clients to handle orders online. Given the detailed logistics associated with this nationally scoped rental system, the integration requirements were extreme.

Finally, AFD wanted a control system to support hundreds of clients while onsite at a show. Technicians are texted a link to the service ticket (this step supports multiple languages, so these texts are sent in the technician’s primary language). The technicians can then update the status of the ticket and even add notes in their web browser.

The most recent addition is the ability for AFD customers to design their both layout through the web portal. Booth designs are sent to the AFD support team with detailed instructions on exactly where each case should go in the booth. This negates the need for hand-written layout designs and removes the guesswork from the process, saving hundreds of hours.

PROCESS

Kyo Logic worked closely with AFD to plan the new system and then built the core order processing system. This work included a multi-member development team working in Claris FileMaker in addition to integrating with other vendors such as payment processing banks, and other accounting systems. The initial system was developed in conjunction with the customer web portal. By business necessity, the system went live quite early in the process and led to a lot of learning on demand as process requirements emerged. Kyo Logic worked very closely with AFD during this period and continuously managed to improve timeliness of reporting and access to real-time statistics about case availability.

RESULTS

The new system now handles all elements of the case rental business. The web portal handles a third of all orders and the system works in a reliable and timely manner in a very high volume environment. The cloud-based system is available 24/7 and operates anywhere across the nation. A challenge has been the quality of wireless service at live conferences and shows. Kyo Logic continues to work with AFD to identify solutions to this essential wireless problem at shows. 

Currently, the company is having record rentals and the integrated operating environment has allowed the company to operate with a lean staff while maximizing utilization of its case inventory. Not only can the company forecast demand by case type for future shows, but it can also forecast inter-warehouse transfers. In addition, warehouse schedules are displayed on large monitors allowing staff to manage loading priorities. All this happens in a mostly paperless environment.