Conditional text fields

Post Reply
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Conditional text fields

Post by colonel_panic »

Hi.

Is it possible to set a conditional field in a form letter which displays text if a field is not empty?
Jossi
SoftMaker Volunteers
SoftMaker Volunteers
Posts: 1260
Joined: Fri Dec 05, 2003 10:47 pm
Location: Luebeck, Germany

Re: Conditional text fields

Post by Jossi »

I suppose you need a solution for TextMaker, right?
Let's assume the field which sets the condition is called "TEXTBOX1". Then you insert a calculation with the formula: IF(TEXTBOX1="";"";"text").
When TEXTBOX1 is empty, the result of the calculation is void, otherwise it displays "text".
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Re: Conditional text fields

Post by colonel_panic »

Yes, Jossi. Thank you! I am talking about fields in tables in TextMaker.

What I'd like to do specifically is have a string of text in a document that is displayed along with the contents of the cell if there is some text in the field. For example, if the cell in my table contained no text, the result of the formula would be empty. However, if the cell did contain some text, I'd like the result of the formula to return "some text "contents of cell.

Is this possible?
raitis.veksejs
SoftMaker Team
SoftMaker Team
Posts: 127
Joined: Fri Sep 15, 2017 1:29 am

Re: Conditional text fields

Post by raitis.veksejs »

Here will be sample file and screenshot of how it could be achieved.
Attachments
Calculation.PNG
Sample.tmdx
(8.26 KiB) Downloaded 755 times
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Re: Conditional text fields

Post by colonel_panic »

Perfect! I will have a play with this, and get back to you.

Thank you! :D
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Re: Conditional text fields

Post by colonel_panic »

Hi!

Revisiting this question - is it possible to do something similar with textboxes in forms? What I want to do is display some text in a box if a textbox somewhere else in my form is checked.
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Conditional text fields

Post by miguel-c »

Yes, it can be done with the following formula:
IF(CHECKBOX1.SEL=1;"Checked";"Unchecked" )
checked.PNG
To update the formula you may:
Press F9 or type anything on the document. It also updates before printing or PDF Export and also when opening the document.
Attachments
checkb.tmdx
(12.7 KiB) Downloaded 675 times
Post Reply

Return to “SoftMaker Office 2018 for Linux (General)”