0

Formulas
Hello,
When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find: X" when searching a specific word/name associated with a formula field?
- John
When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find: X" when searching a specific word/name associated with a formula field?
- John
Like Follow
62replies
-
Hello,
I am trying to determine the number of unique courses a teacher has from a table that contains all assigned courses. I am able to get it down to list of the teachers and a concatenated list of their courses.
Screenshot 1
Screenshot 2
I am having trouble grouping the values in the concatenated string. I imagine it is a simple line of code, but I cannot seem to find the solution. In the end I would like the # of unique course codes to show. For example in record #1 it would have a 3 in the formula category. -
Hello - regarding the 'display field, only if' option: using the visual function editor, I don't seem to be able to display a field based on a value in a drop down field. Specifically, in a contacts table, I have a multiple choice field 'Type' as a combobox. One of the values is 'company contact'. Only if 'company contact' is selected would a company field (which is referenced to a 'companies' table') be displayed. However in the 'fields' section of the function editor I can only insert 'type' and not one of the choice values that field contains.
Is there a workaround, or do I need to create a formula with text only?
Thanks, Dean -
Hi, I've a field combobox called 'Status Fattura' with five different choices: Da emettere, Emessa, Inviata, Pagata, Scaduta.
I would like to automatically change a value of the combobox 'Status Fattura' with the following function inserted in a formula field:
if today() > 'Data scadenza fattura' and 'Status fattura' != "Pagata" then 'Status Fattura' = "Scaduta" end
The field 'Data scadenza fattura' is a Date field.
But so doesn't work, the function doesn't change the value in "Scaduta" inside the combobox 'Status Fattura'.
Why?
Thx a lot.