AnsweredAssumed Answered

How to add x into blank field when new record created?

Question asked by disabled_dconnect on Dec 11, 2013
Latest reply on Dec 11, 2013 by disabled_dconnect

Title

How to add x into blank field when new record created?

Post

     Hi,

     I have two tables. One table is shown via a portal in the other table.

     I can write new records into the table in the portal using the portal.

     This table has 10 fields, but I only have 4 showing in the portal.

     I want to add new records via the portal. I will fill out the 4 fields, and the other fields will have x in them.

     I need this as the legacy of my database is that it has all blank fields filled with a x instead of just being empty.

     I looked through the forum, but can only find more complicated auto populate advice for dates etc.

     I just want fmp12 to make sure that when new records are created, if there are any fields that are not filled in, they automatically get x entered into them when the record is created.

     Thanks.

Outcomes