# Lookups to new columns **URL:** \ **Category:** Ask for Help\ **Created:** [July 6, 2024, 9:03pm UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665 "2024-07-06T21:03:30Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Mudrat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mudrat/32/73509_2.png) [@Mudrat](https://community.glideapps.com/u/Mudrat)\ **Post date:** [July 6, 2024, 9:03pm UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/1 "2024-07-06T21:03:30Z")
hello , sorry looking for help , i have a lookups column , but this column limits much to use its data , as am using line items docs automator integration , the Json of this fields comes to contain square brackest which make them locked , so i was looking a way to create a new column taht would be copying that data lookups column to new normal coulmn or if i would be able to remove the sqaure brackets from the json to make it a flattened text , refer some screensot ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/371d379b79b80bc555c99225b9b086cc5459878c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b06d67cbc35e1d4b26877df6f4a5447881e96bd2.png) ---
**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:** [July 6, 2024, 11:21pm UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/2 "2024-07-06T23:21:48Z")
In what format do you need it to be to comply with DocsAutomator’s rule? If you need it to be a comma-delimited list for example. you can use a joined list column instead of a lookup. ---
**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:** [July 7, 2024, 7:44am UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/3 "2024-07-07T07:44:32Z")
You are getting the square brackets in the JSON because your Lookup is returning an array. That suggests that the Lookup is targeting a multiple relation or Query column. If a multiple relation, try changing it to a single relation (uncheck the match multiple box). If a Query, use a Single Value column instead of a Lookup. ---
**Author:** ![Mudrat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mudrat/32/73509_2.png) [@Mudrat](https://community.glideapps.com/u/Mudrat)\ **Post date:** [July 7, 2024, 10:01am UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/4 "2024-07-07T10:01:26Z")
I tried to unchek the multiple box, and everything disappered in the lookups ---
**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:** [July 7, 2024, 10:08am UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/5 "2024-07-07T10:08:11Z")
Can you show me how the relation is configured please? ---
**Author:** ![Mudrat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mudrat/32/73509_2.png) [@Mudrat](https://community.glideapps.com/u/Mudrat)\ **Post date:** [July 7, 2024, 11:14am UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/6 "2024-07-07T11:14:42Z")
Thanks Darren , just figured out by calling a joined list from the look up and the square bracket were removed , also wanna ask how can i set a condition as a flow of a new screen and no details to display , i have a hint …like sorry you have no products ! the page is not related to products so i wanna set some conditionor css that would show the hint when the screen has no something ---
**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:** [July 7, 2024, 12:31pm UTC](https://community.glideapps.com/t/lookups-to-new-columns/74665/7 "2024-07-07T12:31:29Z")
So it’s the next screen that “doesn’t have any products”? If you can have a count of the number of products via relation + rollup, then you can setup a custom action based on that rollup.