This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I need to insert the same unique ID into the appropriate field in two different rows. I tried to solve the situation using Behaviour->Actions-> Data: set the values of some columns and this row, but it generates a different UID for each row related field. Thatโs why I used the command in Expression Assistant: CONCATENATE (โAEROTOWโ, TEXT (DATETIME (UTCNOW ()), HHMMSS)), but sometimes it generates a different value by a second.
Does anyone knows easy way how to solve this?
I am trying to build an application for aeroclubโs flights. We need to record start, landing, a pilot in command etc. But sometimes one aeroplane is towing the other (glider) and I need to identify these two flights with a unique identifier. So I do not see how can one row identify the other. Hopefully, I answer your question.
I am considering creating a dedicated table in which I will keep records for these joint flights. In this table, I will then generate an UID, which I will use for filling in both rows.
Of course, it would be better if there is some way to generate a UID first and then using it for both records.
Based on my limited understanding, you could add a column named (e.g.) TowPlane of type Ref. When the user adds the gliderโs flight, they would also select the tow planeโs flight.
Since this is the only case where you are doing this โtwo planeโ thing, I think you could create a second column field that shows just if there was a glider, and also another one as Y/N
IE:
Field 1: โIs there a glider?โ Y/N
Field 2: โSelect glider:โ Ref (Show_if [Field 1])
I donโt know if Iโm breaking any DB normalization rule but there you have it.
If instead you need to add two or more at once, you could do it with enumlist base type ref.
Check this topic:
LinkedIn
Twitter
