I have two databases called US States and Account Managers. The account managers database has some text fields for contact details (name, email, phone). Account managers database is added to US States, and each US state has an assigned account manager.
Now I have a simple dropdown menu for US States and once the state is selected I want to show in the text box below the contact details from the Account Managers’ database. I used magic text in hopes that it would display, but for some reason, nothing is displayed. It is like the dropdown selection does not inform the text field, even though I used magic text in the text box to point to the text fields in the Account Managers database.
If I don’t use a separate Account Managers database and just add fields to US States database (name, email, phone), it works. It’s bizarre that the database linking would not work in this case. Any ideas?
Hi David!
Here are few things you can check to troubleshoot the issue:
Database Connection: Ensure that both databases are properly connected and that the credentials are correct.
SQL Queries: Verify that the SQL queries used to fetch data from the Account Managers database are correct and return the expected results.
Magic Text Configuration: Double-check the configuration of the magic text in your text box. Make sure it’s pointing to the correct field in the Account Managers database.
Event Handling: Ensure that the event handling for the dropdown menu is set up correctly to trigger the update of the text box when a state is selected.
JavaScript Errors: Check for any JavaScript errors in the browser console that might be preventing the linkage from working.
I am not sure how your suggestions apply to my case. I don’t use any external databases. These are two Adalo databases. The setup is extremely simple and should just work, but for some reason even though I can select magic text from the linked database, it does not show. It’s like the US States database does not pass the dropdown selection to the linked Account Managers database. I am not sure where I go wrong, the setup is very straight forward.
Just to update anyone who finds this post. I was able to solve this issue by using list rather than text field. I used conditions to make sure that dropdown value is passed to the list so I can use magic text. It worked.