Skip to content

Matndagi O'zgaruvchilar

Ushbu yordam maqolasi hujjat shablonlariga taalluqli emas. Hujjat shablonlarida o'zgaruvchilardan qanday foydalanishni bu yerda o'qing.

Navigatsiya

O'zgaruvchilar raqam, matn yoki boshqa ma'lumot turini saqlaydi. O'zgaruvchilar quyida ishlatiladi:

  • Vazifa nomi (vazifa shablonida yoki vazifa yaratishda)
  • Vazifa tavsifi (vazifa shablonida yoki vazifa yaratishda)
  • Email shablonlari
  • Ssenariy harakatlari, tugmalar, kiruvchi webhooklar, email qoidalari vazifalar uchun:
    • HTTP so'rov yuborish
    • SMS yuborish
    • WhatsAppga yozish
    • Instagramga yozish
  • Ko'pdan-bir amallar, ssenariylar, tugmalar, kiruvchi webhooklar, email qoidalari vazifalar uchun:
    • Nomi o'zgartirish
    • Tavsifni o'zgartirish
    • Izoh qo'shish
    • Maydon qiymatini o'rnatish (""Matn"" maydonlari uchun)


Matnga, masalan vazifa tavsifiga, o'zgaruvchi qo'shish uchun "turli o'zgaruvchilar" havolasini (1) bosing, o'zgaruvchini yarating va istalgan maydon matniga vazifa shablonida qo'shing (2):

vBmUi1.jpg

Hisoblanadigan maydonlar bilan hisoblashlar

Ba'zan matnga o'zgaruvchi qiymatini qo'yish yetarli bo'lmaydi — o'zgaruvchilardagi qiymatlar bilan hisoblashlar yoki olingan satrni qayta ishlash kerak bo'ladi. Bunday amallar uchun quyidagi sintaksisdan foydalaniladi: 

%%%FORMULA TEXT%%%

Misollar

Discounted price: %%%{{Task.Price}}*0.8%%%
Work will be completed in %%%DATEDIF(NOW(); {{Task.Completion Date}}; "d")%%% %%%MULTIPLE(DATEDIF(NOW(); {{Task.Completion Date}}; "d");"day"; "days")%%%

Muhim

  • Formulaning matni bitta satrda yozilishi kerak va satr bo'lib uzilishi mumkin emas. Ya'ni formula Enter bilan keyingi qatorda bo'la olmaydi.
  • Formuladagi o'zgaruvchilarni formatlash mumkin emas, masalan, ularni qalin yoki kursiv qilish mumkin emas.
  • Agar formuladan chiqqan natijani qalin qilish kerak bo'lsa, butun formulani natija bilan birga formatlang.

IF

O'zgaruvchi qiymatlariga (shartlarga) qarab matn qo'yish uchun quyidagi sintaksisdan foydalaning:

%%$IF(Logical formula)$%%
TEXT
%%$ENDBLOCK$%%

Misol

%%$IF({{Task.Order Amount}} > 100000)$%%
VIP CUSTOMER
%%$ENDBLOCK$%%


Natija:

VIP CUSTOMER

ELSE

ELSE faqat IF bilan birga ishlatiladi. IF dagi shart rost bo'lmaganda, blokning ELSE qismidagi matn ko'rsatiladi.

%%$IF(Logical formula)$%%
TEXT
%%$ELSE$%%
TEXT
%%$ENDBLOCK$%%

Misol

%%$IF({{Task. Invoice №}}="")$%%
The field [Invoice №] is not filled in
%%$ELSE$%%
The required task field is filled in! :)
%%$ENDBLOCK$%%


Natija:

  • Agar maydon to'ldirilmagan bo'lsa, "The field [Invoice №] is not filled in" xabari ko'rsatiladi.
  • Agar maydon to'ldirilgan bo'lsa, "The required task field is filled in! :)" xabari ko'rsatiladi.

ELSEIF

Murakkabroq shartli ifodalar yaratishda yordam beradi:

%%$IF(Logical formula)$%%
TEXT
%%$ELSEIF(Logical formula)$%%
TEXT
%%$ELSEIF(Logical formula)$%%
TEXT
%%$ELSE$%%
TEXT
%%$ENDBLOCK$%%


Eslatma

  • Oxirgi ELSE blokning ixtiyoriy qismidir.

Misol

