Gokor•11mo ago

Looking for paid long-term help with workflow automation

Hello, I am developing a google appsheet app for my company and I am reaching out to get support to develop it. I know exactly what I want, and even have a developer with some backend code to assist us. I would like to schedule a call to discuss exactly what I need, and if you are able to assist me with this on a longer term hourly-pay basis. Please let me know if you are interested!

7 Replies

Harini•11mo ago

hi @Gokor - are you looking to use BuildShip with google appsheet? Could you share more about any specific usecase?

Gokor•11mo ago

May I ask what buildship is?

Harini•11mo ago

@Gokor you can check it out here https://buildship.com its a low-code backend/API/scheduled job builder and you are on its discord channel 😄

BuildShip

Low-code visual way to build your app's backend workflows, APIs, scheduled jobs, cloud functions - powered by AI.

Gokor•11mo ago

I searched "low code" in the Discord discovery server when joining here haha. I don't need any backend API, although Buildship's tools look very convenient! Our workflow is currently: Vercel Backend -> PostgresSQL Database -> Google Appsheet

Gokor•11mo ago

To give details on my project, I am developing a workflow solution for my automotive repair company. We repair anywhere from 30-40 cars on a weekly basis, and I want to track how long vehicles are spending in each phase of the repair process. Attached is a PDF with more information on the individual phases. Each vehicle is represented by a workfile with an "RO Number", for example one vehicle is RO 4993. The database on appsheets contains all the information about the workfile, and information will be provided either by my company's employee's, or via API that is uploaded directly to the PostgresSQL database (this doesn't involve you). To complete each phase, there are certain requirements; checkboxes, signatures that must be signed, surveys that must be completed, and more.

1d88ba11-6f93-45e8-9...

Gokor•11mo ago

@harini All the data currently is going to be saved in a single table. As we get more data in the future, we can split tables up but it is not necessary for now. Here is the current database structure:

model documents {
  id                                 String             @id @db.Uuid
  version_code                       VersionCode
  version_number                     Int
  status                             DocumentStatus
  created_on                         DateTime
  repair_order_id                    String
  arrival_odometer_reading           Int
  departure_odometer_reading         Int?
  owner_last_name                    String
  owner_is_claimant                  Boolean?
  estimator                          String
  gross_total                        Float
  net_total                          Float
  supplemental_total                 Float?
  dropoff_phase_status               DropoffPhaseStatus @default(NotStarted)
  dropoff_phase_completed_on         DateTime?
  dropoff_phase_completed_by         String?
  blueprint_phase_alignment          Boolean            @default(false)
  blueprint_phase_prescan            Boolean            @default(false)
  blueprint_phase_insurance_approval Boolean            @default(false)
  blueprint_phase_completed_on       DateTime?
  blueprint_phase_completed_by       String?
  parts_phase_parts_received         Boolean            @default(false)
  parts_phase_completed_on           DateTime?
  parts_phase_completed_by           String?
  bodymech_phase_tasks_completed     Boolean            @default(false)
  bodymech_phase_completed_on        DateTime?
  bodymech_phase_completed_by        String?
  paint_phase_approval_received      Boolean            @default(false)
  paint_phase_completed_on           DateTime?
  paint_phase_completed_by           String?
  reassembly_phase_postscanned       Boolean            @default(false)
  reassembly_phase_completed_on      DateTime?
  reassembly_phase_completed_by      String?
  post_sublet_phase_completed_on     DateTime?
  post_sublet_phase_completed_by     String?
  qc_phase_completed_on              DateTime?
  qc_phase_completed_by              String?
  delivery_phase_completed_on        DateTime?
  delivery_phase_completed_by        String?
  delivery_phase_notes               String?
}

model documents {
  id                                 String             @id @db.Uuid
  version_code                       VersionCode
  version_number                     Int
  status                             DocumentStatus
  created_on                         DateTime
  repair_order_id                    String
  arrival_odometer_reading           Int
  departure_odometer_reading         Int?
  owner_last_name                    String
  owner_is_claimant                  Boolean?
  estimator                          String
  gross_total                        Float
  net_total                          Float
  supplemental_total                 Float?
  dropoff_phase_status               DropoffPhaseStatus @default(NotStarted)
  dropoff_phase_completed_on         DateTime?
  dropoff_phase_completed_by         String?
  blueprint_phase_alignment          Boolean            @default(false)
  blueprint_phase_prescan            Boolean            @default(false)
  blueprint_phase_insurance_approval Boolean            @default(false)
  blueprint_phase_completed_on       DateTime?
  blueprint_phase_completed_by       String?
  parts_phase_parts_received         Boolean            @default(false)
  parts_phase_completed_on           DateTime?
  parts_phase_completed_by           String?
  bodymech_phase_tasks_completed     Boolean            @default(false)
  bodymech_phase_completed_on        DateTime?
  bodymech_phase_completed_by        String?
  paint_phase_approval_received      Boolean            @default(false)
  paint_phase_completed_on           DateTime?
  paint_phase_completed_by           String?
  reassembly_phase_postscanned       Boolean            @default(false)
  reassembly_phase_completed_on      DateTime?
  reassembly_phase_completed_by      String?
  post_sublet_phase_completed_on     DateTime?
  post_sublet_phase_completed_by     String?
  qc_phase_completed_on              DateTime?
  qc_phase_completed_by              String?
  delivery_phase_completed_on        DateTime?
  delivery_phase_completed_by        String?
  delivery_phase_notes               String?
}

Harini•11mo ago

Got it, thanks for sharing. Not sure how this can be done with other tools but in BuildShip you get to get the nocode flexibillity with code power so you developer should be able to do this flexibly for any usecase as BuildShip can connect to any database including Postgres as well as is on google cloud. We can connect to experts who can do paid work - if you need this you need, you can email us at support@buildship.com and we can forward you to BuildShip experts.