PushpakumarGna1
8 years agoQrew Assistant Captain
is it possible to create a quick base action or a automation for the creating the history record
Considering my situation,
I have two tables parent and child and there exists a relationship between them
the records in the parent table are
Record_id name school
1 AA X
2 BB Y
The records in the child table are
Record_id parent_id mark 1 mark2
1 1 70 80
2 1 85 89
3 2 90 98
4 2 91 92
Right now if I change any value in parent or child table, i need to create a record in the history table, which has all the columns of parent and child with the old value
If suppose i change the value of mark 2 of child record id --> 1 from 80 to 100 in the child table
The records in the child table are
Record_id parent_id mark 1 mark2
1 1 70 100 (changed from 80 to 100)
2 1 85 89
3 2 90 98
4 2 91 92
I need a new entry in the history table like below
name mark1 mark2 child_record_id parent_id school
AA 70 80 1 1 X
Can you please help in this situation.... I m new to quickbase , of possible .. can you please explain in brief.
Thanks
Pushpakumar
I have two tables parent and child and there exists a relationship between them
the records in the parent table are
Record_id name school
1 AA X
2 BB Y
The records in the child table are
Record_id parent_id mark 1 mark2
1 1 70 80
2 1 85 89
3 2 90 98
4 2 91 92
Right now if I change any value in parent or child table, i need to create a record in the history table, which has all the columns of parent and child with the old value
If suppose i change the value of mark 2 of child record id --> 1 from 80 to 100 in the child table
The records in the child table are
Record_id parent_id mark 1 mark2
1 1 70 100 (changed from 80 to 100)
2 1 85 89
3 2 90 98
4 2 91 92
I need a new entry in the history table like below
name mark1 mark2 child_record_id parent_id school
AA 70 80 1 1 X
Can you please help in this situation.... I m new to quickbase , of possible .. can you please explain in brief.
Thanks
Pushpakumar