SELECT() Expression in Appsheet | Multiple Filtering Conditions | Appsheet Expressions
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- #appsheet #fiverr #freelancing #upwork #freelancer #appsheetexpressions
In this tutorial, we gonna see about the SELECT() Expression in Appsheet with Multiple Filtering Conditions
Follow me on :
---📷 Instagram: / adithya.m.p.n
---🔣 LinkedIn: / adithyampn
---🌍Website: www.appsheetwithadithya.com
![ความรักไม่ได้น่ากลัวขนาดนั้น (TRUST ME) - LYKN [ OFFICIAL MV ]](http://i.ytimg.com/vi/9np-lAtCRpQ/mqdefault.jpg)
Hello ......... Your videos are really helpful ........ I am working on an app and took help from your videos ..... Thank you so much
mai khud 1 appsheet editor hu .or maine multiple email id se apka chanal subscribe kiya hu jaldi se apka 1000 subscriber ho jay . app hindi me video nhi bnate hai na mujhe thoda samjhne me dikat hota pr bar bar dekhta hu.
mujhe ek app esa mila hai jisame seat vailable ,area,date ke uper multi condition lga ke appointment book hona chahiye . condition to lga liya hai pr kuchh logo ko 1 ghanta lgta hai kuchh logo ko 2 ghanta lgta hai is condition me agar mai 9 bje ka appointment book kiya or us person ko meeting me 2 ghanta lagega to hamre pas location ,seat, or date ke sdhar pr 10 bje or 11 bje tak ka dropdown hide hona chahiye.
Hola y gracias por compartir tu contenido. Me gustaría saber si podrías ayudarme. Tengo una tabla de productos con distintos precios, y necesito calcular en una columna virtual el total de la venta, pero necesito seleccionar primero si la venta es de tipo mayorista, que el total se calculé en base al precio mayorista, pero si el tipo de venta es minorista, que en la fórmula total, entiendo precio x cantidad, tome el precio minorista del producto en cuestión. Sería factible realizar esta acción mediante el select?
Two videos in two days 👏👏👏
will try to post daily :)
How to Filter data by multiple conditions on the same column in app sheet , i want to filter a category column where two or more categories is there . how to give the view access to user who sales two categories in single views
in this video you put Type as key. then how to add second item into list while ID is Type. duplicate issue. and if you add an ID column extra it will affect column ref in your Valid if formula. it selecting data by column ref of ID
Can you please help me with filtering data set which is like E1234, E1235 (column type: name), unfortunately i can’t filter with any condition as the column type is not number. Is there any solution?, awaiting your valuable reply..
NICE TIP @7:00
I am facing one problem, like when I am deploying my app, it is showing error and showing me subscription plans. Is Appsheet free or not......Also I am working on a basic app then why it is charging ....... please help if possible regarding this issue .......bcz I want to test my app on mobile and it's very urgent
Without deploying also you can install the app in mobile and test
I need your help regarding data type.
My Problem is :
There is two Tables
Table A: Where Net Weight Field Data Type is Decimal
Table B: Here I am fetching Net Weight with Auto Compute
Problem: Data converting Decimal to Text
So please help for the same.
Use Decimal() function
@@appsheetwithadithya Thank you very much for the solution, I was using the same while fetching data and it was not working so I had used Decimal() in where I am utilising fetched data.
IS IT POSSIBLE TO SHOW A MESSAGE IN APP SHEET IF THERE IS 2 CONDITIONS MATCHING IN EXPRESSION?
Use show type in columns data type
@@appsheetwithadithya . yeah that is possible , but i can only possible to give one condition
example .. if i was enter a amount that exisit in the sheet i want a to show a warning message. duplicate value.. now it is working fine | in([AMOUNT],select(NAHLA BANK SLIPS[AMOUNT],[AMOUNT] = [AMOUNT])) | i gave this expression for show function , but i want to show that message only when that amount and its customer name is matching , how to gave that condition with amount
MAT SIRA Formula=? SIRA TableName:Deneme
74 ? 2
86 ? 1
45 ? 3