Hi all App Maker Gurus,
I am able to create Model (e.g. Department) in App Maker > Cloud SQL. And i know how to create basic Model, Department with Fields Code, Name, EffectiveDate
e.g. Code/Name/EffectiveDate IT / Information Technology / 1 Jan 2018 IT / Information Tech & Sec / 1 May 2018
i am trying to mention, effectively 1 May 2018, IT department is called 'Information Tech & Sec'. How can i perform that as My "Code" is now Primary Key and it doesn't accept another row due to duplicate key? The unique key supposed to be combination of Code + EffectiveDate.
How can i configure in Google App Maker?
Thanks for the guide.