Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
2 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
2 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
    2 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
    ------------------------------