Text Color Calc

[Mike J]

I'm trying to create a visual data entry process for my users. I would like to create a way by which my users hit a button to create a code of DNA.

I envision four buttons to sequentially insert data into a field in a particular color.

G [black]

A [Green]

T [Red]

C [blue]

I've tried to think, using my limited knowledge, of a way of doing this with no success. I tried using a temp field to insert the data and a second display field set to autoenter data from the temp field with various text formatting calcs.

I know this should be straight forward in some sense, but I'm just not finding the right way to do it.

Help!

MJ

Edited February 26, 2007 by Guest

[mr_vodka]

Can you please elaborate? Why cant you just have 4 fields for entry? I am not following.

[comment]

Here's a simple method (attached).

Here's a more sophisticated one.

DNA.fp7.zip

[Mike J]

The process is this: We create a DNA sequence to send to a company that synthesizes it for us. We do this in excel and use color to highlight the sequence (highly error prone and costly if the sequence is wrong). I'm looking for a more controlled data entry and display that allows us to only hit buttons that are the only Text needed and displayed in a visual way similar to how DNA sequencing is provided back to us (G is a black peak, A is a green peak, T is a red peak, C is a blue peak) Scientist get the color scheme and would help if they entered their own data using it.

I need a more visual way for the user to enter and see sequence when creating new sequences.

MJ

Edited February 27, 2007 by Guest

[Mike J]

Here's a simple method (attached).

Here's a more sophisticated one.

Exactly what I want comment, I don't have access to the file for some reason, how did you do that?

[Mike J]

Comment,

Thanks for the link to the other types of text modifications. That was a great string of dialog. I totally understand this tip in that the user actively selects the text to change while in an active field. You simpler version is what I would like to do, but don't have the ability to view anything or do anything in your example file. Is there some sort of permission I'm not getting?

MJ

[Tissot]

...make sure you're logged in. The file should appear under the Message.

Regards

Ron

[comment]

I don't know what the problem is - the file is unlocked. The account name is "Admin" and the password is blank, and the file is set to open automatically with these.

Could it be that your computer has set the file to read-only (on OS level)?

[Genx]

Yeh it works fine for me.

Neat idea with the simple substitute btw.

[Mike J]

I'm dumb, didn't extract it.

Perfect, exactly what I was looking for. I tried substitute but made it more complicated that it truely was.

Most cases someone with my knowledge about FMP tends to do this. Can't wait to look back someday and review my DB creations a chuckle at the techniques I tried.

Thanks again!!

Mike