Jump to content
Sign in to follow this  
uemtux

Repeating Field Find

Recommended Posts

I have a repeating field and I need to run a search on the contents of a single repetition across several records.

Example:

Status[1] = 1 Means a project has been opened.

Status[2] = 1 Means it's with an editor

Status[3] = 1 Means it's in mockup

So what I need to do is find all records where Status[3] = 1 but when you run a search on a repeating field it searches all the repetitions. I didn't realize this when I built my database and now it seems as if I may have to start over! Unless someone can help me run a find that does the job...

Share this post


Link to post
Share on other sites

You really should ditch the repeating fields and put your data into proper related records, although with your current example, I dont even know why you chose repeaters to begin with.

Share this post


Link to post
Share on other sites

Yep, it sure may have been a mistake to do it this way, but not if there's an answer to my question. Does anyone know if what I'm asking is possible, or should I just get straight to rebuilding from scratch?

Thanks.

Share this post


Link to post
Share on other sites

Well, assuming that the stages are "accumulating", you could add a calculation field =

Sum ( Status )

and search for "3" in there to find projects that have reached stage 3.

I am not sure that's worth the bother, when a simple redesign could solve the issue. In any case, it's not possible to limit a find to a specific repetition.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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