Sign in to submit new ideas and vote
Get Started

Disable/Read-only Field

Would be great if we could set certain fields to disable or read-only input fields instead of just having the option to hide them.

1
1 votes

Idea Submitted · Last Updated

Comments

  • Erin Horiuchi Green
    Erin Horiuchi Green ✭✭✭✭✭

    @optimusprime123

    Only the Smartsheet Owner and Admin Access can edit a locked field. Smartsheet Edit Access cannot edit a locked field.

    Depending on the volume of your Smartsheet Columns targeted to be Locked, it is quicker tp update either manual or API.

    I use the API since I have several Smartsheets with a large volume of Locked Columns.

    Get Smartsheet Columns and ID

    import smartsheet
    smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
    action = smartsheet_client.Sheets.get_columns(INSERT SMARTSHEET ID, )
    columns = action.data
    for col in columns:
    print(col.title)
    print(col.id)

    Update Smartsheet Columns to Locked (*Can be further updated by creating a Column List and running a loop to Lock*)

    import smartsheet
    import smartsheet.models
    smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
    column_spec = smartsheet.models.Column ({
    'locked':true
    })
    response = smartsheet_client.Sheets.update_column( INSERT SMARTSHEET ID, INSERT COLUMN ID, column_spec)
    updated_column = response.result

    Erin Horiuchi Green, MBA, LSSYB, PSMI
    Process Manager
    Syneos Health

    Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

    Core App and Project Managment Certified 🚀