Відео

If I have a key for scanning column,so I not able to auto scanning for the same barcode. And I not to duplicate scanning is there any way to resolve it to bypass.

THANK YOU!!!!!! I spent HOURS!!!! trying to get tabs in the dashboard to link to a form or detail view fi applicable and it sure was not working.. GRRRR but now its looking FLY! so awesome! What a blessing. thank you.

Very helpful, Thanks

Great tutorial🎉 simple but useful

Nice one. Please 🙏🏿🙏🏿🙏🏿🙏🏿 sir it's request to you that make a video on Stationery Shop Inventory Management and Sales Report including Profit and Loss. Automatically Adjust these things Products Purchase Inventory Sales (Daily POS) Profit and Loss These are the main key requirements for my Small Shop which I started now means a few days ago.

How to do user comparison? Without that feature the pin is useles

I had the hardest time trying to write an expression that placed a constraint on an action to only show if either of two reverse reference columns were: A) not blank, B) met another column's value criteria from the referenced table, and C) the count of the number of occurrences equalled the count of the reverse referenced column. I ended up using a pair of virtual columns to count the number of occurrences using the IFS(IN() function to determine if it met the related tables column list criteria, then the COUNT() function to count the occurrences that shared the reference ID between tables. Looking like this: IFS( IN( "Criteria", [Related TableName][CriteriaColumnName]) ,COUNT( FILTER( TableName, ([Ref] = [_THISROW].[Ref])))) Using the pair of these virtual columns to tally up individual totals, I was then able to use those values in the behavior of the action constraint using this expression: OR( IFS( [VCcolumn1]>0,[VCcolumn1]= COUNT([Related TableName1])), IFS( [VCColumn2]>0,[VCColumn2]= COUNT([Related TableName2])) ) What a pain😂 If you have any other solution less painful I'd love to hear it. "CriteriaColumnName" is an Enum type dropdown column and I'm also using the AppSheet native database not Google Sheets if that helps.

I did the same but it made a select all buton plus select all in each row. So I have dozens of "select all" buttons. DOn't know why

great rich , that is great , i have an esue how can i deal with the changing of price of product without crupted old data with the old price ?

Three years later, this is a much more straight-forward lesson than that provided by Google. Thanks

This is extremely helpful as I am new to working with AppSheet (and have no coding experience). What would you set a Type to in Log, when the Type in the Main table is Enumlist? Or would you change the formula in the action instead? I am getting the "cannot compare text to list" error message.

it shows an ERROR on parsing

thanks for the idea but how do you activate an action once all the lines have been selected? The edit/delete buttons, etc. disappear in this view.... Can you help me?

Thank you

If you want to use the Enumlist in the filter. make sure the filter data set has an auto compute to your enumlist in the Suggested values

Many thanks for the tutorial 👍

Very helpful thank you!!

Thanks. This solved my problem.

my question is how can you let the Pin1 reappear if I want to change the value of all pins, like if I change my mind?

hey, looks like the template app have an error

Is there any formula for remember last value(text) in a text box remain same text after submit until we edit that again

Great video. thanks

Great video. I wondering how to apply this to a ticket scanning app at an event. Tickets have a QR code, scan using app and update a “ticket used y/n” field to yes. Guess i need to just have a scan field and match it to the ticket ID, then set an action to update the used field??

@appify How to show child records when user clicks on button in detailed view or dashboard view

great lesson from thailand

Wonderful tip but I have problem on iPhone Showing some character.

Hello! I don't normally comment on videos. But I've watched a lot of yours to get started on Appsheet and they've been really helpful. So, a small token in return for you... When you create a virtual show column, if you let the App formula (ie the "") propagate so you get the green tick below, then you get all the virtual column options displaying. That means you can select Show as the type without having to go back into the table and edit it. Hope that helps you!

how to delete duplicate colum i made two colum _RowNumber _RowNumber1 how to delete one

You have my respect! thank you very much😃

Community plugin error for using data links There is an error caused by a community plugin for using data links. Please report the issue to the plugin provider if the issue persists. Community plugin details for using data links Fetching data from AppSheet failed. Error code: 6880b88e Help me please

How do you manage if there are 2 or more concurrent users in the app ? expression would return all the users same max() +1 value.

Great content from South Africa 🇿🇦

Great tutorial! How can I add the images route if already have a folder with subfolders? Could I edit directly in Google sheets?

If a customer would want to buy more than one thing in an invoice how could this be made possible?

Thank you very much brother

Hello. First of all, congratulations on your videos. They are very useful to me. I have a question about the linkapp. Is there any way for the link to go to the specific view in the app?

This is by far the best explanation and example I've found. Thank you very much!

Good explaination of how to setup a Slice. But how is it applied? Do we create a new view for it? Does it move the slice data to a different/new table? How do we access the sliced data, if we want to use it for other purposes...such as export it to another datasheet?

In order to have different filters for different users, I have added the UserEmail to filter table and using lookup in the filter form but this doesn't seem to be working, I think the updates are too slow. Has anyone any other ideas how this can be achieved. UPDATE : I have put the filter columns on the table that lists the users and lookup from there which works.

Hello, thank you for the video. I tried to use it in user settings to use a password but then we fill all the pins the numbers disappear so if the pwd is wrong the numbers disappear and cannot be entered again, any suggestion?

Excellent function, thanks, it took me a bit to get it to work, but I did it, I had to change some of the code

Sir.. this just made my day! could you please write a code for a list from a filtered table?

Awesome

sir not working for me. while click the button it showing blank page.

Thanks, would you like to connect with me ?

What's the benefit of doing this instead of creating a separate table to represent the association?

Relative reference list items not appearing in pdf

Can i save data to google sheet? If yes ...how?

I need to build an app for 3 stores to be able to write procurement orders simultaneously, from the same catalog, but divided into different invoices, any ideas ?, I basically need to add the items from the catalog to the total invoice directly from the appsheet, right now I'm using a filter function on googlesheets to filter the values that has input a Qty, but i know there's a "add a new row to another table" in appsheet

Hi, thanks for the informative video. I am updating that Main row, it shows the history inline but it only shows what i updated it to, it doesn't show the prior information? Also, it seems to create only one row for that item instead of multiple so it just updates that singular row