Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
7003 Lượt xem

Hello, What is the exact syntax to create dynamic fields in a Google Doc text document. I would like to merge Company name, address and if possible contact name + some additional fixed text into a google doc template. Thanks

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

The standard way to do that is to first export some records, with the fields that concern you, to a CSV file, and then import that file into a gDocs spreadsheet. Row 1 of the new sheet will have the exact column titles you want for importing into OpenERP.

Then:

  1. Delete from rows 2 to the end
  2. Put in the fresh data as new rows
  3. Download as CSV
  4. Import back into OpenERP.

For step #2, I typically put the function; QUERY(data, query, headers), in cell A2 and have it pull in data from another sheet.

Ảnh đại diện
Huỷ bỏ

He's asking a different thing: He's trying to merge data from odoo to a google doc. There should be a syntax to replace variable: something like %(name)s inside the document. This syntax works in the title, but not inside the document's body. I could not find the answer yet.

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 3 15
8584
0
thg 3 15
5159
1
thg 3 15
9609
2
thg 8 24
1881
3
thg 3 24
5149