Forum Discussion
RussellLane
6 years agoQuickbase Staff
Hey folks - thanks so much for your question, and for the comments and answers! We noticed the discrepancy between the UI and the API around this issue, and had some concern about possible data integrity issues resulting from that. Data integrity is a critical issue to us, so we've made a change that will make the API behave the same as the UI - it will no longer be possible to set formula fields as keys via the API. That should appear in an upcoming release.
- QuickBaseCoachD6 years agoQrew CaptainRussel,
Thx for that clarification. I used to use that technique, but then ran into "bugs"where I had records with duplicate key fields. Given that this was an undocumented feature, I reverted back to a traditional Key field. - DrewVoge6 years agoQrew Cadetwill the change in the API behavior in any way affect existing tables where the key was established in this manner?
- hhersch6 years agoQuickbase StaffHi Drew - it will not. But having a formula key field has the potential to cause inaccurate data.