Solved

Filemaker pro 11 Scripting Portal

Posted on 2011-02-22
1
559 Views
Last Modified: 2012-08-13
I have a database (see attached) that has two tables (ProjectDetails and ProjectArchive). I have created a portal using the ProjectDetails as the source. What I want to do is be able to move (copy into) the records into the ProjectArchive table once the 'Archive' field is set to 'Yes' in a particular record. I have created a script ('Set Reset Archive') that allows the user to click on the 'Archive' field and this script will change between the values  'Yes' or 'No' (1 or 0). I basically want to append the particular record into the ProjectArchive table leaving the original record under the ProjectDetails Table.
Thanks.
Project--Archiving.fp7
0
Comment
Question by:PachecoPrimo
1 Comment
 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 34958041
Once the record has been archived what will you do with the original record?  Can it be archived again?  When the Archive is complete will you switch the value back to No?

I'm wondering if there isn't a better way of presenting this.  Maybe with a button?  

I've made a couple of modifications to the script.  See if they are what you are looking for...
Project--Archiving.fp7
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question