AnsweredAssumed Answered

Finding empty Image containers?

Question asked by JefferisPeterson on Apr 26, 2012
Latest reply on Feb 11, 2019 by Bentech

Like • Show 0 Likes0
Comment • 7

Title

Post

I just upgraded to FMPro 12 from 9. I am using the Assets template. I have uploaded a database of many images from Hemera's image catalog that no longer works in Lion. I have found that some images I believe do not have thumbnails and so althougth a file path and file name are present, the image container is empty. However, I can't see to enter any search characters in the image container area and some of the containers just say "image" but do not show any. What I'd like to do is create a found set of empty containers and update ONLY those empty ones with the full size images using Update Match Existing records

image -->Image/Container.

But since I can't seem to use Find function to single out this set of records, I'm not sure what I can do.

Any help appreciated.

Jeff

philmodjunk Apr 26, 2012 11:31 AM

Correct Answer

remove the equals sign. Just enter the name of the container field.

WHen you enter find mode, you'll enter the = sign into this field as your search criteria.

See the reply in context

No one else had this question

Outcomes

philmodjunk Apr 26, 2012 10:04 AM

Define a calculation field cContainerText by entering the container field's name as the sole term. Specify text as the field's return type. Put this field on a layout and you can then enter find mode and use a lone = operator as your search criteria to pull up all records where the container field is empty.

1 person found this helpful

Actions

JefferisPeterson Apr 26, 2012 11:31 AM

Hi, I'm haven't done field programming since FM 7, so I'm very rusty. I have added a calc field but am not sure what a cContaintertext field is. When I pull up the manage database I cand define calculation result as Text and place the Image Container = into the cal area. Is this what you mean? It will not let me use Image | Conatainer as a field name.

Actions

philmodjunk Apr 26, 2012 11:31 AM

remove the equals sign. Just enter the name of the container field.

WHen you enter find mode, you'll enter the = sign into this field as your search criteria.

Actions

JefferisPeterson Apr 26, 2012 12:41 PM

Thanks a lot

Actions

hugmagic Feb 11, 2019 10:33 AM

Ok, I understand a little of this but I am having a hard time figuring out where I want to start with to set up this search. When I go into the record and click on the image area and try to enter "=". I get nowhere. It is probably something very simple but I am stumped. I just need to find the records without main images.

Actions

Reid Larson @ hugmagic on Feb 11, 2019 10:36 AM

You're trying to search in the container field, instead of a newly created calculated text field.

https://community.filemaker.com/thread/101899#comment-322620

Define a calculation field cContainerText by entering the container field's name as the sole term. Specify text as the field's return type. Put this field on a layout and you can then enter find mode and use a lone = operator as your search criteria to pull up all records where the container field is empty.

Actions

Bentech @ hugmagic on Feb 11, 2019 10:39 AM

I am assuming your image area is a container field. If that's the case, you can't find records with empty container fields by using the equals sign like you can with other field types. What you CAN do, however, is script a loop through your table and use the IsEmpty() function to check the contents of your container field. If you omit the ones that are empty, you will create a found set of records without values in your container field which is what I believe you are looking for.

Actions

7 Replies

philmodjunk Apr 26, 2012 10:04 AM
Mark Correct
Correct Answer
Define a calculation field cContainerText by entering the container field's name as the sole term. Specify text as the field's return type. Put this field on a layout and you can then enter find mode and use a lone = operator as your search criteria to pull up all records where the container field is empty.
1 person found this helpful
Like • Show 1 Like1
Actions
JefferisPeterson Apr 26, 2012 11:31 AM
Mark Correct
Correct Answer
Hi, I'm haven't done field programming since FM 7, so I'm very rusty. I have added a calc field but am not sure what a cContaintertext field is. When I pull up the manage database I cand define calculation result as Text and place the Image Container = into the cal area. Is this what you mean? It will not let me use Image | Conatainer as a field name.
Like • Show 0 Likes0
Actions
philmodjunk Apr 26, 2012 11:31 AM
Unmark Correct
Correct Answer
remove the equals sign. Just enter the name of the container field.

WHen you enter find mode, you'll enter the = sign into this field as your search criteria.
Like • Show 1 Like1
Actions
JefferisPeterson Apr 26, 2012 12:41 PM
Mark Correct
Correct Answer
Thanks a lot
Like • Show 0 Likes0
Actions
hugmagic Feb 11, 2019 10:33 AM
Mark Correct
Correct Answer
Ok, I understand a little of this but I am having a hard time figuring out where I want to start with to set up this search. When I go into the record and click on the image area and try to enter "=". I get nowhere. It is probably something very simple but I am stumped. I just need to find the records without main images.
Like • Show 0 Likes0
Actions
Reid Larson @ hugmagic on Feb 11, 2019 10:36 AM
Mark Correct
Correct Answer
You're trying to search in the container field, instead of a newly created calculated text field.

https://community.filemaker.com/thread/101899#comment-322620
Define a calculation field cContainerText by entering the container field's name as the sole term. Specify text as the field's return type. Put this field on a layout and you can then enter find mode and use a lone = operator as your search criteria to pull up all records where the container field is empty.
Like • Show 1 Like1
Actions
Bentech @ hugmagic on Feb 11, 2019 10:39 AM
Mark Correct
Correct Answer
I am assuming your image area is a container field. If that's the case, you can't find records with empty container fields by using the equals sign like you can with other field types. What you CAN do, however, is script a loop through your table and use the IsEmpty() function to check the contents of your container field. If you omit the ones that are empty, you will create a found set of records without values in your container field which is what I believe you are looking for.
Like • Show 0 Likes0
Actions

Finding empty Image containers?

Title

Post

Outcomes

Related Content

Recommended Content