Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
3 years ago

Program Add button to view the record just added after save

Hello! I have a table of customers. Users are able to add customer records, but not edit them. Before they are able to add a new customer record, I want to 'force' them to search existing customer...
TylerJablonski1's avatar
TylerJablonski1
Qrew Trainee
3 years ago
Any reason why you're using API_GenAddRecordForm in particular?  API_GenAddRecordForm is usually used for opening an "add record" form with certain fields pre-populated.

URLRoot() & "db/" & [_DBID_CUSTOMERS] & "?a=nwr" should open a new record in the customers table that will return you to the "view record" page for the customer when saved.

------------------------------
Tyler Jablonski
------------------------------
KarenHenke's avatar
KarenHenke
Qrew Cadet
3 years ago
Tyler!
Thank you!!

I copied that URL formula from another field and it didn't even occur to me to notice what kind of Add button I was copying (palm to forehead). 

Ugh, I feel so silly - thank you again! 
I updated the formula and it is working perfectly now.
~k

------------------------------
Karen Henke
------------------------------