AppSheet Barcode Transfer Workflow App

I would favour someone who describes themselves as an:

AppSheet Consultant
AppSheet Business Application Developer
Microsoft 365 / AppSheet Specialist
Inventory & Warehouse Automation Specialist

Required Skills (Must Have)
AppSheet Development ⭐⭐⭐⭐⭐

This is the most important skill.

They should have experience building:

Inventory apps
Warehouse apps
Barcode scanning apps
Multi-user applications
Workflow automation
No-Code Development ⭐⭐⭐⭐⭐

Experience with:

AppSheet
Glide (acceptable)
Other no-code business applications
Microsoft 365 / OneDrive ⭐⭐⭐⭐⭐

Must understand:

OneDrive
Excel Online
Microsoft 365 integration
File management
Folder automation
Microsoft Excel ⭐⭐⭐⭐⭐

Strong Excel knowledge is essential.

Should understand:

Excel Tables
Structured references
Data validation
Import/export
Multiple worksheets
Barcode Scanning ⭐⭐⭐⭐⭐

Must have experience with:

Camera barcode scanning
Continuous scanning
Inventory workflows
Barcode validation
AppSheet Expressions ⭐⭐⭐⭐⭐

This is critical.

Must know:

SELECT()
FILTER()
LOOKUP()
ANY()
REF_ROWS()
Virtual Columns
Actions
Bots
Automation
AppSheet Automation ⭐⭐⭐⭐⭐

Should know how to build:

Bots
Workflow automation
File movement
Notifications
Export automation
Inventory Management ⭐⭐⭐⭐⭐

This is a huge advantage.

The developer should understand:

Stock transfers
Stock on hand
Picking
Variances
Warehousing
Retail inventory
Multi-user Data Synchronisation ⭐⭐⭐⭐⭐

Must understand:

Concurrent editing
Data conflicts
Quantity aggregation
Synchronisation
Record locking
Nice to Have
SQL Databases

Useful if the project later grows beyond Excel.

Experience with:

SQL Server
Azure SQL
MySQL
Microsoft Power Automate

Helpful for future automation.

API Integration

Useful for future integration with:

Retail Express
ERP systems
Inventory systems
UI/UX Design

Should know how to design apps that work well on phones.

Retail staff should only need one or two taps between scans.

Industry Experience (Highly Preferred)

Candidates who have built:

Warehouse Management Systems (WMS)
Inventory apps
Retail apps
Stocktake systems
Pick and pack systems
Logistics applications

will likely understand your workflow much faster.

Freelancer Skill Tags

I would select these skills on Freelancer:

AppSheet
No-Code Development
Microsoft Excel
Microsoft 365
OneDrive
Inventory Management
Barcode Scanning
Mobile App Development
Database Design
Workflow Automation
Data Entry Automation
Business Process Automation
Questions Every Freelancer Should Answer

To quickly separate experienced AppSheet developers from general app developers, ask each bidder to answer these questions:

How many AppSheet applications have you built?
Have you built an inventory, warehouse, stocktake, barcode scanning, or pick-and-pack application? Please provide examples.
Have you integrated AppSheet with Microsoft OneDrive and Excel?
Have you implemented continuous barcode scanning using the device camera?
Can AppSheet safely support multiple users scanning the same transfer simultaneously? How would you prevent quantity conflicts?
How would you model multiple barcodes that map to a single Product ID?
Have you built AppSheet Bots for automatic exports and moving completed files between OneDrive folders?
What would you recommend if the app eventually grows beyond Excel to thousands of transfer lines per day?
Will you provide the complete AppSheet project, source configuration, documentation, and administrator access on completion?
What improvements would you suggest based on the specification?