# Publishing Form data to sheets **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2020, 12:00am UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782 "2020-08-27T00:00:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![scottj52101](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@scottj52101](https://community.glideapps.com/u/scottj52101)\ **Post date:** [August 27, 2020, 12:00am UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/1 "2020-08-27T00:00:43Z")
I’m trying to use a simple form to populate a central sheet that multiple users can view. I set up a User Profile table with Employee - Email - Dept - Supervisor - Manager - etc User would be logged in via email. When they submit a form, how do I populate Employee - Dept - etc. into the sheet so it can be filtered and formatted. I can use special values and retrieve email, but I can’t figure out how to tie the email to an Employee in the Data editor. I can set up a Relation/Lookup that gives me the Employee in another column, and pull that into the table via Special Values Column in the form, but I can’t seem to populate the actual sheet. It looks like the sheet only accepts Text columns. What am I missing? Thanks! PS - I’m very much digging the concept of Glide. I’ve already set up another app for my band, which is working great. If I can figure out this current issue, I can probably sell management on buying a Pro subscription. ETA: One thing I did notice, is that the app will publish more data via the web interface than I see if I use the app on my iPhone. And, this app doesn’t seem to update formatting on my phone like my band app does. ---
**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:** [August 27, 2020, 12:10am UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/2 "2020-08-27T00:10:40Z")
If you need those values in the Sheet as well, arrayformula combined with vlookup is the easiest way to go. Otherwise, the form you submit must be on a tab that has it source sheet populated with said fields, then you can enter them via the columns component. Adding to what I said in the other thread. > [@Profile data in forms?](https://community.glideapps.com/t/profile-data-in-forms/10459/4): > > If those fields are in your user profiles already, you can access it anywhere in the app via user data. Or else you just need to write the signed-in user’s email to new sheets and then do a relation - lookup, would that work? ---
**Author:** ![scottj52101](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@scottj52101](https://community.glideapps.com/u/scottj52101)\ **Post date:** [August 27, 2020, 12:45am UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/3 "2020-08-27T00:45:11Z")
OMG, I think I got it to work! I don’t know what happened, but I’m suddenly seeing the Employee Data. Wait, it failed on the second attempt, and subsequent submissions. I’m stumped. ---
**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:** [August 27, 2020, 2:40am UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/4 "2020-08-27T02:40:35Z")
As long as you put the form inside a sheet with the fields you want (either it’s the user profiles or another sheet that you used relation - lookup to bring the value over) then you will see them in the Columns component. ---
**Author:** ![scottj52101](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@scottj52101](https://community.glideapps.com/u/scottj52101)\ **Post date:** [August 29, 2020, 7:03pm UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/5 "2020-08-29T19:03:18Z")
I think I may have figured this out. It looks like the sheet wasn’t populating data properly because I was deleting rows in the sheet, itself. When I deleted the data, rather than the rows, the data populated with the info I was looking for. I’ll keep testing. ---
**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:** [August 29, 2020, 11:16pm UTC](https://community.glideapps.com/t/publishing-form-data-to-sheets/14782/6 "2020-08-29T23:16:24Z")
Tell me if I can help more.