Greeting of the day,
A tutorial I have seen for giving multiple Image / File type entries,
Is it being possible to do the same for the following structure in where the type is text,
The format goes like this
Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)This is the order I would like to give multiple entries for my entry of Shop/person
(1-4) will be repeated multiple times ( I do not have any fixed Number for this, so I am not able to make the structure for this which should be assigned under the shop/person (where uniqueid(“UUID”) is the column i am using for the shop/person Identification)
1.Product,
2. Number of pieces (Nos)
3.Price,
4.Discount,where 5 gives the total of all entries
5. Total Amount
Regards.
A tutorial for adding Multiple images
You left a space between the
]
and(
The tutorial seems pretty straightforward, you won’t find more detailed info here. Follow it. Unless I have understand you wrong
Which “entries” are you talking about? Multiple images, documents, etc?
Firstly, Thank you for your reply.
Yes I do agree that the tutorial is straightforward,
my query is can I do the same for inputting text.
If so, how can I do it!
this is just title :A tutorial for adding Multiple images
The format goes like this
Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)
Can I apply the same for entering multiple data (type of data: text).
This is the order I would like to give multiple entries for my entry of Shop/person
(1-3) will be repeated
1.Product,
2. Number of pieces (Nos)
2.Price,
3.Discount,
where 4 gives the total of all entries
4. Total Amount
Regards.
No, the idea of a key is that its value appears once and only once in the table in that column.
Simple. Don’t use the Person/Shop as the key. What I recommend is to have a dedicated column for the key and use the UNIQUEID() function to randomly assign a unique id used as the row key. Then you can add as many rows as you want for the same Person/Shop - each would have a unique key column value.
Thank you very much for the reply,
this is just title :A tutorial for adding Multiple images
The format goes like this
Date(changetimestamp)
UUID
Shop/person (reference table)
number (reference table)
This is the order I would like to give multiple entries for my entry of Shop/person
(1-3) will be repeated multiple times ( I do not have any fixed Number for this, so I am not able to make the structure for this which should be assigned under the shop/person (where uniqueid(“UUID”) is the column i am using for the shop/person Identification)
1.Product,
2. Number of pieces (Nos)
2.Price,
3.Discount,
where 4 gives the total of all entries
4. Total Amount
Regards.
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |