Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7846 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I defined a value list (valListA) in FileA with the Use values from field: option. The field I chose to populate the list is in a different file (FileB). I also defined a field in FileA that is formatted as a pop-up list and uses valListA to display values. The odd thing is that I am getting some extraneous blank entries in the pop-up list. There are no blank records or fields in FileB.

So then, I put a portal on the FileA layout and inserted the same field as valListA into the portal. There are no blank entries in the portal. Needless to say I'm a bit mystified. Why are there extaneous blank entries in the pop-up list?

Thanks

The Mad Jammer cool.gif

And then...there was nothing

Posted

Perhaps you have carriage returns in some of the entries in the field? That may cause what appears to be a blank field but is actually the second blank line of the value above it. Not sure about that, though.

Have you tried defining the value list in FileB. And then in FileA choose the option use Value Lidt from Another File. Would be curious to know if the same problem occurs?

-Courtney

  • 3 weeks later...
Posted

A field in File B is actually being used to populate the value list. File B consists of two fields, one field with a constant in it and a date field. The date field is providing the values for the value list in valListA.

At first I thought carriage returns or white space was the culprit too but I've deleted every character after the actual value in the date field of File B.

So I'm still stumped. The open spaces in the drop down list only happen after a couple of the dates and I have made an extra effort to be sure that the records that contain those values have no extraneous characters.

The Mad Jammer

And then...There was nothing

Posted

I've had a similar problem some time back, I think it had something to do with the indexing settings of the applicable fields. I can't really remember, but maybe you want to have a look at your indexing settings.

Pete

Posted

Thanks Pete, I'll look into that. I know that the file (File : is indexed by date so that the dates show up in chronological order in the pop-up list, but the records in File are not necessarily in chronological order. In other words 01/01/2003 shows up before 12/01/2002 in the records list.

The Mad Jammer

And then...There was nothing

Posted

Hi,

1) So you said you placed the fields in the portal and that no empty record was in there. Are you sure this extra empty record didn't jumped at the end of the portal list, according to your sort key.

2) I'd made an extra calculation to see if there is a problem in the list.

c_checklist = Substitute(ValueListItems(Status(CurrentFile, "your value list"), "pp", "space") - Unsorted (where pp is a carriage return)

I really mean "space" as litteral text.

Look at the field and check if no occurrence of "spacespace" appears in there with c_checkCarriages = Patterncount(c_checklist, "spacespace").

This topic is 7846 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.