Sort Container Field

[Leb i Sol]

Hello People!

I was wondering if this is possible with some script or perhaps I am missing a conecpt. Here is the scenario:

Some Table Layout:

Field 1- Container = Image(not reference)

Field 2 - Text/number = RecordID

is there a way to sort asc. or desc. based on existance of image in the field?

eg.

IF filed Image =""

THEN

list it on the bottom of this "sorted list".

Basically I would like to have those records without image to be listed on bottom of my Table View.

Sorry but I have not used much of ScriptMaker and I do not know if this is ever possilble.

Thank you guys for all the help!

[Ugo DI LUCA]

Hi,

If this is going to be a static solution, you won't need any script for that. Just sort the relationship on the calculation Case(not Is Empty(Container),1,0).

The records with 0 (no image would drop at bottom of your relationship).

If you want to move around related records, up, down, custom sortin, just have a look at DJ's Renumbering Portal in the Sample Section.

[Leb i Sol]

Thank you Ugo!

I do not have any relationships here...two fields....that's it.

Any tips?

Thank you Ugo...and anyones else that has more brain than I do!

[Ugo DI LUCA]

With or without a relationship, the sort on the calculation field given above would have the same result.

Now if you really need a script, why not omit records where the Calculation returned 0 ?

[Leb i Sol]

umm..there is this little factor - I know >=0 about scripting...so hints just confuse me

would you mind explaining it step by step?

which caluculation field?

do I need to make another field just so I can sort?

thanx again

[Ugo DI LUCA]

Yes...

A calculation field c_checkEmptyContainers = Case(Is Empty(Container field), 1, 0).

Then, use this field for your sort.

[Leb i Sol]

nice It workes and I do remember hwo I did it

Thanx Ugo!

This "field creation" confused me...coming from SQL based apps. Thank you again!