Auto-enter text for all records.

[splodgehodge]

Hi,

Thanks for the previous help. I'm almost there now!!

I want to have previously entered data on fields for all of my records.

I thought I could use the auto-enter data option but this only works on the fields where I have just put the conditional formatting.

When browseing the remaining fields remain blank.

Any ideas?

Thanks

[LaRetta]

If you have auto-enter DATA option then you will have to find all records (possibly only those which are blank now?) and insert the data.

[splodgehodge]

They still don't appear unless they have the conditional formatting applied to the field.

I'm still at the design process of the db so deleted all the records and tried again, but, they still only appeared with the formatting. I was wondering whether I should have a conditional formatting on the field to show the text?

Thanks so far,

[LaRetta]

I guess I'm not understanding you.

"They still don't appear unless they have the conditional formatting applied to the field."

Right. Conditional formatting is applied while in layout mode and applied to the text field. Then, when the radio button changes, the color of the text within that text field (if text exists) will change also.

If it is still confusing, it might help if you provide your file or an example of what you are working on. Sometimes seeing something in action is easier than explaining it. You can attach a sample file to your posts here. :wink2:

[Søren Dyhr]

I want to have previously entered data on fields for all of my records.

You would need to explain why this requirement is urged, seems like a structural issue, but if the scarce provisions should prevail wouldn't anyone here be able to nail your problem.

You would need to get away from the artifacts and behaviors and give us the "bigger picture" - the issue is if we should list the interpretations of what you have released so far, could you be missing fundamental knowledge to relational databases.

You could have ignored that lookups gives tons of redundant data and the keeping of these in sync with the realities they're supposed to reflect would be at least tiresome to maintain if the integrity could be kept at all?

But I guess that it's related to this:

http://fmforums.com/forum/showtopic.php?tid/212704/post/347377/fromactivity/posts/#347377

...isn't it?

--sd

[LaRetta]

You would need to explain why this requirement is urged, seems like a structural issue, but if the scarce provisions should prevail wouldn't anyone here be able to nail your problem.

Uhm, Søren, it isn't that unusual to want auto-enter data on a field as the default entry but then allow Users to change that data; I don't see a structural issue at all. And it would be required, if a new auto-enter data process is implemented, to go back to the prior records and update them. At least that's how I'm interpreting 'auto-enter data'. Are we missing each other still?

:wink2:

Edited December 31, 2009 by Guest

[Søren Dyhr]

entered data on fields for all of my records.

Is said, but not for newly created records ... as far as I read it!

--sd

[splodgehodge]

Wow!!! thanks for the replies.

All I want is for some information to be shown in the field. The user probably wont change this data but might.

I thought that if I ticked the data area in auto enter that it would just appear?

I have no records as yet, so I'm just trying it out.

The conditional formatting I have on the field is so that the field changes colour when a user clicks on a radio button, nothing complicated, honest.

I'll see if I can post up some pictures after tea

[Søren Dyhr]

To me is it a repetition of your previous post still too focused on the experienced artifact. Stop using the specific tools metaphors ... what is the overall purpose of the solution?

--sd

[LaRetta]

The user probably wont change this data but might. I thought that if I ticked the data area in auto enter that it would just appear?

Well, Søren, we still have no information to work with here but it is not unusual to have an auto-enter data field as default and then let a User 'possibly' change that data.

I have no records as yet, so I'm just trying it out.

Auto-enter DATA only takes place when a record is created. Have you created a new record? I really wanted a sample of what you were doing because it is difficult to discuss the requirements without a bit of context or purpose but here's an example.

In the example, the default terms on a Company is Net 30. But sometimes you may want to extend special terms (such as Net 120 or even Cash Only) so you need the ability to change the text value. Then the radio button colorizes the Terms so that, if the Terms says Net 30 but the customer is flagged as 'No' on GoodCredit, it will turn the terms red so the User can do whatever they need to or just be aware of whatever you need them to know.

I hope this is helpful. And don't worry about Søren and I seeing different views ... that is what makes this forum so great; that you can pick and choose according to what fits for you. :wink2:

AutoEnterData.zip

Edited December 31, 2009 by Guest