Acoustic Campaign Ideas

The Acoustic Ideas portal has moved! Please sign up for our new Ideas portal and submit your suggestions at

Don't allow a Lookup Key field to be changed to a date field

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Sep 19 2018
  • Under Consideration
How will this idea be used?

Depending on the procedure to change the column type, I cannot change the lookup key

1. Create a DB containing text type columns
2. Set a text type column as a lookup key
3. Change the text type column to the date type
4. Since the date type cannot be set for the lookup key, it is not displayed on the change screen of the lookup key
5. Change the column changed to date type to text type again
6. I can change the lookup key

I think that it is a designed that the date type can not be a lookup key.
And I think that it is a designed that does not assume that the column designated as the lookup key is changed to the date type. Please restrict this procedure so that it can not be done. And please display any warning message for users understanding well.


Kind regards,

What is your industry? Construction / Architecture / Engineering
What is the idea priority? Medium
DeveloperWorks ID
Link to original RFE
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    12 Oct, 2018 03:01pm

    We agree! This is an item that we are researching as we continue to iterate on this feature.