Need a breath of fresh advice...!

Need help
1

I need some fresh advice as I am a bit stuck in my own head.

I have built an app that efficiently gathers 3 ( a carpenter, a plumber and an electrician) different users prices for their services and puts that into 1 final offer/quote for them to send to their clients. Thy build quality bathrooms for the private market.

My database setup for this is but somewhat simplified:

Main offer

  • Offer name
  • User
  • List of carpenting services
  • List of electric services
  • List of plumbing services
  • Total Sum

Carpenting services

  • Service name
  • Amount
  • Price

Electric services

  • Service name
  • Amount
  • Price

Plumbing services

  • Service name
  • Amount
  • Price

I also prepopulate their lists for every service in all 3 crafts through an API workflow on Main offer creation, so when they go to set up their individual description and pricing they just have to adjust some already filled in values.

I thought it was complete as per client specs, but life happens and the client wants more. They now want to be able to add an “extra room” to the main offer, as sometimes their own clients has a washing room connected to the bathroom etc. They want to be able to push a button saying “+1 Extra room” and boom the same prepopulated lists for all 3 crafts fills the extra room offer and they want this on the same page as the main offer.

How would you guys make this work as it should be connected to the main offer in the final PDF for their clients.

Hope I was clear in my description, and hope somebody has a suggestion.

Kris

2

Hey Kris,

I would add a new table called extra room, the add a thing to your Main offer called extra room and link it to your new table. Now when they hit the extra room button create a fill a table entry in the extra room table but also add the unique ref into the Main offer table. That way you link the two tables together.

I guess you will never have an extra room without a Main room so making Main room the master is the right answer.

Hope that makes sense!

Si

3

Hi @simon! Thanks for your input!

Would you be so kind to “show” me how you would set that up in the database, as I get the core of what you suggest, but not entirely and all the way out to putting the extra room details on the same page as the main offer.

Kris

4

Sure - if you DM a link to your app I will set it up for you so you can see. You would need to make the app public for a bit for that to work.

If your not comfortable with that I can probably find a spare app somewhere to do it in so you can look

Simon

5

Hi again @simon

I am comfortable with that, but it’s somewhat complex in what’s what and it’s norwegian. I will send you the link :slight_smile:

Kris

6

ikke noe problem

7

:wink: Er du skandinavisk? Or was that google translate? :smiley:

8

Nope - google translate :slight_smile:

9

It works! Thanks @simon!

10

This topic was automatically closed after 70 days. New replies are no longer allowed.