Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
8 years ago

Limit the number of ""track changes"" in view form

So i have a field that tracks changes. Sometimes the changes are a long list.  Is there any way to have it display only the last 3 changes and then there is a link to "expand" and view all changes (almost like a "read more" link)?
  • Hi Geoffrey,

    There are a few ways this problem can be tackled depending on how you want them to display. One of the easiest is to create a formula text field that reads the log edit field and cuts it off after a certain number of characters or using some combination of the Right, Left, NotRight, NotLeft formula functions in Quick Base to parse it down as you would like. 

    For the first method let's assume the text field is called "Notes". You would want to create a formula text field with the following formula: Left([Notes], 100) & " " & URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11" where the number eleven above is the identifier of the custom form that displays only the field "Notes".

    For this instance you would need to create this new form and then find out its form id or dfid by looking at the table settings and then the Forms category where it lists each form. In this example the dfid (or form id) was 11, yours may be different depending on your number of forms. The above formula displays the first 100 characters of the "Notes" field. 

    Alternatively, if you want to get it to break off of a specific character in the body you could use a formula and the functions cited in place of Left([Notes], 100). For example if you replace Left([Notes], 100) with NotLeft(Right([Notes],"]"),1) you would get only the most recent comment. You would just need to adjust the formula till it returned the section of text you are looking for. I hope this suggestion is helpful Geoffrey. 
  • Hi Evan.  Thanks, but im guessing there is no way to apply this to the actual log edit field instead of another field.