How i Hide a text in PDF(Workflow, Email) when in the app select false in a button?

Gonzzo
New Member


How to hide the text “Discount” and “<>” in a pdf?
I thought these answers(ideas):
Showif(button=true) (in the PDF docs)
Add Virtual Column: Hide_Discount (If(button=false,Discount=""))
But i don’t know how manipule or change the text in PDF, How i change a text in PDF to hide the word Discount?, I’m lost.
Any help?

Solved Solved
0 4 326
1 ACCEPTED SOLUTION

Gonzzo
New Member

I got it yesterday, i used in Formula with each camp:
“IF([Discount_Show]=true,CONCATENATE(“Razón del Descuento: ( Discount Reason in English )”, [Razon del Descuento],”."), “” )"
And each discount_show was true show something otherwise Discount_show was false show “”(empty) ,And the var type price, number, percent, i concatentate these in a string, My boss (told me use CONCATENATE()) and @Steve really helped me with Show if, @Arthur_Rallu introduce me the if sentence for the beggining really thank you.
I hope help together in a future chance or help other beggining guys to pay your knowledge for this Fantastic application Appsheet.

View solution in original post

4 REPLIES 4

Hi Gonzalo,

If you’re only trying to hide the discount line in your template and not change the UI of your application, maybe you can try to replace:

Discount:<<Discount>>

by:

<<If: [Discount] > 0 >> Discount: <<[Discount]>><<EndIf>>

and replace the If condition by what you actually need.

More details available at https://help.appsheet.com/en/articles/2697069-template-if-expressions

I hope this helps.

If i need hide the UI? the text Discount without “<<>>” just the text or it’s impossible?
I Think, it can’t be.
It’s impossible maybe create a virtual column: Discount_Hide (<- virtualcolumnName) (data type string) and put the “Discount” value. And if the button is false just change the value “” empty.

Ok, i found it!

Thank you so much!

Hello? My virtual column just couldn’t add a text like “Discount”([Text_Discount]), It showed an error, i tried to create a normal column in my sheet and I put Initial value “Discount” and this is my question.
I will put Discount in a sentence with true(Show “Discount”(Initial value)) or false(Put “”(empty)) (It’ was an example, if you compile that, you will really have an error syntax ).
How to put empty in the Variable Text_Discount or just put the value ("")?

And how put empty in a Variable Percent? like “” but in a number, cause my discount is percent, and i want show empty if is false.

A friend programmer in others platform tell me, Put the text in color White in PDF Is it possible?

@Arthur_Rallu

How many questions can i ask?

Gonzzo
New Member

I got it yesterday, i used in Formula with each camp:
“IF([Discount_Show]=true,CONCATENATE(“Razón del Descuento: ( Discount Reason in English )”, [Razon del Descuento],”."), “” )"
And each discount_show was true show something otherwise Discount_show was false show “”(empty) ,And the var type price, number, percent, i concatentate these in a string, My boss (told me use CONCATENATE()) and @Steve really helped me with Show if, @Arthur_Rallu introduce me the if sentence for the beggining really thank you.
I hope help together in a future chance or help other beggining guys to pay your knowledge for this Fantastic application Appsheet.

Top Labels in this Space