Solved

Filemaker - Portal table - Allow add, delete but not to edit

Posted on 2013-11-12
5
1,246 Views
Last Modified: 2013-11-21
We havea  portal that shows a number of rows, and an empty row at the bottom that allows a new entry.

We also have a button setup to delete entries.

This is all fine; however once they add an entry, they are not allowed to edit it.

We have an issue in that a drop down appears for new entries (correctly) to pick from a value list.
Then once added, you can still pick this field and change it (incorrect).

The table has a linked subtable holds sub information that is only relevant to that entry (hence why we do not want this changed)

How can we solve this data entry issue?
0
Comment
Question by:webforcesuk
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:Will Loving
ID: 39641670
There are a couple of ways to handled this. Given your current structure, you could make the entry field a button that runs a simple script. The script would be an If statement which simply tests whether the field has a value in it. If not, you can use a Go To Field or Commit Records step to take the focus away from the field. You can include a Beep or dialog if you wish saying it's not editable.

If [ not is empty( SomeTable::SomeField ) ]
    Go to Field [ Some other field ]
    Beep
End If

Something else to consider though is scripting the entire new portal entry process. This allows you to simply turn off browse access to the field entirely and to have greater control over the process of adding new entries. It also have the beneficial design effects of 1) no longer needing users to scroll to the end of the portal list to create a new record, and 2) keeping users from accidentally creating new records they don't and then forgetting to delete them (a common problem when allowing users to create new records via portal entry)
0
 

Author Comment

by:webforcesuk
ID: 39641980
OK, thanks.

For a few extra points, how would you go about doign this "add" via a button that sits ourside the portal within the parent tables layout?
0
 

Author Comment

by:webforcesuk
ID: 39641995
PS: The first otpion works but not quite.  It certainly stops any input on fields already having a value in the field.  However my value list drop down no longer works for the new field entry.  Just remains blank.  Any thoughts?
0
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39642218
The script should probably be:

If [ not is empty( SomeTable::SomeField ) ]
    Go to Field [ Some other field ]
Else
    Go to Field [ SomeTable::SomeField ]
End If

I've attached a file that shows two portals. One setup the way you are currently doing things and one with a "New Record" button instead to create the new portal record. Note that the portal is sorted in such a way to ensure that the new record pops to the top. There are lots of other ways to do this and various coding efficiencies that can be incorporated, but this is the simple way: save the parent ID, go to a layout based on the related table, create a new record, Set the parent ID, go back to the original layout.

I've also incorporated two script triggers.

(On a separate note: while you can list any range of points for answering a question, in practice, virtually all questions are listed at 500 points.)
Add-New-Record-Basic.fp7
0
 

Author Comment

by:webforcesuk
ID: 39644886
Hi Will,

I will need a couple of days to look at this, but at present, I would suggest it exactly what I needed.

Once checked, Ill close the case and get you your points.

Thanks so far.

Martin
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FM - Mouse Scroll 3 529
How to create a dynamic valuelist with by filtering a table in Filemaker? 19 636
FM - Design Issue 6 147
Advertising design for my own Purpose 5 81
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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