Dear all,
This community support is truly a lifesaverโฆWhen I truly have a client, then I know the real challenge.
Here is the scenario. I have table A which has a ref field to another table B. Client want to create a record and save (as draft). Because there are many users and it just happened, one of the users picked the wrong ref field and wants to make ammend after save. Now (as far as I know) as soon as you save the record, by default this ref field cannot be ammended anymore. How can we give a functionality to edit the ref field?
Here is a screenshot:
As you can see Equpment Tag is greyed out and cant be edited anymore.
Its maybe easily done but Iโm a bit blank at the moment.
Maybe i could use reset on editโฆbut you donโt make mistake most of the timeโฆso its not proper
That is not correct.
Did you make [Equipment Tag] the key column for the table by chance?
No equipment Tag is not the key columnโฆThe key column is a virtual column using a concatenation of [Equipment Description],and [Date Time Raised]โฆThese 2 column is a deref (is that term correct?) to the other tableโฆ[Equipment Tag].[Equipment Description]
Any column used by a computed key column also cannot change once saved.
if i use โlook upโ instead of deref formula it should work i think
That means if you change [Equipment Tag], then your key column value will also change. Key columns are not editable once created, so Appsheet has automatically made any precedent columns non-editable to prevent this. Youโll also find that [Date Time Raised] is also not-editable.
Iโd recommend assigning a UNIQUEID() value to a real column to be your key. The current VC that youโre using as your key can then be changed to just be the Label column.
I need these two columns as key because i want the file attachments and images to be named after 1 of these two columnsโฆonly [Date Time Raised] i can change to UniqueID() as window explorer will have date also.I continue and update you guys tomorrowโฆits 1 am hereโฆThanks bros!
Ahh, gotcha.
Well unfortunately I think youโll have to pick which one is more important; file names, or the ability to edit [Equipment Tag].
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |