Date/time, default values and access

Description

Hi Adrien,

The plugin is pretty useful and our organization can benefit a lot from it. I have few questions and put them altogether for now. If necessary can create separate issues with more details later.

What I try to figure out is

  1. how to put TIMESTAMP as default for new record (like NOW()), and have it editable (preferably through date/time picker) if necessary

  2. how to define non-editable fields (e.g. current user)

  3. how to differentiate per-column access level (e.g. specific fields are not editable by anybody except by admin)

Thank you,
Serge

Environment

None

Observations

None

Activity

Show:
Adrien Ragot (Old account)
April 20, 2018, 10:31 AM

Hi Serguei,

Thank you very much for your evaluation. Unfortunately, the answer for each of your 3 questions is negative:

  1. Concerning the timestamp, you would have to edit the column in the database itself, because it's not possible through Play SQL. You would, in that case, be able to set the field as TIMESTAMP and with a default value, which would be supported by Play SQL, but users would only be able to insert dates with "midnight" for the time.

  2. We don't have column-level permissions.

Sorry for this disappointing answer.

Best regards,
Adrien

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Serguei Vinokour

Labels

None

Participants

None

Priority

Matter of months