December 14, 2025Dec 14 I'm not really sure I'm posting in the correct sub-forum, but hoping for the best 🙂 And I have two questions, which I'll ask in two posts. Question: My Proposal db has a field called Fee Amount. I use this field in two instances: — Form View, which I use to prepare new Proposals. — List View, which lets me see a list of open proposals.  I use a simple script to only show open Proposals, based on a field called Open. So far, so good. I want to restrict data entry in Fee Amount. Data can only be changed through the original Proposal (the Form View instance). I do not want Fee Amount changeable when I am looking at the list. Is this possible? I'm far from any sort of expert. I'm running FM Pro Advanced 17, Mac Mojave 10.14.6. Edited December 14, 2025Dec 14 by msadesign Clarity (FM version used).
December 14, 2025Dec 14 A simple solution could be to prevent field entry in the list view layout: https://help.claris.com/en/pro-help/content/allowing-preventing-field-entry.html But I am curious why you need such restriction. Usually you want to control who can modify a value, not where can they do so. Â
December 14, 2025Dec 14 Author Thanks. Although I am well familiar with the online Claris help pages, I didn't notice this until now, which of course answers my question: "Preventing entry into a field only affects the field object on that layout" * As to why, I take your point, and it's probably overkill, particularly since I am the only one ever using these files. And while I only write a few Proposals a month, I do have call to revise fairly often; I wanted to be sure that fees and scope items are close by and on the same layout. Thank you for your help :-) *https://help.claris.com/en/pro-help/content/allowing-preventing-field-entry.html
December 14, 2025Dec 14 5 minutes ago, msadesign said: I wanted to be sure that fees and scope items are close by and on the same layout. Maybe you would prefer to make the field a button that takes you to the form layout? Or opens a popover that shows all the relevant items. Â
Create an account or sign in to comment