Board index filemaker

Script and Copy from one field to another field (Same database, different layout)

Script and Copy from one field to another field (Same database, different layout)

Post by shadowcat.. » Sat, 22 May 1999 04:00:00



First, thanks to all that helped me with my trim function!

My next problem...

I have a database that tracks all meetings of our software developers
When they discuss strategies for handling problems generated either by
our customers (workplans), internal testing (IW), or by themselves
(Software Problems or SPR)

My problem, the users don't always enter in IWs, WPs or SPRs in the
correct format, which then makes it difficult for our Department
Managers to track the amount of work going on against any one
particular problem.

I've come up with layout and field definitions that when entered give
off the correct format for the IW, WP or SPR according to what the user
has entered:

IW = "IW" & "-" & Trim(NumToText(IW_Year) & "-" & Trim(NumToText
(IW_Iteration)
   i.e. IW98-007

SPR = "SPR" & Trim(NumToText(SPR_Ver) & "-" & Trim(NumToText
(SPR_Iteration)
   i.e. SPR99-001

WP = Trim(Site_Code) & "-" Trim(NumToText(WP_Year) & "-" (Trim(NumToText
(WP_Segment) & "-" Trim(NumToText(WP_Interation)
   i.e. ABC-99-23-001

My problem...

I need a script which will look at what the user has entered (it will
be either IW, SPR or WP, never a combination of any), concatenate it
into either IW, SPR or WP formating, and then cut the information in
the generated field and paste it into a different field on another
layout in the same database.  Oh, for clarity, both involved fields
would of type TEXT.

If you need further clarity, I can be contacted at

Thank you for any help!

- Teresa K
  Configuration Management
  Sterling Software ITD

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---

 
 
 
Top

Script and Copy from one field to another field (Same database, different layout)

Post by Stu Bulm » Sat, 22 May 1999 04:00:00


<<I have a database that tracks all meetings of our software developers
When they discuss strategies for handling problems generated either by
our customers (workplans), internal testing (IW), or by themselves
(Software Problems or SPR)

My problem, the users don't always enter in IWs, WPs or SPRs in the
correct format, which then makes it difficult for our Department
Managers to track the amount of work going on against any one
particular problem.

I've come up with layout and field definitions that when entered give
off the correct format for the IW, WP or SPR according to what the user
has entered:

IW = "IW" & "-" & Trim(NumToText(IW_Year) & "-" & Trim(NumToText
(IW_Iteration)
   i.e. IW98-007

SPR = "SPR" & Trim(NumToText(SPR_Ver) & "-" & Trim(NumToText
(SPR_Iteration)
   i.e. SPR99-001

WP = Trim(Site_Code) & "-" Trim(NumToText(WP_Year) & "-" (Trim(NumToText
(WP_Segment) & "-" Trim(NumToText(WP_Interation)
   i.e. ABC-99-23-001

My problem...

I need a script which will look at what the user has entered (it will
be either IW, SPR or WP, never a combination of any), concatenate it
into either IW, SPR or WP formating, and then cut the information in
the generated field and paste it into a different field on another
layout in the same database.  Oh, for clarity, both involved fields
would of type TEXT.>>

If I understand you correctly you're already 95% there. Assuming you do not
need to modify the new field, no script is needed. Simply define a calculation
field set to text concatenating the values of the fields in question thusly:
IW & SPR & WP

Place the field on the desired layout.

Regards,

Stu Bulman
Stuart E. Bulman & Associates

 
 
 
Top

Script and Copy from one field to another field (Same database, different layout)

Post by Lynn All » Sat, 22 May 1999 04:00:00



> <<I have a database that tracks all meetings of our software developers
> When they discuss strategies for handling problems generated either by
> our customers (workplans), internal testing (IW), or by themselves
> (Software Problems or SPR)

> My problem, the users don't always enter in IW's, WP's or SPR's in the
> correct format, which then makes it difficult for our Department
> Managers to track the amount of work going on against any one
> particular problem.

You can use various strategies to force compliant entry by your users
including validation by calculation, but if you don't want to go that
way...

Quote:> My problem...

> I need a script which will look at what the user has entered (it will
> be either IW, SPR or WP, never a combination of any), concatenate it
> into either IW, SPR or WP formating, and then cut the information in
> the generated field and paste it into a different field on another
> layout in the same database.  Oh, for clarity, both involved fields
> would of type TEXT.>>

Use Set Field in a script if you want to freeze the data. You can put
all your "Trim" calcs into the set field step if you want to. Otherwise,
if you want the data to be "live", and change if someone alters the
original entry, use a calc as Stu Bulman advised.

--

Allen & Allen Semiotics                          Web & Graphic Design
Long Beach CA USA               Filemaker Pro Consulting - Member CSA
562.938.7890  fax 562.938.7891            Custom Solutions & Training

 
 
 
Top

Script and Copy from one field to another field (Same database, different layout)

Post by Lui » Sat, 22 May 1999 04:00:00


----------


Quote:> First, thanks to all that helped me with my trim function!

> My next problem...

> I have a database that tracks all meetings of our software developers
> When they discuss strategies for handling problems generated either by
> our customers (workplans), internal testing (IW), or by themselves
> (Software Problems or SPR)

> My problem, the users don't always enter in IWs, WPs or SPRs in the
> correct format, which then makes it difficult for our Department
> Managers to track the amount of work going on against any one
> particular problem.

A easier way to make sure the correct format entered is to define the field
as a pop up menu. Thus only IW, WP, SPR can be selected as input for the
field.

Quote:> I've come up with layout and field definitions that when entered give
> off the correct format for the IW, WP or SPR according to what the user
> has entered:

> IW = "IW" & "-" & Trim(NumToText(IW_Year) & "-" & Trim(NumToText
> (IW_Iteration)
>    i.e. IW98-007

> SPR = "SPR" & Trim(NumToText(SPR_Ver) & "-" & Trim(NumToText
> (SPR_Iteration)
>    i.e. SPR99-001

> WP = Trim(Site_Code) & "-" Trim(NumToText(WP_Year) & "-" (Trim(NumToText
> (WP_Segment) & "-" Trim(NumToText(WP_Interation)
>    i.e. ABC-99-23-001

> My problem...

> I need a script which will look at what the user has entered (it will
> be either IW, SPR or WP, never a combination of any), concatenate it
> into either IW, SPR or WP formating, and then cut the information in
> the generated field and paste it into a different field on another
> layout in the same database.  Oh, for clarity, both involved fields
> would of type TEXT.

If you use my suggestion above, you already have a field containing the
information you need and in the correct format. You would not need to cut
and paste anything. Simply put the field on the layout you need.

- Show quoted text -

> If you need further clarity, I can be contacted at

> Thank you for any help!

> - Teresa K
>   Configuration Management
>   Sterling Software ITD

> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---

 
 
 
Top

Script and Copy from one field to another field (Same database, different layout)

Post by shadowcat.. » Sat, 22 May 1999 04:00:00


Hmm,
Still not getting it to work.

I believe field modification going on here.

After I have the IW or SPR or WP generated, I need to go to a new
layout, create a new record with this IW or SPR or WP information
inserted into a different field on the layout "PEER REVIEW" called
PEER_REVIEW_CONTROL_NUMBER (which is of type text), and then clear out
all the previous fields, ie.,

IW_Year
IW_Iteration
SPR_Ver
SPR_Iteration
WP_Site_Code
WP_Year
WP_Segment
WP_Interation

so that the next user will have a clean slate to enter from.

This is the script I have so far (which is probably way over the top,
and please feel free to show me any simpler way!)  The information for
IW or SPR or WP is entered on an initial layout, called "STARTPOINT".
After the user enters in his/her information, they would then hit the
continue button which would start up this script.

If[IsValid(IW)]
  Copy [Select, IW]
  Go to Layout [Peer Review Input Form]
  New Record/Request
  Paste [Select, PEER_REVIEW_CONTROL_NUMBER ]
###
### PEER_REVIEW_CONTROL_NUMBER is the field I want to paste the
###  result in!
###
  Enter Browse Mode []
  Clear [Select IW_Year]
  Clear [Select IW_Number]
Else
   If[IsValid(SPR)]
     Copy [Select, SPR]
     Go to Layout [Peer Review Input Form]
     New Record/Request
     Paste [Select, PEER_REVIEW_CONTROL_NUMBER ]
     Enter Browse Mode []
     Clear [Select SPR_Ver]
     Clear [Select SPR_Number]
   Else
     If[IsValid(WP)]
       Copy [Select, WP]
       Go to Layout [Peer Review Input Form]
       New Record/Request
       Paste [Select, PEER_REVIEW_CONTROL_NUMBER ]
       Enter Browse Mode []
       Clear [Select WP_Site_ID]
       Clear [Select WP_Site_Year]
       Clear [Select WP_Site_Segment]
       Clear [Select WP_Site_Number]
     Endif
   Endif
Endif

The information is getting cleared out, and new record *is* being
generated, but nothing is showing up in PEER_REVIEW_CONTROL_NUMBER

Help!

- Teresa K.
  Configuration Management
  Sterling Software ITD

Quote:> If I understand you correctly you're already 95% there. Assuming you
do not
> need to modify the new field, no script is needed. Simply define a
calculation
> field set to text concatenating the values of the fields in question
thusly:
> IW & SPR & WP

> Place the field on the desired layout.

> Regards,

> Stu Bulman
> Stuart E. Bulman & Associates

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
 
 
 
Top

1. Copying logical fields to a memo field in one database

I was wondering if anyone had any suggestions on this.

I have a table with numerous logical fields and a couple of memo fields. What
I'd like to do is this:

When someone enters a false logical in a field, that field name will be added
to one of the memo fields.

I've got a form for users to enter the data, so I'm thinking that that can be
designed to do the job, but I'm not sure exactly how. I am a OPAL beginner, but
don't let that scare you away from suggesting code.

Please let me know if anyone has any ideas. Anything will be much appreciated.

Thanks in advance.

2. msflexgrid row question

3. Removing duplicates from one field while sorting by a different field

4. SQL setup problem

5. Using scripts to copy fields from one file to another

6. Compile Error 2664 with CreateParameter

7. Help: copy memo field from one table to another field

8. Sending GUID values as parameter to stored procedure

9. how to copy and paste several fields from one file to an other one

10. How to copy a field from one record to a related record in the same database

11. Need Help: search/replace data in one field/one record, by queries or script: PDOX5

12. Copy/Paste fields not on layout: what options ?

13. insert data from one field in one table to another field in another table


All times are UTC
Board index