# Glideapp **URL:** \ **Category:** Ask for Help\ **Created:** [February 3, 2022, 6:02pm UTC](https://community.glideapps.com/t/glideapp/38079 "2022-02-03T18:02:45Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 3, 2022, 6:02pm UTC](https://community.glideapps.com/t/glideapp/38079/1 "2022-02-03T18:02:45Z")
Good evening everyone, new to glide, I will explain my problem to you. I would like that when I enter something in a cell, the others will automatically increment in relation to my Excel file. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 3, 2022, 11:37pm UTC](https://community.glideapps.com/t/glideapp/38079/2 "2022-02-03T23:37:07Z")
> [@PATRICK77](#): > > the others will automatically increment in relation to my Excel file. Can you explain what you refer to as “the others” here? What is your use case for this? ---
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 4, 2022, 8:53am UTC](https://community.glideapps.com/t/glideapp/38079/3 "2022-02-04T08:53:44Z")
Hello thanks Yes no sorry easy to explain Imagine in my excel sheet 5 columns with the values ​​1 2 3 4 5 When I hit 1 in a glide change 234and 5 automatically come to register Thank you for your help ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 4, 2022, 1:58pm UTC](https://community.glideapps.com/t/glideapp/38079/4 "2022-02-04T13:58:04Z")
So what do you have in Glide? Do you mean you have an entry component that writes to one of those columns and when you do so, the other values will be written somewhere? ---
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 4, 2022, 3:34pm UTC](https://community.glideapps.com/t/glideapp/38079/5 "2022-02-04T15:34:46Z")
hello and thank you yes this is exactly what I need ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 4, 2022, 5:21pm UTC](https://community.glideapps.com/t/glideapp/38079/6 "2022-02-04T17:21:56Z")
Can you share some screenshots so we can better understand? It’s still not clear to me what the use case is. What do you do with those numbers? ---
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 4, 2022, 6:00pm UTC](https://community.glideapps.com/t/glideapp/38079/7 "2022-02-04T18:00:55Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a88e597205c9b728bf088583bcc2bf50253d2e80.jpeg) attached the form I would like that when I note the number in unit it can fill me in the registration and model fields which is on the same line in my Excel file thank you ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 4, 2022, 6:34pm UTC](https://community.glideapps.com/t/glideapp/38079/8 "2022-02-04T18:34:10Z")
If I’m understanding you, if you enter 8787878 into the Unit column, you want the Registration column to automatically populate with 8787879 and the Model column to automatically populate with 8787880? That won’t be possible in a native form. If you are willing to not show the Registration and Model entry components in the form, then you could instead create math columns in the table that represent the Registration and Model values and just add 1 and 2 respectively to the value in the Unit column. ---
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 4, 2022, 7:06pm UTC](https://community.glideapps.com/t/glideapp/38079/9 "2022-02-04T19:06:29Z")
no sorry I explained you badly because of my figures attached a concrete example it is about vehicle ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2dd103448640807ea44b578545ae3e0d39aabbc.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c1b31511fa27ba2dd538ae1753e2d8f141773d8.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 4, 2022, 8:47pm UTC](https://community.glideapps.com/t/glideapp/38079/10 "2022-02-04T20:47:50Z")
OK, that will still be tricky with a native glide form. It sounds like what you really need is a relation and lookup columns to retrieve the Registration and Model from the table that contains that information based on the Unit number. Like I mentioned in my earlier post, you could choose not to show the Registration and Model in the form, but only get the Unit from the user. In the table that you write the form results to, you could put your relation and lookup columns there. Then you can get the information from another table based on that unit number without actually having to write the information to the table. The reason you can’t show the matching vehicle in the form is because the relation won’t work until the form is submitted. Instead I would consider using a custom form. It’s more work to build, but it would allow you to enter the Unit, then immediately show the Registration and Model from the resulting lookup columns, and pass them through an add row action on a button in the custom form. It’s hard to explain the whole process, but I’m confident that it would work once you learn how a custom form works. > [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014): > > I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula… ---
**Author:** ![PATRICK77](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick77/32/38134_2.png) [@PATRICK77](https://community.glideapps.com/u/PATRICK77)\ **Post date:** [February 5, 2022, 9:24am UTC](https://community.glideapps.com/t/glideapp/38079/11 "2022-02-05T09:24:58Z")
hello and thank you i will look into it