As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Client Version 1.12.0+r12-released-10381
Client Component Version 0.7.3+19364bd
Server Version 12.10.1.1-379
Shared Components Version 1.12.0+.d5cbc42
Application Template 7657

As I do not believe we requested to be added to our environment.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

------------------------------
Regards, Guillermo

Original Message:
Sent: 08-22-2022 05:16
From: Claire Finch
Subject: Editable Table within a Report

Hi - @Guillermo Cuadrado

This is fantastic - I do love a screenshot makes so much easier to understand.

When I create the report do I do this as I'd normally do then pull the field names from the editable table or is  there a different way of creating the report

thanks
Original Message:
Sent: 08-22-2022 05:09
From: Guillermo Cuadrado
Subject: Editable Table within a Report

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

​

------------------------------
Regards, Guillermo

Original Message:
Sent: 08-19-2022 05:30
From: Claire Finch
Subject: Editable Table within a Report

Hi - was wondering if anyone can help.

I'm trying to put together a Business Application forecast for 2023 that our users can also input into currently I have written the following:

Which is showing the applications with a 2022 Run rate, an uplift then the projected forecast for 2023.
What I'd really like is for our users to then go into this report and we have a yes/no to keeping for next year and then if they know of any additional spend (licence increases etc) to be able to put that in.

Firstly is this possible ?
Secondly I think I could do this in an editable table, but our users do not have admin rights, so how would they access it.

thanks in advance :-)​

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.

Yes, @Claire Finch: just take them from the Editable Tables section in the explorer, just as you would with a regular table/report:

​

As @Tony Wong suggested, it is pretty straightforward, @Claire Finch:

1) Create a basic table with the "fixed" columns (the ones users cannot change)

2) Create an editable table as an Enriched Table:

3) ​Tell CT that you want it to have the static table as the Source Data Set, pick a Primary Key Column and specify the columns you need:

4) In the Configure Columns step, create new columns for the items you need users to enter values for.
Based on your post, I created Keep Next Budget Cycle and Additional Spend (both alphanumeric):

5) You can then create a report with an Editable Table component:

Once users enter values in either column, the Save button will be live, and CT will store the values. To get them to PRD, they'll have to click on the Publish button (I haven't tested that bit).

You'll need to investigate the permissions, as pointed out by @Tony Wong-I haven't checked that bit.

I hope this helps.