Random selection on csv file

1

Hi All,
I’m from Colorado and am new to both Kintone and this site. Does anyone have a script to randomly search a csv file? We have a csv file of therapists and we want to return 10 matches for people of the Marshal fire but the current view only gives us a choice of ASC or DESC?

Thanks for your help,

John

2

Hello @John_Hixson ,

Thank you for posting your question on our Kintone Developer Forum.

It sounds like you want to create a searchable database using your CSV files.
If so, Kintone is a great platform! You can simply import your CSV files to generate a fully-featured web database.

Creating a Kintone App

For a step-by-step guide, see the Creating an App from a CSV File help doc.

:zap: Notes on Formatting Data in a CSV File

  • You can use CSV files with the maximum sizes of 100 MB, 100 columns, and 100,000 rows, to create a Kintone App.

Searching within a Kintone App

Here is a guide on how you can search through the Kintone App:
Searching in App

Building a React Search Bar

If you are interested in building a custom search bar to fit your exact needs, check out our Build a React Search Bar that Queries a Database! content:

Native Kintone Plug-ins

We also provide Kintone Plug-ins for those who do not want to build out their own customizations.

Here are two search-related plug-ins that you might find helpful:

Plug-in Name Partial Field Search Simple Text Search
Plug-in Feature Perform partial word search on specific fields. Search targeted fields and show the result in the Record List view
Download Link partial-field-search Form simple-text-search Form

Need more help?

To better help you out, please provide more information such as:

  • What is your current situation? (Error messages?)
  • What is your desired outcome?
  • What have you tried so far?
3

Thank you Genji for your help.