mogg851

If it's one field I would agree that the button is the way to go. I have the button point to a script that runs as admin and the users have no edit access to that field. Script reads as follows: If [isEmpty ( Table::Field)] Show Custom Dialog ["Title"; "Please enter text for field:"; Table::Field Commit records/Requests [No dialog] End If My problem is that I now have 30 some fields on a single layout that need to be able to be changed if it is empty, but not changed if someone has already put in data. All fields are text fields. I'm really disappointed they don't have an "edit once" option for a field. As far as I can tell the field lvl access privileges are Modify, view only, or no access, there is no custom restrictions. I implemented something similar where there was a lock button/script that would only change the value of a lock field. Edit privileges checked against that field, but it effects the entire layout, not individual fields. In this case I have about 100 fields and only half need to be protected. There must be a better way to do this. Anyone have better ideas?

New here, I have done pretty well so far with scripting and the relationships to get data back for reports. But now I have a request for something I'm not sure that can be done. We have data from a table that contains and air day (day of week, name), number of minutes, as well as a dollar total, and a month/year (actually it is derived from a date field but only filter by month/year). The report that we have working takes all the records for one month and shows what days of the week have how many minutes as well as a dollar amount from that record. As a trailing grand summary it totals everything individually, IE Sat=45, sun=60, Gross$=$xxx. But my boss wants on the end of the report the totals (trailing grand summary) for the following 12 months to show as well, but its all records from the same table so when I search it only shows the month for the report. My only thought to this, which I tried and had limited success of, was to tell the script to run 12 times and copy the data from the end of each report to a global field that is static to day1month1 day2month1..., then show the requested month, but that will get to be a big number of global fields, one for each day and month, and a large script, also with the sorting could end up taking a while. Is there a faster way, portal?