Test case automation for multi-language web application (multi-culture web application)

Currently, I am encountering another challenge in test automation: the test case for a multi-cultural web application.

I am developing test case automation for a web application that accommodates multi-language logins like English, French, and others. This is an internal application. When logging in as a French user, all labels switch from English to French. Should we generate duplicate test cases in various languages, or is there a functionality available to translate text, numbers, and date/time formats into any language?

What specific features are tailored for globalization testing?

Currently, we have a database containing labels in multiple languages.
By using the user id, we can retrieve specific language labels and update the dynamic selector. This allows us to locate and verify objects on a webpage.
However, creating test cases using this method is time-consuming. Does anyone know of another technique to automate such test cases?
Below is the impact of test case automation in multi-language

  • Text and number comparison in multilingual environments is dynamic and requires the use of databases, which adds code and complexity to test cases.
  • In order to compare a simple label, we must retrieve the value from the database, make the selector dynamic, and then compare it with the web application. Later, validation messages differ depending on the language, which increases complexity and the amount of time required to automate a single test case.
  • We are losing the low-code and no-code concepts.
  • We are not able to test the selector at compile time.
  • We need to make almost each selector dynamic.
  • It will highly impact our ROI as writing test case will take lot of time.