Hi. My app has 5 slice views and 1 view dire...

(Tim Meske) #1


My app has 5 slice views and 1 view direct from the excel spreadsheet data.

Note that all of the slices point to the same excel spreadsheet for data.

-The slice views allow me to set the Update Mode… Updates, Adds, Deletes, Read-Only.

This is great.

-Currently the one non-slice view allows the user to add records but I don’t want the user to be able to add records in the non-slice view.

Question… is it possible to control the Update Mode in non-slice views?

(Tim Meske) #2

Also, considering that all the slice views point to the one dat spreadsheet view, how can I remove the spreadsheet data view from the app without breaking the slice views that pull data from the spreadsheet view?

(Aleksi Alkio) #3

If you want to use Adds in your slices, you can’t remove the Adds from the original table. If you do that, you will not have that functionality in the slice anymore. You can remove that original view because it has nothing to do with the slice views. The data for these slices is coming from the table, not from the view.

(Aleksi Alkio) #4

Remove the original view away and create an additional slice/view so you can remove the Adds away

(Tim Meske) #5

Maybe I simply need to create a new slice.

Then have the 1 of 7 views point to the new slice as data source rather than it pointing to the original table.

This way all views are slices with their own independent Access Update Mode settings.

(Tim Meske) #6

Ok just got your response.

Looks like the same idea.

Question… are apps that are designed w multiple views typically only using slices for view data?

(Tim Meske) #7

Other question… The app will be used by multiple managers within our company.

Is it possible for all managers to view all records but only be able to edit records related to their own name?

Currently each record is identified w a single manger name.

The goal is for each manager to view and edit their own records but also able to view ONLY other manager records.

(Aleksi Alkio) #8

#1 question - there is now correct answer. Sometimes they are and sometimes no slices at all #2 question - you an use Editable_If feature for that purpose.

(Tim Meske) #9

Thanks again!

(Tim Meske) #10

Editable_If… Data>Columns> My app needs all the columns to be editable by any manager providing the ‘manager name’ column matches the manager making the edits to records associated to his name.

Will you please let me know what expression would work in the Editable_If field.

(Aleksi Alkio) #11

You could type into the Editable_If like [EmailColumn]=USEREMAIL()

(Tim Meske) #12

@Aleksi_Alkio Thanks! Translate

(Tim Meske) #13

@Aleksi_Alkio Thanks.

Seems to me that deleting the original table Data>Table>delete

will create a problem for the slice because when I examine the slices via the editor ea slice states that Its data is the original table.

I’ll send screen shoots next…

(Tim Meske) #14

Original table named hook rate development with its source as hook rate development.xlsx

(Tim Meske) #15

Slice named WIP Slice with data from hook rate development

(Aleksi Alkio) #16

What access option you have in your slice, those you can use in your slice. If the delete is not chosen, you can’t use it in the slice.

(Tim Meske) #17

I would think that if the slice was getting info from the spreadsheet then the slice data would be hook rate development.xlsx.

I’m concerned about deleting the original view because the slice doesn’t say its data is from the .xlsx Hope my concern makes sense and that I need to understand more before I delete the original table from the app.


(Tim Meske) #18

Not sure I understand your response just yet… the delete I’m referring to is not the access delete but rather the delete button in the table editor…

(Aleksi Alkio) #19

When you have created the app, it will create table(s) into your app. That table is then the source for your views. It doesn’t matter what views you delete, the table is still in your app. You can delete what ever view you want, but don’t delete the table(s).

(Tim Meske) #20

Ok that makes sense.

I didn’t and won’t delete any tables listed in the editor.

Still have a question… 6 of my 7 views use slices for data source.

I am able to set the Access Update Mode within the slice settings.

My problem is that 1 of my 7 views uses hook rate development table, not a slice, as data source which is apparently the table originally created by appsheet.

If I turn off ‘Adds’ in this table then appsheet won’t allow the slices to have ‘Adds’ turned on because the slices data comes from the original table.

Ultimately I want views driven by slices to have ‘Adds’ turned on but I also want the one view driven by the original table to have ‘Adds’ turned off.

Seems like a catch 22. Hope this makes sense.