Forum Discussion
RaziD_
3 years agoQrew Cadet
- You need to create summary field in Project table(number of Samples), lets say you name it Counter
- Bring Counter field as a lookup into Samples table ==>Project - Counter
- Create numeric field in Samples Table ==> Counter(SS)
- In field (Counter(SS)) settings under Advanced section change it to as in image(below)
- Your Sample Number formula needs to be as below
I haven't try it. If [Counter(SS)] =0 for first Sample Record you can add 1 in formula ==>NotLeft(ToText(101+[Counter(SS)]), 1)
I hope this help.
Thanks
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
- RaziD_3 years agoQrew CadetAndrew;
If you think you may delete Sample Record in the future, instead of creating summary field in Projects table create a numeric field and increase value in this field(+1) everytime you add new Sample record with webhook or automation or another way.
Thanks
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------