AppSheet Asset-Client Matcher

€8-50 EUR

In Bearbeitung

Veröffentlicht vor etwa 1 Monat

€8-50 EUR

Bezahlt bei Lieferung

I need an AppSheet automation (“bot”) that continually pairs records in my Assets table with records in my Clients table whenever either table receives a new entry. A match is defined by three fields that appear in both tables—transaction_type, assets_class and country. When all three values align, the bot should write the pair into a dedicated Matches table and shown in a dedicated view/slice. Inside that Matches table I want a Yes/No column that lets me reject the suggestion. Once edited, the choice must stay in place permanently so rejected rows do not re-appear and confirmed rows remain visible. Key things I expect from you: • Configure the AppSheet bot to trigger automatically on every ADD or UPDATE in either source table. • Build the expression logic that checks the three matching fields and writes qualified records to the Matches table. • Ensure the Matches table is fully editable for the Yes/No confirmation (by default all should be Yes) and that this flag prevents future duplicate suggestions. • Provide a short walkthrough, so I can reproduce the logic myself to a production server. You will get an access to a test environment. I already have the source tables in Google Sheets and the basic AppSheet app created; you can request editor access as soon as we start. Let me know any clarifications you need.

Automation

AppSheet Development

Projekt-ID: 40113058

Über das Projekt

7 Vorschläge

Remote Projekt

Aktiv vor 1 Monat

Möchten Sie etwas Geld verdienen?

E-Mail Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@AJDigitalWorks

I propose implementing this as a .NET (ASP.NET Core) real-time matching service that integrates seamlessly with your existing Google Sheets/AppSheet app, providing stronger control, scalability, and long-term reliability. The solution will monitor ADD and UPDATE events on both Assets and Clients records. On each change, the service evaluates the three matching fields—transaction_type, assets_class, and country—and queries the opposite dataset for qualified matches. When all three values align, a record is written to a dedicated Matches table. Each match is stored using a composite key (AssetID + ClientID) to permanently prevent duplicates. The Matches table includes a Yes/No confirmation flag (default = Yes) that remains fully editable in AppSheet. Once a match is rejected, the .NET service explicitly excludes it from all future evaluations, ensuring rejected rows never reappear and confirmed rows remain visible. This approach provides true real-time processing, idempotent logic safe for continuous execution, and centralized business rules that are easy to test, extend, and audit. It scales cleanly as data volume grows and allows future enhancements such as scoring, prioritization, or ML-based matching. AppSheet continues to serve as the UI layer with no disruption. I’m ready to start once editor access to the test environment is granted.

€30 EUR in 7 Tagen

0,0

(0 Bewertungen)

0,0

7 Freelancer bieten im Durchschnitt €27 EUR für diesen Auftrag

@anirudhat

Hi, I can help with this task. Ready to start immediately.

€8 EUR in 1 Tag

1,6

(2 Bewertungen)

1,6

@muhammadfaizanh4

Hi , Your AppSheet Development and Automation project stood out, it shows you value precision and real results. That’s exactly what I deliver. I don’t use templates. Every project has its own psychology, and success comes from understanding your intention before execution. Why clients choose me: Simplify complexity, deliver clarity. Creative data driven execution. Clear updates, early results. Work that makes you look great. My approach: Understand your vision. Build a focused action plan. Execute with full transparency. Portfolio: https://www.freelancer.com/u/muhammadfaizanh4 Each project shows results backed by strategy. Even a quick 5 minute chat can reveal how we’ll achieve measurable impact together. Let’s make your AppSheet Development and Automation project remarkable. Faizan Your Trusted Partner in Smart Execution

€8 EUR in 3 Tagen

0,0

(1 Bewertung)

0,0

@angeld07

✨✨✨✨✨✨Hola,✨✨✨✨✨✨ Puedo ayudarte a implementar una automatización en AppSheet que empareje automáticamente registros de Assets y Clients cada vez que haya un ADD o UPDATE en cualquiera de las tablas. El matching se basará en los tres campos clave: transaction_type, assets_class y country. Configuraré un Bot que evalúe ambas tablas y escriba únicamente las coincidencias válidas en una tabla Matches, evitando duplicados. Esta tabla incluirá una columna Yes/No editable, con valor por defecto “Yes”, que permitirá confirmar o rechazar sugerencias. Las decisiones quedarán guardadas permanentemente, asegurando que los matches rechazados no vuelvan a aparecer y los confirmados sigan visibles. También crearé los slices y vistas dedicadas para una visualización clara y controlada. Al finalizar, te entregaré un walkthrough paso a paso con las expresiones y la lógica utilizada, para que puedas replicar fácilmente la solución en producción. Puedo trabajar directamente en tu entorno de prueba con acceso de editor y empezar de inmediato.

€29 EUR in 7 Tagen

0,0

(0 Bewertungen)

0,0

@hassansuhail

Keeping two live tables in sync without duplicate or reappearing matches requires precise automation logic and careful state handling I can manage the full AppSheet bot setup and related views reliably. I’m experienced handling multi-trigger workflows, conditional matching, and persistent user decisions. My name is Hassan Suhail, and I bring 7+ years of experience building AppSheet automations, Google Sheets–backed apps, and rule-driven matching systems. I’ve implemented similar pairing and approval flows that stay clean and predictable as data grows. Let’s have a quick chat—I’ll walk you through the approach, share past examples, and ensure you can confidently replicate this logic in production. Regards, Hassan Suhail

€35 EUR in 7 Tagen