# Jump to start

**URL:** <https://community.glideapps.com/t/jump-to-start/24708>\
**Category:** Ask for Help\
**Created:** [March 25, 2021, 7:33am UTC](https://community.glideapps.com/t/jump-to-start/24708 "2021-03-25T07:33:47Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 25, 2021, 7:33am UTC](https://community.glideapps.com/t/jump-to-start/24708/1 "2021-03-25T07:33:47Z")

</div>

Hi,

I’m using the apps to make an automated quotation.  
One model have machine have very long calculation to get the Final price.  
The lookup price, the lookup discount price, the shipping cost and others.  
For example : user can choose one model with quantity.  
Here is the column for only one model

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6133e4d89719120088ec436f5dcb3f21f3e456a6.png)  
Like so many…  
Is there any possibility if the user can add another model, it will jump to start

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 25, 2021, 7:42am UTC](https://community.glideapps.com/t/jump-to-start/24708/2 "2021-03-25T07:42:23Z")

</div>

The description of your problem is a bit difficult to understand.

Can you explain more what you mean by “jump to start”?

You provided a screen shot of a table, but that doesn’t really tell me anything.  
How is that data presented in your app, and how does the user interact with it?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 25, 2021, 7:50am UTC](https://community.glideapps.com/t/jump-to-start/24708/3 "2021-03-25T07:50:22Z")

</div>

Currently, i am only able to add one model .  
If user want two , or three model in one quotation, it is impossible for me to create new column for second or third model because there’s too many column and calculation.  
My question is: Is there any ways to make the same column and calculation for next model for user to choose?

> **[Sales Tracking](https://awful-ants-8702.glideapp.io/)**
>
> Purposely for Sales Tracking

You can see under “Quotation List\>Add new Quotation”

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 25, 2021, 8:07am UTC](https://community.glideapps.com/t/jump-to-start/24708/4 "2021-03-25T08:07:48Z")

</div>

Okay…

So a little bit of guess work here, because I can’t see the inner workings of your app.  
But, I’m assuming that you have a Quotations sheet/table, and that table includes a column or columns for the model information. And now you want to be able to add multiple “models” per quotation.

The best way to do this would be to separate the model information from the Quotations table. So…

- Create another table, call it something like Quotations-Models
- In that table, have the following columns:
  - Quotation ID: this will be a reference to your quotations table
  - Other columns as necessary to describe the “model”

In your User Interface, you will need to adjust it so that the user creates the initial quotation _without_ any model information - this gets you a Quotation ID that can be used when adding models. Then you can allow the user to add an unlimited number of “models” to the quotation, one by one. Each will be a single row in the Quotations-Models table, using the same Quotation ID. Then you can link these back to the quotation with a multi-relation using that ID.

In terms of all the calculations, it might make sense to also move those to the Quotations-Models table, and summarise them using rollups through the multi-relation. But again, that’s just a bit of speculation because I don’t know the inner workings of your app. I’m really just describing how I would handle a situation like this.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 25, 2021, 8:29am UTC](https://community.glideapps.com/t/jump-to-start/24708/5 "2021-03-25T08:29:42Z")

</div>

> [@Darren\_Murphy](#):
>
> In your User Interface, you will need to adjust it so that the user creates the initial quotation _without_ any model information - this gets you a Quotation ID that can be used when adding models. Then you can allow the user to add an unlimited number of “models” to the quotation, one by one. Each will be a single row in the Quotations-Models table, using the same Quotation ID. Then you can link these back to the quotation with a multi-relation using that ID.

Darren,  
I can’t imagine this how its work…

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 26, 2021, 6:02am UTC](https://community.glideapps.com/t/jump-to-start/24708/7 "2021-03-26T06:02:01Z")

</div>

Can you give me an example?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 26, 2021, 6:44am UTC](https://community.glideapps.com/t/jump-to-start/24708/8 "2021-03-26T06:44:25Z")

</div>

Which bits do you not understand?  
It would take me an hour or two to put together a working example, and I don’t really have that time to spare right now.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 26, 2021, 7:10am UTC](https://community.glideapps.com/t/jump-to-start/24708/9 "2021-03-26T07:10:13Z")

</div>

> [@Darren\_Murphy](#):
>
> In your User Interface, you will need to adjust it so that the user creates the initial quotation _without_ any model information - this gets you a Quotation ID that can be used when adding models. Then you can allow the user to add an unlimited number of “models” to the quotation, one by one. Each will be a single row in the Quotations-Models table, using the same Quotation ID. Then you can link these back to the quotation with a multi-relation using that ID.

This part, i dont really have a picture of this

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 26, 2021, 7:46am UTC](https://community.glideapps.com/t/jump-to-start/24708/10 "2021-03-26T07:46:47Z")

</div>

Okay, so one of my colleagues is building an app at the moment that has a very similar requirement.  
In our case, it’s a HR Expense Claim management system.  
When an employee submits an expense claim, they are required to provide receipts as supporting evidence for the claim. But, they might have one receipt, or they might have one hundred receipts. So the system needs to allow for an unlimited number. The way we handled it is as follows:

- An employee first creates a claim with the basic required information, and submits as a “draft”
- This gives us a Claim ID. We then present a button that allows them to attach receipts.
- As each receipt is added, a row is created in a separate table using the original Claim ID.
- This way, an unlimited number of receipts can be attached to a single claim

To apply that to your situation, substitute “Quotes” for “Claims”, and “Models” for “Receipts”

Does that help?
