Bulk `Link` creation [Jun 07]

Discord-Discussions
21

:man_technologist: pranavxc replied

image0
image0646×546 22.5 KB

image1
image1602×910 34.1 KB

22

:raising_hand_man: WM31 replied

Ok that’s helpful

23

:raising_hand_man: WM31 replied

And from the API doc this request is a post, will try myself

24

:raising_hand_man: WM31 replied

But after adding this relation this will be shown in the table view as a column?

25

:man_technologist: pranavxc replied

If relation is not created yet , you have to create it first

26

:man_technologist: pranavxc replied

image0

27

:raising_hand_man: WM31 replied

Ok create the relation first then execute the one to one API call

28

:man_technologist: pranavxc replied

yes

29

:raising_hand_man: WM31 replied

One of topic question, will there be a one click solution to convert excel date to Date value for DB? Or this will be a new feature?

30

:man_technologist: pranavxc replied

in the api you have to replace the {columnName} with alias you had used while creating LinkToAnotherRecord column

31

:man_technologist: pranavxc replied

In excel import ?

32

:raising_hand_man: WM31 replied

O

33

:raising_hand_man: WM31 replied

I converted that to CSV, so that it becomes a value

34

:raising_hand_man: WM31 replied

I know I can convert that to text before export, but if there is an easier way, the better

35

:man_technologist: pranavxc replied

you can try to import excel file itself

36

:raising_hand_man: WM31 replied

This means excel import module can handle this, ok will try next time

37

:raising_hand_man: WM31 replied

I just exported it to can to ensure there are no formula and generated values

38

:man_technologist: pranavxc replied

It will create a new table based on column types and imports the data

image0
image0691×322 25.9 KB

39

:raising_hand_man: WM31 replied

Thanks

40

:raising_hand_man: WM31 replied

For API update on date field, ISO format is accepted?