CardExchange - How to connect textboxes in card template to database fields

CardExchange - How to connect textboxes in card template to database fields

For this guide, we will be showing how you can make textboxes dynamically change according to fields in your database assuming that you already have the database connected to your card template. If not, you can check this link for a step-by-step guide.

To begin with, click on Card designer to open the card template.






The above image shows a card template with four (4) text fields. We can create a text field by going to Insert tab and clicking on Text, then click and drag inside the card template to form a box of any size.


Next, double-click on a textbox to open its properties window. 



Then inside the properties window, under the Content tab, change Fixed value from the dropdown list to a database column. In this case, we will choose the NAME column.




Upon clicking the database column, the textbox should already change according the selected field in our database.




Doing the same steps for the next textboxes, the result should look like this:




*Note: Aside from the content, other parameters can also be changed such as the Position, Text Alignment, Border, Colors, etc.


To see if the content for each textbox changes dynamically for every record, exit Card designer and check the Records view on the main window. Upon clicking on a record, the texts for each field should also change in the Preview (as seen below).

      



~ END ~

    • Related Articles

    • CardExchange - How to connect database

      Step 1: Click Cards and select the card you wish to connect the database to. In this guide, we will use a sample template. Click Card designer to open the selected card template. Step 2: Go to   tab and click New to open the database connection ...

    • Cardexchange - How to automate insertion of images to card template

      For this guide, we will be showing how you can automate insertion of images to card templates per record using the primary key of a database. To know how you can insert images to a card template, see this link for a step-by-step guide. *Note: Before ...

    • CardExchange - Cannot read database

      Resolved by checking the database file, please double check the excel file source. do not move the excel file into other directory once you linked it on the CardExchange software.

    • How to generate QR code with save as Contact function in CardExchange

      1. In QR code properties, go to function tab and paste this code stringName = "BEGIN:VCARD\nVERSION:3.0\nFN:" + Varname + "\nN:" + Varname + " \nTEL:"+ Varphone +"\nTYPE=CELL:" + Varphone + "\nEMAIL:"+ Varemail +"\nEND:VCARD" Make sure database is ...

    • Allow Cardexchange to Windows Firewall

      1. Open Windows Defender Firewall with Advanced Security 2. Select New Rule.. 3. Select Program and click Next.. 4. Input this link to the textbox. C:\Program Files (x86)\CardExchange Solutions\CardExchange Gateway\CardExchange.Gateway.exe 5. Select ...