About johnmcavoy

johnmcavoy · 02-02-2022

Hi there,I have a situation where I do not want to be able to delete an entry without a condition being met within the row. For example one of my rows has a field of 'absent' or 'present'. Regardless of user permissions I do not want to be able to de...

johnmcavoy · 12-17-2021

Hi there, I have a table I have populated with values from a reference table which looks as follows. The values are derived from the reference table using enumlist and so create a comma seperated value but in the same cell. table 1 name values custom...

johnmcavoy · 12-16-2021

Hi there, Im really struggling with this if anyone can help please. I want to create the following. data source car catalogue car make car model engine size vw golf 1.2 vw golf 1.6 vw polo 1 vw polo 1.2 main dealer inventory location dealer car make ...

johnmcavoy · 12-06-2021

Hi there, I’m still finding my way with Appsheet but really keen to get webhooks working. I wish to connect to a remote https site and launch an action however I’m getting what I can only assume are certificate errors. Is it possible to configure App...

johnmcavoy · 02-02-2022

So I want the order of operations to be as follows.1. Create record fill in fields, one of the fields is to select 'absent' or 'present'.2. If set to present then do not allow the record to be deleted until the record has been amended to absent. This...

johnmcavoy · 12-17-2021

You’re a legend! That’s done the trick. Thank you so much Cheers John

johnmcavoy · 12-17-2021

yes that’s pretty much what I want to do. I want to populate table 2 using the references as follows. Customer A or Customer B Then I want to select only the fruit that each customer has previously selected so that I can do further data work. Custome...

johnmcavoy · 12-17-2021

Thanks Marc, I’ll take a look at that, although it does look complex. Out of interest, is there an easy manual way that when a user is filling in the form for table 2 that they can select the customer number and then the fruit manually? This way forw...

johnmcavoy · 12-17-2021

Thanks for the response, I’ll give that a try. I have one other question I think should be really easy but Im struggling to work out how to do it (again noob - sorry). I have read lots of help notes on this subject but not managed to either make them...

My Stats

johnmcavoy's Bio

Badges johnmcavoy Earned

Recent Activity

Conditional deletion

Select data from single cell with multiple values

How to reference different tables

Webhook self signed certificate

Re: Conditional deletion

Re: Select data from single cell with multiple values

Re: Select data from single cell with multiple values

Re: Select data from single cell with multiple values

Re: How to reference different tables