Use Markdown with a cell reference

hi all,

any of you knows how to combine markdown with a cell reference?
for example, if i want to include an image of email that clicking on it will open a draft mail i"ll use:

(mailto:info@configura.co.il)

now, i want instead of the mail address to refer to a cell in my sheet. that way, i can change the address without reviewing all my markdown

thanks in advance!
Yinon

You just have to build the markdown by using a lot of:

= "markdown text" & C2 & "more markdown" & A2 & "even more markdown" & D2

Hi @George_B
Tried this before but the problem is that Iโ€™m trying to connect this to icon and mailto function and donโ€™t seem to manage to make this work

Post a sample spreadsheet.

hi @George_B
see link to sample file:

https://docs.google.com/spreadsheets/d/1pJopmWAEO5aBZuZh0nnb0Du0upf-8fgvLmehVivQcc8/edit?usp=sharing

let me know if you figure out a way to replace the mailto:info@configura.co.il in cell A2 with reference to cell C2 and the tel:+972547007027 in A2 with the reference number in cell B2

appreciate the help!

I just made the change, how does what I did work?

@George_B
works perfectly!!! you are the MAN
donโ€™t understand why it didnโ€™t work for me

Sometimes you just need a fresh set of eyes as they say. Great ideas BTW, I love how you guys come up with these things and share them.

iโ€™ve added in cell D2 the full code for you to see. with the full code your soultion isnโ€™t working

when iโ€™m trying to add the = sign with " like you did in the example I get error massage

What do you mean by the full code. Where did you copy and paste that from?

I did this in the app I shared earlier (https://yinon-raviv.glideapp.io)

Yeah I saw the app. But I still donโ€™t understand. In the app are you saying that you have only one Component and itโ€™s Rich Text? If that is the case I would suggest breaking it up into a few columns and multiple Rich Text components.

I know I can do that but it looks less nice and create spaces between the components while if itโ€™s all in one I can control the spaces between the lines to make this nicer.
Did you see the full code in one cell?

I do see it but I donโ€™t see any of the cell references like I did in Cell A2. Plus it does not start with a =". You have to build the markdown as I did starting with=โ€œmarkdown hereโ€ & B2 & โ€œmarkdown hereโ€ & C2 etc.

FYI, going offline for a meeting. Iโ€™ll look later at what you have done.

thanks, when you do look, youโ€™ll see iโ€™ve added the reference and got the error. maybe you could understand what iโ€™m doing wrong

I think the portion at the end is messed up. I think whatโ€™s happening here is you are trying to get a string with a quote character (") in the final result, but a quote will break of a string. Itโ€™s kind of hard to explain but you need to escape the quote character by using a double quote. Hopefully this makes more sense. https://webapps.stackexchange.com/questions/58017/how-do-i-output-a-string-containing-quotation-marks Iโ€™ve include the fixed portion below. No guarantees that I did it correctly, but at least the error goes away.:

<div style=""text-align: right""> ืงื•ื ืคื™ื’ื•ืจื” ืžืกืคืงืช ืฉื™ืจื•ืชื™ ื™ื™ืขื•ืฅ ื•ืœื™ื•ื•ื™ ืขืกืงื™ ืœื™ื–ืžื™ื, ืขืกืงื™ื ืงื˜ื ื™ื ื•ื‘ื™ื ื•ื ื™ื™ื ื•ืกื˜ืืจื˜ืืคื™ื.
ืื ื—ื ื• ืžืœื•ื•ื™ื ืืช ืœืงื•ื—ื•ืชื™ื ื• ืœืื•ืจืš ื›ืœ ืฉืœื‘ื™ ื”ืขืกืง, ืžื”ืจืขื™ื•ืŸ, ื“ืจืš ื‘ื ื™ื™ืช ืชื•ื›ื ื™ืช ืขืกืงื™ืช ื•ื›ืœื” ื‘ื‘ื ื™ื™ืช ืžืขืจื›ื•ืช ืžื•ืจื›ื‘ื•ืช ืžื‘ื•ืกืกื•ืช ืืงืกืœ  ื•ื’ื•ื’ืœ ืฉื™ื˜ืก ื›ื“ื•ื’ืžืช ืžืขืจื›ื•ืช ืชืคืขื•ืœ, ื ื™ื”ื•ืœ ืžืœืื™, ื›ืกืคื™ื, ื“ืฉื‘ื•ืจื“ื™ื, ืžื—ื™ืจื•ื ื™ื ื•ืขื•ื“.

ื™ื—ื™ื“ื” ื ื•ืกืคืช ืžืชืžื—ื” ื‘ื”ื“ืจื›ื•ืช ืฉืœ ืงื•ืจืกื™ื ืœืืจื’ื•ื ื™ื ื•ืื™ื ื“ื™ื‘ื™ื“ื•ืืœื™ื ืฉืœ ืื•ืคื™ืก ืžื‘ื™ืช ืžื™ืงืจื•ืกื•ืคื˜ ื•ื’ื•ื’ืœ ืขื ื”ืชืžืงื“ื•ืช ื•ื“ื’ืฉ ืขืœ ืืงืกืœ ื•ื’ื•ื’ืœ ืฉื™ื˜ืก </div>
"
1 Like