%%$IF({{Task.Invoice Number}}="")$%%
The field [Invoice Number] is not filled in
%%$ELSEIF({{Task.UPD Number}}="")$%%
The field [UPD Number] is not filled in
%%$ELSEIF({{Task.Contract Number}}="")$%%
The field [Contract Number] is not filled in
%%$ELSE$%%
All task fields are filled in, you're awesome! :)
%%$ENDBLOCK$%%


Natija:

  • Agar uchala maydon ham to'ldirilmagan bo'lsa, faqat birinchi xabar "The field [Invoice Number] is not filled in" ko'rsatiladi, qolganlari o'tkazib yuboriladi.
  • Agar "Invoice Number" va "UPD Number" maydonlari to'ldirilgan, lekin "Contract Number" to'ldirilmagan bo'lsa, mos xabar "The field [Contract Number] is not filled in" ko'rsatiladi.

FOREACH

Agar o'zgaruvchi qiymatlar ro'yxatini ifodalayotgan bo'lsa, masalan {{Task.Subtasks}} yoki {{Task.Assignee}}, va har bir qiymat uchun ma'lumot ko'rsatish kerak bo'lsa, quyidagi sintaksisdan foydalaning:

%%$FOREACH(Variable;Delimiter)$%%
TEXT
%%$ENDBLOCK$%%


Muhim: ifodaning ushbu qismida — %%$FOREACH(Variable;Delimiter)$%% — birinchi darajali o'zgaruvchini, ya'ni {{Task.Subtasks}} yoki {{Task.Assignee}} ni ko'rsatishingiz kerak, boshqa narsa emas.

Misol

%%$FOREACH({{Task.Assignee}};"<br>")$%%{{Task.Assignee}} - {{Task.Assignee.Position}}%%$ENDBLOCK$%%


Natija:

linda Martinez - Designer
Jamse Davis - Developer
Mary Brown - CEO
%%$FOREACH({{Task.Subtasks}};"<br>")$%%{{Task.Subtasks.Number}} - {{Task.Subtasks.Name}}%%$ENDBLOCK$%%


Natija:

2119 - Rough finish
2120 - Sub-final finishing
2121 - Final touches

Shart bilan misol

Sintaksis:

%%$FOREACH(Variable;Delimiter;Condition_WITHOUT_If)$%%
TEXT
%%$ENDBLOCK$%%

%%$FOREACH({{Task.Subtasks}};"";{{Task.Subtasks."Contract Amount ($)"}}>1000))$%%
{{Task.Subtasks.Counterparty}}, contract amount {{Task.Subtasks."Contract Amount ($)"}}
%%$ENDBLOCK$%%


Natija

Butun ro'yxatdan faqat kontrakt summasi 1000 dan ortiq bo'lgan hamkorlar ko'rsatiladi:

LLC Sunrise, 1500

LLC Sunset, 1700

LLC Dawn, 2500

FOREACH blok ichida ELSE bloki

Sintaksis:

%%$FOREACH(Variable;Delimiter)$%%
TEXT
 %%$IF(Logical formula)$%%
TEXT
 %%$ENDBLOCK$%%
TEXT
%%$ENDBLOCK$%%

%%$FOREACH({{Task.Subtasks}})$%%%%$IF({{Task.Subtasks.Status}}="TKP added to calculation")$%%
{{Task.Subtasks.Counterparty}}, {{Task.Subtasks.Counterparty.TIN}}, contract amount {{Task.Subtasks."Contract Amount"}} {{Task.Subtasks.Currency.Symbol}}
%%$ENDBLOCK$%%%%$ENDBLOCK$%%


Natija:

LLC Sunrise, 5689845987654, 1500 $
LLC Sunset, 5689845125699, 1700 $
LLC Dawn, 5689845589674, 2500 $
LLC Light, 5689845235689, 500 $

TABLE

Agar o'zgaruvchi qiymatlar ro'yxatini ifodalayotgan bo'lsa va har bir qiymat uchun ma'lumotni jadval shaklida ko'rsatish kerak bo'lsa, quyidagi sintaksisdan foydalaning:

%%$TABLE(Variable)$%%
TEXT
%%$ENDBLOCK$%%

Misol

Misolda vazifaga qo'shilgan ma'lumot yorlig'idan faqat kerakli bloklarni ajratib olish va ushbu ma'lumotni mijozga jadval sifatida jo'natish ko'rsatilgan. Jadval Planfix tahrirlovchisi orqali qo'shiladi:

