Base in which to create the record.

Determines which App Extensions will appear in the dropdown below.

Base in which to create the record.

Pick an Airtable table that you want to search.

Pick a field from the base to match against the search value.

The value of unique identifier for the record.

(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

Limit the search to a specific view. Useful for sorting results.

Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

Only Active locations listed.

Use Adjustment for the normal lifecycle of buying/selling goods. Use Physical Count when a manual count reflects a new inventory amount - item(s) must be In Stock to use this type.

Only Active locations listed.

The number of items affected by the adjustment or physical transfer. Can support up to 5 digits after the decimal point.

If True, a physical count update will be ignored if it doesn't change the quantity. Defaults to True.

Only Active locations listed.

The order must be open to create an invoice (Must select a location first).

The customer who receives the invoice. This customer data is displayed on the invoice and used by Square to deliver the invoice.

A user-friendly invoice number that is displayed on the invoice. The value is unique within a location. If not provided when creating an invoice, Square assigns a value.

Max length: 65536 characters.

The delivery method used to send the invoice, reminders, and receipts to the customer. For invoices with automatic payments, this field must be set to Email.

A completed payment to apply the refund (Your account must have at least one completed payment to set this Action).

Amount in the lowest monetary value (in the US, this is cents). If left blank, the refund will be issued for the original full payment amount.

A description of the reason for the refund.

An optional team member to associate with this refund

An invoice can only be sent when certain conditions are met. For an example, the order in the invoice cannot be associated with another invoice. The customer of the invoice recipient must have either an email address or phone number. If the invoice is set to be delivered via email, the customer must have an email address on file

Only Active locations listed.

Determines which App Extensions will appear in the dropdown below.

If all the below fields are empty, the most recently created customer will be returned. If more than one customer is found, the most recently created customer will be returned. If more than one field is used, a customer must match all fields.

Phone number must be in E164 format with a leading + sign and country code. For example, +12061112222 or +0012061112222.

Only Active locations listed.

If all the below fields are empty, the most recently created order will be returned.

Only Active locations listed.

If all the below fields are empty, the most recently created order will be returned.

Must be 30 characters or less

Required if line items are added

Required if line items are added

Required if line items are added

Must contain only alphanumeric characters, dots, underscores, and hyphens.

Required if discounts are included unless a percent is specified below

Required if an amount is specified above

Required if including discounts

Required if discounts are included unless an above amount is specified

Must contain only letters, numbers, dots, underscores, and hyphens.

Required if a tax is included

Required if a tax is included

Must contain only alphanumeric characters, dots, underscores, and hyphens.

Pick the Airtable base containing the records you wish to update.

Pick the Airtable table containing the records you wish to update.

Pick the Airtable record that you wish to update.

API docs for Airtable are located here https://airtable.com/api

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

Base in which to create the record.

Pick an Airtable table that you want to search.

Pick a field from the base to match against the search value.

The value of unique identifier for the record.

(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

You can optionally limit the search to a specific view id.

Only Active locations listed.

Only Active locations listed.

Only Active locations listed.

The team member must be bookable for the service that will be part of the new appointment.

The customer to receive the service provided by the assigned or selected team member.

Example: "Next Saturday at noon." The appointment will be booked for the first available time slot within 32 days of this date.

Any other info you want to note about this customer.

An optional second ID you can set to associate the customer with an entity in another system.

Provide either this field or Display Name.

Reference to associate an entity in another system with this order.

Used to notify the buyer of payment.

The type of external payment received. Currently only external payments are supported.

An optional note to be included with the payment of the order.

Amount in the lowest monetary value (in the US, this is cents).

Either Line Item Name or Catalog Item Variation ID is required.

Either Line Item Name or Catalog Item Variation ID is required.

Only Shipment orders are supported at this time.

Provide either this field or Customer ID.

Choose a discount type to enter discount details.

Required if including discounts

Required if Fixed Percentage was selected above.

Required if Fixed Amount was selected above. Amount in the lowest monetary value (in the US, this is cents).

Required if Fixed Amount was selected above.

Required if a tax is included

Required if a tax is included

Any other info you want to note about this customer.

An optional second ID you can set to associate the customer with an entity in another system.

API docs for Square are located here https://docs.connect.squareup.com/api/connect/v2

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

If all the below fields are empty, the most recently created appointment service will be returned.

This will return appointment service variations that include this text in their name, description, or abbreviation.

Select a location that offers the service. Only Active locations listed.

If all the below fields are empty, the most recently created customer will be returned. If more than one customer is found, the most recently created customer will be returned. If more than one field is used, a customer must match all fields.

Phone number must be in E164 format with a leading + sign and country code. For example, +12061112222 or +0012061112222.

An optional second ID you can set to associate the customer with an entity in another system.

Any other info you want to note about this customer.