hi, i have created an action button at the end of my order cycle to send an sms(external) to the customer.
how do i pre-populate this message with certain info. like invoice no. date etcโฆwhich are my column headersโฆi want this to pick the data from that particular row from which i am clicking on the action button.
Can anyone help me in this regard.
Solved! Go to Solution.
You can do that likeโฆ
AND(
IN(USEREMAIL(),LIST(โemail1@gmail.comโ,โemail2@gmail.comโ)),
[status]=โdispatchedโ
)
You can read the data from that record just with the [ColumnName] in โMessageโ option. If you need more than just a columnโs value, you can combine them like "Hi, this is the invoice date "&[InvoiceCreated]
hi,
also i am not getting multiple columns value in the message when i put info like below,
โHi, your Order forโ &[Party] โhas been dispatched vide Bill No.โ &[Bill No.] โTruck noโ &[Truck No.] โdriver phone noโ &[Driver Phone]
i am able to see the variable of only the last info. that is [drive phone], none of the other variables are automatically inserted.
can i limit an action to appear only to certain users
Your expression is missing some &
characters. There should be an &
between every quoted value and column reference. So this:
โHi, your Order forโ &[Party] โhas been dispatched vide Bill No.โ &[Bill No.] โTruck noโ &[Truck No.] โdriver phone noโ &[Driver Phone]
should be this:
โHi, your Order forโ &[Party] &โhas been dispatched vide Bill No.โ &[Bill No.] &โTruck noโ &[Truck No.] &โdriver phone noโ &[Driver Phone]
You could instead use CONCATENATE() to get the same result:
CONCATENATE(
โHi, your Order forโ,
[Party],
โhas been dispatched vide Bill No.โ,
[Bill No.],
โTruck noโ,
[Truck No.],
โdriver phone noโ,
[Driver Phone]
)
also can you help me how i can make this action button visible to only a select few user (s)
You can use something like IN(USEREMAIL(),LIST(โemail1@gmail.comโ,"email2@gmail.com")) with your actionโs condition rule.
In action condition I already have stated it like to show when [status]=dispatched โฆso how can I marry this rule with the one which u shared earlier
You can do that likeโฆ
AND(
IN(USEREMAIL(),LIST(โemail1@gmail.comโ,โemail2@gmail.comโ)),
[status]=โdispatchedโ
)
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |