Hello,
Iโm working on an app that creates simple subscription contracts. These contracts have a [StartDate] and an [EndDate], but I want to โRenewโ these contracts โwithoutโ creating a new entry and i need to โlogโ all the start and end dates before and after a renewal. What is the best way to do so?
If anyone can tell me how to ADD the NEW value of the EDITED column to the EXISTING/PREVIOUS value of that SAME column/field iโm editing it will solve my problem.
Hereโs what i tried on a TEXT column named [LogAllStartDates]:
Concatenate([_This],โโ,Text([NewStartDate],โdd/mm/yyyyโ)
also tried:
Concatenate([_ThisRow].[LogOfAllStartDates],โโ, Text([NewStartDate],โdd/mm/yyyyโ)
also tried
Concatenate([LogOfAllStartDates],โโ, Text([NewStartDate],โdd/mm/yyyyโ)
PS: I donโt want to use โENUMLISTโ
All failed. Please advice
Thank you
Add a couple new columns to hold the old values. Create a data update action, triggered by a workflow, or a form save, that sets the value of your [LogOfAllStartDates] column to a concatenation of the old and new values, and then also resets the old value.
OR
Create a Child table for Start and End dates, then you can easily add as many start/end child records as you want.
Hello Marc,
The first option is not what i will be going for, it is a limited option. As for the second, well i never tried the child/parent records! Iโll look into that - can you point me to where to start?
Thanks
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |