Forum Discussion
BabiPanjikar
5 years agoQrew Assistant Captain
Adam, the other option to get this quickly is the create a separate reference table to use automation to generate the values in the table. See below.
Master table-A :
Record ID# - Unique and primary
snap id - numeric
Related Person
Reference Table-B
Record ID# unique and primary
Snap id - numeric
Create automation on table-A. On new record, insert into table-B
Create relation between Table-A (Record id) and table-B(Snap id)
Create summary field in under this relationship to create max(record)
now create reverse relationship : Table-B (Record id) and table-A (Max_record_id)
Create snap id as lookup under this relationship
On the form use this lookup value to update the snap id value on form save.
The lookup value will always be last record id from table-A which will be saved against new record id generated.
------------------------------
Babi Panjikar
------------------------------
Master table-A :
Record ID# - Unique and primary
snap id - numeric
Related Person
Reference Table-B
Record ID# unique and primary
Snap id - numeric
Create automation on table-A. On new record, insert into table-B
Create relation between Table-A (Record id) and table-B(Snap id)
Create summary field in under this relationship to create max(record)
now create reverse relationship : Table-B (Record id) and table-A (Max_record_id)
Create snap id as lookup under this relationship
On the form use this lookup value to update the snap id value on form save.
The lookup value will always be last record id from table-A which will be saved against new record id generated.
------------------------------
Babi Panjikar
------------------------------