Hello guys, I’m trying to make a calculated field that involves text instead of numbers. I would like to know if there is a way to do this:
I have a scenario in which I have a Table called Events.
I want to have a calculated field named Contractors_Attending that will list all the Contractors that we have assigned to attend to each event, this means that multiple Contractors can be assigned to one event. Below I’m explaining the name of each table and field, also the relationship between the tables.
Notes: The Contractor_Name on the Invoice is Retrieved from the Profile table. It is a combination of: First_Name and Last_Name
Here is the Tables and Fields:
Table Name: Event
Field Name: Company_Name
Field Name: Contractors_Attending
Table Name: Profile
Field Name: First_Name
Field Name: Last_Name
Table Name: Invoice
Field Name: Contractor_Name
Field Name: Company_Name
Calculated Fields and Text Concatenation Possible?
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: Calculated Fields and Text Concatenation Possible?
hello
what the key between this table .
in my project i use calculated field to Make invoice number :
for example if ID = 1000 ,
then invoice number will be RE-1000
what the key between this table .
in my project i use calculated field to Make invoice number :
for example if ID = 1000 ,
then invoice number will be RE-1000
Code: Select all
SELECT CONCAT('RE','-',%ID%) FROM `Item_Request` WHERE `Item_Request`.`ID`='%ID%'
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: Calculated Fields and Text Concatenation Possible?
thank you, but your situation does not apply here.