Show Posts - lili

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - lili

Questions / how to auto fill field when i click on a record from another table?

April 13, 2022, 07:13:36 AM

here's the video of my question:
https://youtu.be/MnalBLhMhhU

what i want to do is when i click on a record from table 'ac', it will redirect to p_ac/add, and then 'pemegang_pac' and 'ac_pac' will be automatically field with 'pemegang_ac' and 'merk_ac' from a record in table 'ac' that i clicked previously.

Questions / active user field for default value other than id, name, photo, role

March 04, 2022, 08:31:38 AM

here's my user table:
id, username, password, email, role, address1, address2

anyway i can get active user address2 for default value in another table?

General Discussion / Re: UpdateRecord in page event with table_data's value from other table

February 14, 2022, 02:28:18 AM

thank you @willvin for your assistance xD

here is the solution:

Code: [Select]

$modeldata['user_id_d'] = get_active_user('user_id');
$modeldata['address_d'] = get_active_user('address_u');

do it in beforeAdd instead of afterAdd

General Discussion / UpdateRecord in page event with table_data's value from other table

February 10, 2022, 04:02:17 AM

Here is my tables:
user -> user_id, username, password, email, name, address_u
data -> data_id, user_id_d, address_d, data_1, data_2

and then i use this UpdateRecord Page Event statement in AfterAdd in 'data' table:

Code: [Select]

$table_data = array(
    "user_id_d" => "value",
    "address_d" => "value2"
);
$db->where("data_id", $rec_id);
$bool = $db->update("data", $table_data);

what code above does is when i add a record to 'data' table, the current record will have "user_id_d" and "address_d" autofilled with "value" and "value2".
my question is, is there anyway to replace "value" and "value2" with dynamic value from other table?
for example what i want to do here is:

Quote

"user_id_d" => get user_id from user
"address_d" => get address_u from user

something like that. is there anyway to achieve it?