Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Dividing a Large Checkbox Field into Several Smaller Checkbox Fields


meowy
 Share

Recommended Posts

Hello folks,

 

My task is to break down a big checkbox field into multiple smaller fields while retaining the existing entries.

 

So, for example, I have a big checkbox field (Field A) containing the data:

 

1

2

3

4

5

6

 

And I need to break it up into two new checkbox fields, so that Field B contains:

 

1

2

3

 

and Field C contains:

 

4

5

6

 

The existing data from Field A needs to be divided appropriately into the new fields. I'd also like to keep things clean and not have any extraneous data in the new fields (ie I don't want any 1s 2s or 3s in Field C). Any help would be appreciated.

 

Thanks,

 

Gabriel

Link to comment
Share on other sites

Define Field B as a calculation field of result type "text":

 

Substitute (Field A; ["4"; ""]; ["5"; ""]; ["6"; ""]; ["¶¶"; "¶"])

 

Attach to it new value list consisting of values 1, 2, and 3 only.

 

Define Field C as a calculation field of result type "text" also:

 

Substitute (Field A; ["1"; ""]; ["2"; ""]; ["3"; ""]; ["¶¶"; "¶"])

 

Attach to it new value list consisting of values 4, 5 and 6 only.

 

 

These two fields are not editable. If you want fields B and C to be editable, instead of defining them as such, do a Show All Record and then use Replace Field Contents in each field using those respective formulas.

Link to comment
Share on other sites

Thanks for the quick response.

 

I understand the logic behind the formula you suggest, and it makes sense to me.

 

However, when I try it out I always get an error - "field cannot be found" in reference to my Field A.

 

I did replace my variables (Field A, Field B, etc) with the correct field names, and I double-checked my spelling to be sure I'm referencing a real field.

 

I even tried making a new database from scratch, with only the three fields and the three value lists, just to see if there was perhaps something wrong with my original file. But I still get the same error message.

 

Web and forum search yielded one instance of similar problem but no solution.

 

Thanks,

 

G

Link to comment
Share on other sites

Oops, you're in Filemaker 5? Sorry, missed that. Same logic, older way of writing it:

 

Substitute (Substitute (Substitute (Substitute(Field A, "4", ""), "5", ""), "6", ""), "¶¶", "¶")

 

 

The convenient []; []; way of doing it came along later.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

 Share



×
×
  • Create New...

Important Information

Terms of Use