Is it possible to set something to a default value on the Entry Edition? One of the customers has a card design with checkbox controls connected to excel database. When they enter the data from CardExchange they have to put a check in the boxes for a "TRUE" value in excel, but what they want is for the checkbox to be enabled by default and they would just have to uncheck it when it's not needed. I do have the default value set to 'true' but it's doesn't seem to do anything. They also have a field called company and they have to type the company name all the time, but want their company name to be default (right now I have it set if they don't enter anything, it will show their company name, but that creates a blank field in excel and they would like their company name to show there).

Hello,

If I understand the question correct you can do this by using the Input Manual mapping. First you need to make a small function in the Designer. When you open the Designer you have probably already the Company field on your card layout. Now proceed as following:

1. Add a Check box component to your layout
2. Open the Variable Editor by right click on the Variables
3. When the variable editor is opened, add a variable that is called "Checked"
4. Close the variable editor by clicking on OK
5. Double click on the Company field on your layout and select the check box under the mapping name called "Use complex expression"
6. Click on the Fx button and the Expression Editor will open
7. Now type in the Expression field : [<Company>; CheckBox1.Checked :=<Checked>]
8. Open the Mappings Window and select "Checked"
9. Connect the Checked field to "Enter Manually", set the Value to False, and Select "Make this value editable in the manual-entry window"
10. Click on Finish to close the Mappings
11. Open the Enter Manually window by selecting "Manual data entries" in the Data tab

Now if you change the value of the Checked field into True and hit Apply, the check box on the layout needs to be checked, putting it back to False will uncheck it.

Of course if these values are available in your MS Excel file, you can connect this Checked field to your database column.

I hope this answers your question.