# Help in form submission adding row with condition

**URL:** <https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306>\
**Category:** Ask for Help\
**Created:** [April 9, 2023, 2:05am UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306 "2023-04-09T02:05:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yohannan](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@Yohannan](https://community.glideapps.com/u/Yohannan)\
**Post date:** [April 9, 2023, 2:05am UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/1 "2023-04-09T02:05:36Z")

</div>

I am building membership management internal tool  
and I have 2 questions within it

1. 

I want form entries to be like below

 ![Screenshot 2023-04-09 2036481](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33bdef673c1ef5cf7bcac6d09d40b353873bddf8.png)

What I want is when user clicks Plan type choice(let say cardio) and plan (let say Monthly) the amount auto fills from plan type table

- This is my table for membership sales  
[Screenshot 1 — Freeimage.host](https://freeimage.host/i/HkjQzUg)

Plan type screenshot

> **[Screenshot 2](https://freeimage.host/i/screenshot-2.HkjQFOx)**
>
> Image Screenshot 2 hosted in Freeimage.host

I want to match amount with both durations & Plan type and come up with amount in table  
This should be changable as user clicks different choice

1. Also  
I want to make End Date sync with Plan selected, like clicking Monthly will make end date 1 month after start date if 3 then 3 months after  
[start date default will be today]

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 9, 2023, 10:46pm UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/2 "2023-04-09T22:46:50Z")

</div>

This is unachievable in a native Glide form. You’d need to create what we call a “custom form”. Here’s a good guide:  
[How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014)

---

<div class="post-metadata">

**Author:** ![Yohannan](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@Yohannan](https://community.glideapps.com/u/Yohannan)\
**Post date:** [April 10, 2023, 2:06am UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/3 "2023-04-10T02:06:09Z")

</div>

Hi @Robert_Petitto  
Thanks for the reply

I tried using custom form but I’m still stuck  
I have tried with user specific,

Can you please give me in more details How do I  
Here’s the updated form with data for What I want to show

 ![Screenshot 2023-04-10 071742](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e07ee05c8d5592f1ecbb5ee87ba4a7644d2b25b1.png)

 ![Screenshot 2023-04-10 072620](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2ac7ef1ec12c57e819c0c4e94c35cc2c0ed0962d.png)

would like to say it again, what I want  
When user clicks Plan Type(Let say Personal coach) and Plan(Monthly) the pricing for that show’s us, if it is clicked personal coach & yearly different pricing for that show’s up like in data

in real-time in Amount(Number entry)  
I want it to be editable, if user wan’t to change pricing but default should comes up as clicked

* * *

I was going through templates if I can get help and I saw something similar been done in native form

> **[2023-04-10\_07-33-35-664.mp4](https://drive.google.com/file/d/1NQyQy0VrofRI2zumwlq4dAWTM2HxCwtC/view?usp=sharing)**
>
> Google Drive file.

It doesn’t have multi condition(2 categories) but would love to know How it made it possible

Thanks

---

<div class="post-metadata">

**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\
**Post date:** [April 10, 2023, 3:04pm UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/4 "2023-04-10T15:04:01Z")

</div>

Hi @Yohannan

As @Robert_Petitto suggested you need you create a custom form if you want to see the pricing corresponding to the current choices.

In your custom form table (the one used during the subscription process) you need to use relations.  
Create a relation between the user’s choices (plan type) and the plan type in your “plan type” table so than you can retrieve information from this table.

There are multiple ways to get the price corresponding to the selected plan and billing but here is an idea:

- Create 4 columns in your “table form”, One for each of the pricing (monthly…)
- In these columns, use lookup to search the prices in your “plan type relation”
- Then create a new columns IF then else type. In it say: IF “plan” IS monthly THEN “monthly plan”, IF “plan” IS quarterly THEN “quarterly plan”…

The result of this columns will be the price corresponding to the user’s choices, then you can display in your custom form screen.

I hope I understood your need, if not feel free to ask again

---

<div class="post-metadata">

**Author:** ![Yohannan](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@Yohannan](https://community.glideapps.com/u/Yohannan)\
**Post date:** [April 10, 2023, 3:19pm UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/5 "2023-04-10T15:19:04Z")

</div>

Thanks a lot, I got it & used this way . IT WORKED

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 11, 2023, 3:19pm UTC](https://community.glideapps.com/t/help-in-form-submission-adding-row-with-condition/60306/6 "2023-04-11T15:19:27Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
