Hey Saurav, to make it easy to follow along we would like to use the same tables that you are using. So quick question, how to get those EBA_CUST_* tables that you are using? Our sample database has many tables but not the ones that you used in the video. Thanks
Hey Saurav, one of the developers on my team is following all your Apex lessons. While working on this particular one though , he has a question for you. As he doesn't have the same table as you do for Calendar region, so he used EBA_DEMO_CARD_EMP. The edit case worked just fine but creating a new record is not. For this table EMPNO is the primary key and hence it is not one of the fields on the form because of which he is getting the error as in the screenshot (PK cannot be null... obviously it cannot be). Do you have any take on it? Just realized, chat does not allow screenshots but anyway error is "cannot insert NULL into the tableName.EMPNO. keep up the good work 👏
Hi mate, as EMPNO is a Primary key for the table, you have two options to populate this column when you're performing CREATE operation - 1. You can create a BEFORE INSERT Trigger on the table and there you can populate EMPNO column with the help of SEQUENCE. Here is the link if you want to study about Trigger - th-cam.com/video/zKBoAAmJx1c/w-d-xo.htmlsi=5BfpFnfW1VauIuZW 2. In the Form, currently EMPNO Item is hidden, because this item refers to the primary key. You just make it TEXT Field and write EMPNO manually. That will help you to populate the field. Just keep in mind that you always have to give a unique value in EMPNO. I hope this helps, thanks.
@@codewithsauravthis is great. Thanks. BTW how did you get those EBA_CUST_* tables so my developer can use the same tables to follow your video lessons.
Hey Saurav, to make it easy to follow along we would like to use the same tables that you are using. So quick question, how to get those EBA_CUST_* tables that you are using? Our sample database has many tables but not the ones that you used in the video. Thanks
If i want add button for create activity in cell? How.
How get default date depend the date who is click
Hey Saurav, one of the developers on my team is following all your Apex lessons. While working on this particular one though , he has a question for you. As he doesn't have the same table as you do for Calendar region, so he used EBA_DEMO_CARD_EMP. The edit case worked just fine but creating a new record is not. For this table EMPNO is the primary key and hence it is not one of the fields on the form because of which he is getting the error as in the screenshot (PK cannot be null... obviously it cannot be). Do you have any take on it? Just realized, chat does not allow screenshots but anyway error is "cannot insert NULL into the tableName.EMPNO.
keep up the good work 👏
Hi mate, as EMPNO is a Primary key for the table, you have two options to populate this column when you're performing CREATE operation -
1. You can create a BEFORE INSERT Trigger on the table and there you can populate EMPNO column with the help of SEQUENCE. Here is the link if you want to study about Trigger - th-cam.com/video/zKBoAAmJx1c/w-d-xo.htmlsi=5BfpFnfW1VauIuZW
2. In the Form, currently EMPNO Item is hidden, because this item refers to the primary key. You just make it TEXT Field and write EMPNO manually. That will help you to populate the field. Just keep in mind that you always have to give a unique value in EMPNO.
I hope this helps, thanks.
@@codewithsauravthis is great. Thanks. BTW how did you get those EBA_CUST_* tables so my developer can use the same tables to follow your video lessons.