Is it possible to create a column with a tracking number? It would look like this. There is a column - SHIPMENT TRACKING. When adding a new entry, I would like the operator to select an operator (DHL, UPS, etc.), then enter the shipment number and a tracking link will be generated. The trace link is the standard operator pages that I would define in another table.
Hi,
Is it possible to create a column with a tracking number?
It would look like this.
There is a column - SHIPMENT TRACKING. When adding a new entry, I would like the operator to select an operator (DHL, UPS, etc.), then enter the shipment number and a tracking link will be generated.
The trace link is the standard operator pages that I would define in another table.
Standard link -> A reference number should be given after the equal sign. https://tracktrace.dpd.com.pl/parcelDetails?typ=1&p1=
I found a solution :)
SELECT *, CONCAT(column1,column2) AS tracking
FROM my_table
Hi Tymek
Thank you for the update we are glad to hear you found the solution
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!