I fixed it- if you want to see my google sheets code pls asked, I've now removed the link.
[s]Some one pleasee help me [emoji=tundra sad size=2]
I decided to code my hatchery cus I thought I could do it, idk why I thought that, my coding experience is minimal at best lol. Anyway, I've spent hours trying to make it work using concatenate, and it looks like a mess.
Here[/url] is the sheet, it's the for sale code that I'm having an issue with. you can ignore the other sheet.
[size=5][b]Pls if you want to make any edits in my google sheets duplicate the sheet and edit that copy.[/b][/size]
I will pay 20 gems to whoever manages to fix my code. I understand if you would rather fully rewrite the code so I'm willing to negotiate higher.[/s]
[s]This is what it's supposed to look like [/s]
[center][columns][url=https://www1.flightrising.com/dragon/93397140][img]https://www1.flightrising.com/rendern/350/933972/93397140_350.png[/img][/url][nextcol][center][img]http://flightrising.com/images/icons/small_male.png[/img][size=4]Unnamed[/size][img]http://flightrising.com/images/icons/small_male.png[/img]
[emoji=birthday cake size=1][b]Mar 4, 2024[/b]
[emoji=treasure size=1]100kt / [emoji=gem size=1]100
[url= http://www1.flightrising.com/auction-house/buy-dragon/93397140][img]https://www1.flightrising.com/static/layout/profile/button-buy.png[/img][/url] [/center][/columns]
------------
[s]This is what it currently looks like
[/s]
"[center][columns][url=https://www1.flightrising.com/dragon/93397140][img]https://www1.flightrising.com/rendern/350/933972/93397140_350.png[/img][/url][nextcol][center][img]http://flightrising.com/images/icons/small_male.png[/img][size=4]Unnamed[/size][img]http://flightrising.com/images/icons/small_male.png[/img]
[emoji=birthday cake size=1][b]Mar 4, 2024[/b] [emoji=treasure size=1]100kt / [emoji=gem size=1]100 [url= http://www1.flightrising.com/auction-house/buy-dragon/93397140][img]https://www1.flightrising.com/static/layout/profile/button-buy.png[/img][/url] [/center][/columns] ------------"
[s]Note the random quotes, I can not get the code to not have them once I've copy and pasted it.
edit- Okay I'm Almost there! This is what it looks like so far, I managed to get rid of the quotes![/s]
[center][columns][url=https://www1.flightrising.com/dragon/93397140][img]https://www1.flightrising.com/rendern/350/933972/93397140_350.png[/img][/url][nextcol][center][img]http://flightrising.com/images/icons/small_male.png[/img][size=4]Unnamed[/size][img]http://flightrising.com/images/icons/small_male.png[/img][br][emoji=birthday cake size=1][b]Mar 4, 2024[/b][br][emoji=treasure size=1]100kt / [emoji=gem size=1][br]url= http://www1.flightrising.com/auction-house/buy-dragon/93397140][img]https://www1.flightrising.com/static/layout/profile/button-buy.png[/img][/url] [/center][/columns][br]------------
I did it- I'm a master coder now
[center][columns][url=https://www1.flightrising.com/dragon/93397140][img]https://www1.flightrising.com/rendern/350/933972/93397140_350.png[/img][/url][nextcol][center][img]http://flightrising.com/images/icons/small_male.png[/img][size=4]Unnamed[/size][img]http://flightrising.com/images/icons/small_male.png[/img][br][br][emoji=birthday cake size=1][b]Mar 4, 2024[/b][br][br][emoji=treasure size=1]100kt / [emoji=gem size=1]100[br][br][url= http://www1.flightrising.com/auction-house/buy-dragon/93397140][img]https://www1.flightrising.com/static/layout/profile/button-buy.png[/img][/url] [/center][/columns][br]------------
I fixed it- if you want to see my google sheets code pls asked, I've now removed the link.
Some one pleasee help me
I decided to code my hatchery cus I thought I could do it, idk why I thought that, my coding experience is minimal at best lol. Anyway, I've spent hours trying to make it work using concatenate, and it looks like a mess.
Here[/url] is the sheet, it's the for sale code that I'm having an issue with. you can ignore the other sheet.
Pls if you want to make any edits in my google sheets duplicate the sheet and edit that copy.
I will pay 20 gems to whoever manages to fix my code. I understand if you would rather fully rewrite the code so I'm willing to negotiate higher.
This is what it's supposed to look like
This is what it currently looks like
"
"
Note the random quotes, I can not get the code to not have them once I've copy and pasted it.
edit- Okay I'm Almost there! This is what it looks like so far, I managed to get rid of the quotes!
I did it- I'm a master coder now
@Bonnieclipse [url=https://docs.google.com/spreadsheets/d/1s1sHDE74spV-Cv8CXOKx4u2Z4KNJkkwKvBpNKFtYUn4/edit?usp=sharing]here you go![/url]
the problem is that if you want things to be on a new line using sheets autocoding, you have to insert a line break using[code] [br] [/code]rather than using the enter key or putting it on a new line in the sheet/cell
the quotes are a known issue when copying from google sheets, i dont think there is any way to remove them other than removing them after the fact manually
@
Bonnieclipse here you go!
the problem is that if you want things to be on a new line using sheets autocoding, you have to insert a line break using
rather than using the enter key or putting it on a new line in the sheet/cell
the quotes are a known issue when copying from google sheets, i dont think there is any way to remove them other than removing them after the fact manually
@
Croissants
Thanks,
That helps but I am trying to find something that will get rid of the quotes, I looked online and it is possible. I just can't understand what specifically needs to be done.
I'll send you a tip through CR.
@
Croissants
Thanks,
That helps but I am trying to find something that will get rid of the quotes, I looked online and it is possible. I just can't understand what specifically needs to be done.
I'll send you a tip through CR.
@Croissants
I figured out how to get rid of the quotes- here's just a quick explanation of how to do that if you're curious.
Basically they are caused by Google Sheets not understanding an input that was put into it. In my case it was the fact that I added a new line using enter instead of [code][BR][/code]
so once I added br for all my linebreaks the quotes stopped appearing.
@
Croissants
I figured out how to get rid of the quotes- here's just a quick explanation of how to do that if you're curious.
Basically they are caused by Google Sheets not understanding an input that was put into it. In my case it was the fact that I added a new line using enter instead of
so once I added br for all my linebreaks the quotes stopped appearing.