Limit text length in a database repeater

Ask the community
,
21

ok simple solution, out some data in your collection i.e. “no job description”

22

@mikemoynihan99 Okay, I can do that, but is there a way to conditionally hide that text? “if text is equal to no job description, hide it” ?

23

Actually, I just tried it with just a space in the database field for the “blank” ones, and that seemed to work…

24

@elena

$w.onReady( function () {

    $w("#eventphotos").onReady(() => {

//unsearchedrep to the ID of your repeater, change as necessary
$w(“#unsearchedrep”).forEachItem(($w) => {

let text = $w(“#eventphotos”).getCurrentItem().jobdescription;

            console.log(text);

if (text === “no job description”){

                $w("#unsearchedrepdescrip").hide(); 

            }

//now we make text short, modify length as required
let shortenedtext = text.slice(0, 10);

if (text.length > 100) {

//unsearchedrepdescrip is the ID of the text on your repeater, change ID as necessary
$w(“#unsearchedrepdescrip”).text = shortenedtext;

            } 

        }) 

})

})

25

@mikemoynihan99 Thank you so much for taking the time and working through this with me!!! I’m new to java so your help is greatly appreciated.

26

@elena
no problem

27

@mikemoynihan99 Well hey, while we’re talking about the “null” issue, I just discovered that something similar is happening when I try and get the repeater to show data from a reference field… It tells me it can’t work on null values, even when there is a value in that field for each database entry. Do you happen to know what I might be doing wrong here?

28

@mikemoynihan99 Here’s the link to my new problem I’m having if you’re willing to help me out again…