Order №{{Task.Number}}

%%$TABLE({{Data tag.Service}})$%%

{{Data tag.Service.Service Name}} {{Data tag.Service.Amount}}

%%$ENDBLOCK$%%

Total order amount: %%%TEXT(SUM({{Data tag.Service.Amount}});",.2f")+MULTIPLE(SUM({{Data tag.Service.Amount}}); " ruble"; " rubles")%%%


Natija:

Order №2118

Graphic design 1 600.00
Programming 3 000.00
Development of TA 300.00

Total order amount: 4 900.00 dollars

Sarlavha va jami bilan misol

Jadvalga sarlavha yoki jami qatorini qo'shish uchun sintaksisda quyidagi parametrlarni ishlating:

%%$TABLE(Variable;0;0)$%%
Table drawn using the Planfix editor
%%$ENDBLOCK$%%

Misol: %%$TABLE({{Data Tag.Service}};1;1)$%%

# Name Price
{{Data tag.Service.Record Number}} {{Data tag.Service.Service Name}} {{Data tag.Service.Amount}}
Total %%%SUM({{Data tag.Service.Amount}})%%%

%%$ENDBLOCK$%%


Natija:

# Name Price
1 Development of TA 1 000.00
2 Programming 3 705.00
3 Graphic design 1 035.00
4 Testing 690.00
Total 6430

Qizil bilan ajratilgan raqamlar jadval sarlavhasida va jami qatorida nechta satr ishlatilishini ko'rsatadi.

Masalan, yuqoridagi (1;1) raqamlari jadval boshida bittadan satr sarlavha uchun va oxirida bittadan satr jami uchun ishlatilishini anglatadi.

Jadval sarlavhasida ikki qator ishlatish uchun (2;1) kabi belgilang.

Misol: %%$TABLE({{Data tag .Service}};2;1)$%%

Set of services
# Name Price
{{Data tag.Service.Record Number}} {{Data tag.Service.Service Name}} {{Data tag.Service.Amount}}
Total %%%SUM({{Data tag.Service.Amount}})%%%

%%$ENDBLOCK$%%


Natija:

Set of services
# Name Price
1 Development of TA 1 000.00
2 Programming 3 705.00
3 Graphic design 1 035.00
4 Testing 690.00
Total 6430

Shart bilan misol

%%$TABLE(Variable;0;0;Condition_WITHOUT_If)$%%
Table drawn using the Planfix editor
%%$ENDBLOCK$%%


%%$TABLE({{Task.Subtasks}};1;0;{{Task.Subtasks.Status}}="TKP added to calculation")$%%

Counterparty TIN Contract amount
{{Task.Subtasks.Counterparty}} {{Task.Subtasks.Counterparty.TIN}} {{Task.Subtasks."Contract Amount"}}{{Task.Subtasks.Currency.Symbol}}

%%$ENDBLOCK$%%


Natija:

Counterparty TIN Contract amount
LLC Sunrise 5689845987654 1500$
LLC Sunset 5689845125699 1700$
LLC Dawn 5689845589674 2500$
LLC Light 5689845235689 500$


Jadvalga sarlavha qo'shish uchun ustiga o'ng tugma bilan bosing va Row - Insert Row Above ni tanlang:

Pvy4PR.jpg

FOREACH va TABLE infobloklari bilan

Emailni tahlil qilayotganda yoki HTTP so'roviga javob berganingizda bir nechta ma'lumot qatrlari olinadi va ularni strukturaviy matn yoki jadval ko'rinishida qo'shmoqchisiz:

%%$FOREACH({{Infoblock.!row}};Separator)$%%
{{Infoblock.!row.Infoblock name}}
%%$ENDBLOCK$%%

%%$TABLE({{Infoblock.!row}})$%%
{{Infoblock.!row.Infoblock name}}
%%$ENDBLOCK$%%


Misol

Keling, ma'lumotlarni "Product" va "Price" infobloklariga ajratib olib, ularni jadvalga qo'shamiz:

%%$TABLE({{Infoblock.!row}})$%%

{{Infoblock.!string.Product}} {{Infoblock.!string.Price}}

%%$ENDBLOCK$%%


Natija:

Pencil 1,00
Pen 2,00
Notebook 10,00


O‘tish

"http://planfix.com/uz/help/index.php?title=Matndagi_O%27zgaruvchilar&oldid=3188" dan olindi