Forum Discussion

NaveedAhmed's avatar
NaveedAhmed
Qrew Cadet
6 years ago

Field Y to get copied on field X, just within the same record...

I have 2 fields (X and Y) within the same table. 
If within a particular record, if Y is modified, I want X to get the same value. If Y is in record# 22 only, only this record's field X should be modified.

How to go about it?

------------------------------
Naveed Ahmed
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    Are you expecting field Y to be empty and then when it is filled in you want the data transferred over to x? Are you wanting X to be kind of like a logging field? As in it will hold all of the previous data that people enter into Y, could happen multiple times?

    I'm just trying to figure out why you need the data duplicated to a secondary field. If the data is going to be the same between the fields then I don't see the use case. Maybe you can explain a little bit more about the use case.
    • NaveedAhmed's avatar
      NaveedAhmed
      Qrew Cadet
      6 years ago

      Fields X and Y are requried to be dropdowns and will both have their own options and values; options of Y are a subset of that of X. However when Y is chose, it should also change X. Inshort, if Y has a specific value in it then X should also have the same value.



      ------------------------------
      Naveed Ahmed
      ------------------------------