When you add Magic Text to your External Collections, you'll also need to give an example value. The value only used during the final step of the External Collection set up, when Adalo tests the connection and determines the properties of the External Collection.