Jump to content

Text Color Calc


Mike J
 Share

This topic is 5692 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5692 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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