Make a formula field concider code as plain text
How to make a formula field ignore a line of html code. As if I would want to write an exemple code to appear in a formula field in my text but I dont want the code to be « used », only written in plain text.
This text will then be used in an email so I need it to show as it is simply!
12 replies
-
Joelle - when you are entering content in the formula editor, you can enter comments by enclosing the text in quotation marks. This is a formula >>> let x := 2. This is a comment >>> "let x := 2".
-
@Joelle... I am a bit confused on your use case. @NinoxUS is 100% correct that you can put comments in quotes.. there is a debate as to if this should be done via assignment like..
let comment :="This is my comment about my code";or as a simple text string like..
"This is my comment about my code";That said.. your last line is my confusion..
"This text will then be used in an email so I need to show as it is simply"..The function editor is not a rich text editor.. so I am not sure about the "html code" in the editor..
I am also confused about HOW you intend to use the formula source..
Your thoughts?
-
@Mconneen, I think what Joelle is wanting to do is similar to what Robert did in this thread...
He used a function/formula to build HTML. You can then paste the result where you want. I used a button to assign the result from the Formula field to a Rich Text field and it displayed as it would in a browser.
-
@Sean.. Ahh.. never would have interpreted it that way.. :) Thank you!
-
@Mconneen, If I’m right, you’re welcome. If I’m wrong, well, I’m sorry I steered you in the wrong direction!
-
@Sean.. No.. I think you are correct..
-
Hi! Thanks for trying to understand my question! (I’m a French speaking from canada!)
Here is why I ask this question. The goal is to create an email with Zapier in HTML style to be able to insert images and make it look good. But for Zapier to trigger the automatic sending protocol, a new entry must be created in a ninox table.
So what I made already is to have a button that creates an new entry in a sub-table. This table contains those field: TO, Subject, and the a large Text block for the message.
On the Main table, there is 3 formula field that are the source of data for the sub-table text field (To, subject and text)
I need those to be formula field because they reach for many informations from the main table and other linked tables.
Then...
When the button is clicked informations from the three Formula field in the main table is copied in the sub-table triggering the zapier send email zap.
BUT
Simple text and formula works fine. But when I want to introduce html code for a picture
(<img src="http://www.website.com/photo.jpg" >)
It search for « img src » field or tell me it is not defined. But I dont want Ninox to read this line of html code, I only want Ninox to copy the code as text so that when Zapier create the email, the HTML code will be used by the inbox of our client.
I dont know if I explained it right!
-
@Joelle.. sounds like Sean understood and pointed you to a similar link.
-
But I didnt understand how to do it in the other thread...
-
Hi Joelle, I personally do not have any experience with this. I suggest you contact support directly and they should be able to help you. Sorry I couldn't be more help!
-
Hé!! I found a solution!!
What I did is to create a normal text field in which the default text is the HTML code I need. So in the formula, I simply use a normal formula to show the data of that text field! It works!
-
Congrats Joelle, I'm glad you got it working!
Content aside
- 5 yrs agoLast active
- 12Replies
- 3555Views