Search results for query: *

Hi I have one field i.e. Table.Notes This field has many entries against each record and the notes are pre-fixed i.e. RECORD NO NOTE FIELD Record 1 PREFIXED WITH NoteA: sdkfskjfsldflksd PREFIXED WITH NoteB: dosdofposdf;lksf;ksfdk; PREFIXED WITH NoteC: kdsflsdkflskflsdf...

Hi We have a formula that adds various fields up i.e. pay1 + pay2 + pay3 We have added some new payment fields to the table and amended the formula pay1 + pay2 + pay3 + pay4 + pay5 The formula no longer works and appears to be seing the fields as blank rather than null - any pointers...

Hi I need to write a report as follow:- OBJECTIVE 1 GREEN OBJECTIVE 2 AMBER OBJECTIVE 3 RED OBJECTIVE 4 GREEN OBJECTIVE 5 AMBER OBJECTIVE 6 RED OBJECTIVE 7 GREEN I then need the report to group as follows GREEN OBJECTIVE 1 OBJECTIVE 4 OBJECTIVE 7 AMBER...

Hi I need to put a few formulas in a report. I have two fields:- Total Fees Date Fees Billed I need to add to a report TOTAL FEES YEAR 1 TOTAL FEES YEAR 2 TOTAL FEES YEAR 3 TOTAL FEES YEAR 4 I have been trying to write a formula but I am having trouble getting it to work - any...

Hi I am doing a report that has a Memo field for people to collate comments, I have written a report that brings all the comments ever added and I want to export this into excel which is fine, the only problem is people now want to use excel add a filter to search on a company name and it bring...

Hi I have a field that is a datetime field, I need to convert this to a date field as I need to preform a count on how many records for each day per month, at the moment it is counting how many datetime and therefore is showing hundreds of records per day when I just want it to count 1 record...

Hi I want to add a field to a formula as below if {@Outcome} = 'YES' then 'You are Correct' else if {@Outcome} = 'Maybe' then 'You could be right' else if {@Outcome} = 'NO' then 'You are Wrong' and I want to then add a field here so that when the text is displayed it will say 'You are wrong...

Hi I have a problem where I have against many records some data in one field i.e. Type Number Action Concluded Name Lisa No 1 Ring Y Name Lisa No 1 Write N Name Lisa No 1 Write M Name Lisa No 1...

Hi I have multiple records that I am displaying in a report, there could be 100 records but I only want to display the last 6. Thanks, Lisa

Hi I have 10 fields that are checkboxes there could be one ticked or 5 ticked or even 10. I have tried to do a formula like if field 1 = y and field 2 = Y then 'red and blue' else if field 1 = y and field 4 = yes then 'red and green' and so on and I need to display every possible scenario -...

Hi I have a report that has 5 dates and I need a report to display the latest date i.e. date2 > date1 then put in date2 or if date3 > date2 then put in date3 else date1 Can anyone help with this. Thanks, Lisa

Hi I have created a templated and I need to create a tooldbar shortcut that brings up a prompt to a user to enter some data for a field to equal i.e. index number and they type in 6 then the document merges to a new document. Any help would be greatly appreciated. Thanks, Lisa

Hi I am trying to write a formula to do the following:- if {matter.matter_description} endswith '(ACQ*)' then 'Acquisition' else if {matter.matter_description} endswith '(SH*)' then 'South House' else other The field that I am testing has a descrption that at the end of the description...