Read data from uploaded CSV into existing log or sheet
Hello, I am needing to allow employees to upload a CSV file into a form/app. Once the form is submitted, I need the uploaded CSV file to be read and written to an existing log or sheet. I figured out how to get the CSV to write to ZOHO Sheets/Docs while using forms, but it saves each of the CSV files to a separate sheet, while I need one to be appended with each new submission. I have also tried to figure this out with using deluge scripts in Creator, but have had no luck. I don't have a preference
Some basics questions about zoho Creators
Hello to all, I am new here and i have a lot of questions but first at all i will start with some. I need to create an app (website) call it in any ways but i need to do something in particular. The app need to record same entry like name, surname ect, but i need that particular app (website) be used but 100 user (moderators) at the same time. So maybe the 100 users at the same time will add information (new entry, registration), and only one Admin. Is that possible this zoho creators? Thanks a
Display multiple images and ask for feedback based on these
Hi all, I have a project where we collect photos of a particular property and these photos are saved in Zoho Creator. After photos are uploaded a user needs to give feedback on the property based on these photos. For instance, there might be a form asking; Does living room require refurbishment Yes/No Does bathroom room require refurbishment Yes/No Does bedroom room require refurbishment Yes/No The user who is going give the feedback should be able to see the photos
Incomplete translation of the mobile app (Zoho Creator Portal)
Hello Everyone, i have the following problem. I have set the language to German. Now everything is translated as it should besides the system aprroval pages in the Zoho Creator Portal mobile app. This only occurs in the mobile app (iOS and android). The Web-App is translated fine. Also i haven't found an option to manually translate these as i can for my created forms,reports and pages. Thanks in advance! Jan
Could not publish application to client
Hello Everyone We have some problem with publishing our app to another client. We want to create test app to communicate with out system and after that publish it in Zoho marketplace. But first of all we want just test it. When I click "Publish" in Publish to Client I get "Could not publish application to client". What does it mean? We will be very pleased to get some help. Thanks in advance
Make a field mandatory only if it is visible?
In some instances a field will only be shown if it is required. Is it possible to set it as mandatory only if it is made visible? Can the mandatory attribute be scripted?
How to create a machine usage report based on date interval records
We have records of usage of a tractor like: Tractor Initial Date Final Date Farm A jan-1 -2019 jan-15-2019 Sun Valley A jan-16-2019 jan-31-2019 Green Lake B jan -10-2019 Jan-20-2019 Green Lake B Jan-21-2019 Jan-31-2019 Sun Valley C Jan-30-2019 Feb-10-2019 Sun Valley And would like to create a report like: Date Tractor in Use Jan/1 1 Jan/2 1 Jan/3
How to disable some values of radiobutton ?
I have 2 radio buttons (RB). 1 contains : HN and SG. Other contains : 1, 2, 3, 4, 5. If RB1's value is SG. Then in RB2, u can choose only 3,4,5. U can't choose value 1,2 unless RB1's values is HN. Can anyone help me solve this problem ?
Customer Mobile Portal
Hi, I'm testing Zoho Creator to build apps for my business with a trial account. I'm trying to give access to a test customer to the mobile version of the app we are developing but I can't find how. Zoho Mobile Creator is for company users (and it works fine), not for customers, right? If I open from a mobile browser xxxxxxxx.zohocreatorportal.eu the pages are from the desktop version of the site, not the mobile one. Mobile version of the site xxxxxxxx.zohocreatorportal.eu has another url? Thanks
Customer portal, one user enters data for another user, possible?
Hello, I created a customer portal with 2 user permissions, player and host. The player has a username and plays a game. The host will enter the username of the player and add a score. The host should be able to see all records of all players. I would like the player to be able to see only the data that the host entered that matches this player's username. Is that possible? Thank you
Zoho Creator IOS 5.12 app broke our app
FYI. Any iPhone that we upgraded to Zoho Creator 5.12 over the last few days has stopped working with our app. We can see records in a report list as normal, but when we try to edit or create an new record - none of the fields are showing in the form. Is there a way to rollback to an earlier version? Googling that next.
Display Nested Subform values in Record Template
Hi, having a really hard time with this. In Parent form is a subform with most fields hidden, and a decision box. Clicking the decision box invokes OpenURL to display the full subform and allow the user to create/edit each row of the subform and interact with a nested subform within the subform. The issue I'm having, is displaying values from the nested subform in a record template. Any ideas for displaying subforms within subforms on a record template? Thanks! Levi
JSON from exported views starts with parenthesis but does not close
Hi all, I have a problem consuming my exported views because JSON data starts with a parenthesis but does not close and causes "SyntaxError: missing ) in parenthetical". My following URL: https://creatorexport.zoho.com/showJson.do?fileType=json&sharedBy=f1ps3online&appLinkName=campeonato&viewLinkName=ANUNCIOS_Json&privatelink=vfWCWZSbg48jYC4495dkZWjKqN2Pp3zyyuenyZ56KdFA6QPfExM5aJB9h1HF52vedz4ZmC70bxr1WRqGpwGG7WWNMW7m8nKCS7AD&callback=? Returns: ({ "ANUNCIOS": [{ "ANCHO": "", "SECCION":
Is it possible to search the custom filter list or use a dropdown box to select an item from the list?
We are going to add at least 30-40 items into our custom filter list and it would be really very helpful to the end user to be able to search inside the list and also be able to select an item based on the partially entered search string results. As a second solution the user could also select their list from a dropdown list of the filter items. Are these type of custom filter options possible to perform on Creator?
Creating Panel dynamically on a Page
Hello, i am fairly new to Zoho and as a POC i was wondering if there is a way to add a panel dynamically on a Page. For example like in "Cliq", message types at the bottom creates an entry right above it without a page refresh. I can imagine this being a function that has the custom ZML snippet formatted. Function can get input parameters as the data that has to go in the panel. when called, function could add the panel on page. Not sure if it is possible ? if not, any other way (hack) to acheive
Set default font size for rich text
Is there a way to set the default font size for the rich text field? I would like to set it to 14 instead of 10, but still allow people to change it if they choose. The real reason I want to change this is because the text is being used in a record template to save a PDF of the record. When saving the PDF, I've noticed that the rich text fields are coming up with small font. Hopefully changing the font size for the rich text field to 14 will keep it 14 when it gets plugged into the PDF. If there
User permissions and "Invalid entries found"
Dear friends, there's a message coming when editing a form "Invalid entries found. Please correct and submit again." This happens only when I change one field permission not to be visible (only one specific field), under user permissions-> more-> field permissions. It's a field which I don't want this user to be able to see. Any ideas how to solve this matter?
How to update a filed in form A based on a dropdown field in form B??
I have 2 forms. Form Schedule has some a drop down field called Status. The choices in the dropdown are Maintenance, Restoration and Survey. Form Airstrip Profile has a field called Ops Status. I would like this Ops Status to be updated from Form Schedule. Data in Airstrip Profile is usually entered first. I have a lookup field in Form Schedule that looks up Airstrip Name. The rest of the data is entered. Ops Status is one of those fields. I would like Ops Status field in Airstrip Profile to be
Can we send some data to our Application
Hello everyone We want to send some data with additional information from our server to application form. In future we want simply allow our customers to install our application from marketplace and receive some data from our project (server). Initiation request for adding extra data always come from our server Logic schema: 1. First request after install our app (e.g. from form): Client's App --> Our server with extra data 2. Requests with inserting additional information: Our Server with extra
Workflow Deluge Script not working in subforms
Hello, I've set up filters for my database for lookup fields so that users logged into the customer portal can only see records that are associated with them. I've also had to add some Deluge Script to allow for administrators logged in to be able to see all of the records. This has worked fine when directly accessing forms - all of the records populate the lookup fields appropriately. However, when looking at these as sub-forms, I (as an administrator) can no longer see all of the records populating
Deluge. Count number of instances in list (or map)
Example: Have put the following in a list: Name Department John A Dave C Mary A Jane C Pete B Oscar A Want to list the count for each Department (and put it into a list or map) like: Department Count A 3 B 1 C 2 Have tried with combinations of Count() and Size() and distinct(), but not find a way around this. Great if someone have examples. Thanks, Larry
Report Filtering using a Lookup ID
Hi team, I'm trying to create a link to a report (filtering by the an lookup). The field in question is Estimate which is contained within the Estimate Inventory form. I have gone through and followed the steps outlined in the tips and tricks but to no avail :( https://help.zoho.com/portal/community/topic/tip-02-how-to-dynamically-filter-reports-using-url-parameters-22-3-2018 Panel - Action The page passes through the identifier without a problem, however the report will not filter. https://app.zohocreator.com/<company>/estimator/#Report:Estimate_Inventory?Estimate.ID=3724905000000045059
This function only returns one value to all records
Hi, I built this function to update a field in form with the text name of the lookup field in that same form. This works... except that for every record, it is updating the same lookup field name to all fields, instead of the correct lookup field for that record. So instead of getting the correct Single Workout Name for each record, I get the same one for ALL records. I am missing a part of the code that pulls from the same record and update that same record. I am not sure what I am missing.
File Downloader Tool for Mac
Hi everyone, I'm having trouble figuring out how to download files to desktop from 'file upload' or 'image' fields in forms. I assumed this would be an automatic option? Are there settings I must adjust first? I'm using a custom app in Creator. I found this page with a link to install a 'file downloader tool' but it is only compatible with Windows and I'm using a Mac, and can't seem to find a mac version anywhere... Filedownloader tool https://www.zoho.com/creator/help/fields/uploading-files-and-images.html#download_file
System wide app failure
Has anybody else's app stopped working? I've had an app running fine for the last year. Now all of a sudden I get errors popup all over the place since yesterday. Still waiting on Zoho creator support team to respond. From experience it is something on their end rather than code that decided to re-write itself overnight.
Record Template editing is glitchy
I've created several PDF templates for records in Zoho Creator, and every time I do I find that the editor is always glitchy, mostly when it comes to text and background colour changes. Sometimes if I save, close and re-open what I'm working on, I can get the editor to start working so I can change font properties. This happens a lot. But, one thing that never works for me is changing a heading colour to white (I wanted to have some headings with a dark background colour and then white text).
Populate a subform field with data from a different app
Hi, I have two apps, App A and App B. In App A I have a lookup field in a subform that looks up records in App B, I want to be able to populate another field in the subform based on what the user selects in the lookup field. I understand that this is possible using a custom function that collects the data and places it in a map, I can then call the function and using the ID of the lookup field use the map to return the variables. I've got so far and have managed to create the function in App B....
Sheety Subform Values
We are currently integrating our form with "sheet" to collect the data. The Sheet is collecting all of the form values but the values from the "subform" are not showing up in the "sheet" ...Nor is the section Is this possible? I found an article where it was suggested that I create a form for the elements of the subform. Then when I use the custom subform add....it will ask me to choose - "blank"-new subform - or existing... I do not get this existing option. The structure is: Number of Attendees
Pulling records from another app with notifications
Hello, Can someone please give me some direction on this. I have an app called Receipts that user's submit vehicle receipts to. It includes maintenance, fuel, etc. with the current mileage. I want to set it up so that the last person to submit a fuel or oil receipt for a vehicle, becomes the "owner" for that vehicle. Also the current mileage should be stored on the first oil change, called initial_oil. When the current mileage for that vehicle = initial_oil + 4500 I would like to send a notification
How can I set a Date and Time Field to blank using Deluge Script?
I am creating an application where I calculate and fill a Date and Time field. However, if the user takes some action I want to be able to set the Date and Time field to blank or null using Deluge Script. Is this possible? Thanks.
Store PDF(Binary file) in Form File Field.
Hi guys, I need to store API response in the Form File field and I'm getting API response in PDF(Binary file) format. How to achieve this in Deluge script? For Example: API response will be in JSON format like below: { "ConversionCost": 4, "Files": [{ "FileName": "www_google_com.pdf", "FileSize": 68342, "FileData": "JVBERi0xLjQKJdPr6eEKMSAwIG9iago8PC9DcmVhdG9yIChDaHJvbWl1bSkKL1Byb2R1Y2VyIChDb252ZXJ0QXBpICApCi9DcmVhdGlvbkRhdGUgKEQ6MjAxODA4MTMxMDUyMTMrMDAnMDAnKQovTW9kRGF0ZSAoRDoyMDE4MDgxMzEwNTIxMyswMCcwMCcpPj4KZW5kb2JqCjIgMCBvYmoKPDwvVHlwZSAvWE9iamVjdAovU3VidHlwZSAvSW1hZ2UKL1dpZHRoIDI3MgovSGVpZ2h0IDkyCi9Db2xvclNwYWNlIC9EZXZpY2VSR0IKL1NNYXNrIDMgMCBSCi9CaXRzUGVyQ29tcG9uZW50IDgKL0ZpbHRlciAvRmxhdGVEZWNvZGUKL0xlbmd0aCA3NDYxPj4gc3RyZWFtCnic7V1bbxvJlSYsWZPJ78jTDDAZmxdfxpPu6m4xNmA/LfR7KKibpDyDLJC87T9Y+GmRXSSxLjMLDJCn/ILdhwE2MxYvcizxIlkXoPd8p5pSSyarqi+ULKUPCgQtk93Fqv7q3M8plfIhq30ommPRHPEYPlt9awdjtzV0m0OnNXboNRjx+xH9022N7ebQXg1FMKT/wmswtBqDnOZSUEEfKVnrY4KAHYxEMLLbh06AfxJkHINh+wPAp0mYGtmrA+EPcZ3mePnb8Lp/VkEF5UxOc0B8wW4O7JcHxC8s3wgjM4c/kGCpfxvaPtD3dTC67p9Y0BVR5d"
Sub-form items in detail view - ability to edit
Hello, I'm trying to limit the number of menu items by having (mostly) only forms on the database menu. My main profile form has a number of sub-forms (hidden in the main profile because I don't like the horizontal fields and lack of control). I've set it up so that when a user is looking at the report for all of the main profile records, clicking on one brings up the "detailed view" which includes the sub-fields with related records listed. Clicking on one of these related records brings up
Scheduled emails from creator
I know that I can schedule emails from creator based on date but how can I check other fields first. Example before I send an auto email based on a field date I also want to check a field to see if the customer opted out etc. I know I could do the in crm but creator offers me the facility to have life formula updates.
Single Column / Double Column? I need complete control where I place fields please.
I'm trying to convince a company to invest in Zoho Creator but their main complaint is that form layouts are too primitive. I'm learning how to use the form builder and can only see 2 choices. Single and double column layouts. I can't place the fields freely on the form. I'm sure they will invest in Zoho if I can show them a nice looking data entry form. I don't know HTML but I do know it can do nice looking field placements. The builder is supposed to let me place fields freely. I need to do something
Any way to integrate zoho form to wordpress form
Hi, Right now what I am doing is getting a form submission through my wordpress site and importing it here to my zoho form. And once it gets populated we do our other actions. I wanted to check if there is any way where i can directly populate this zoho form with data through my wordpress ninja form data every time a user submits this form?? how to link my zoho form ro this wordpress ninja form? This will reduce our import task daily. Thanks, Pooja
Pivot Table to Count Tasks in Related Form
Hi- We have Form 1 to collect the names of employees. Form 2 uses a lookup to Employee Name in Form 1 to assign a task to employees, with the ability to mark the task closed when completed Is there any way to create a pivot table that would provide a count of the number of open tasks per employee. I don't think I can build the table off of Form 2 only because there are some employees from Form 1 who do not have any tasks....they have no data in Form 2 so they would not show up. Basically, want
Add an icon field
Hi ZC team! It would be really great to see a icon field make its way to ZC with the ability to assign each icons to functions when clicking the icon. Currently, you can add custom action buttons to rows, but they take a lot of vertical spacing, can't be customized and in general, icons are preferable in terms of good UI design. I'm attaching an image of what I was able to do with a rich text field and some <i> tags pointing to urls. This allows for opening a comment module, an audit trail module
Displaying Length Of A String Field
I am displaying the length of a string field by creating a Notes field like this: <div style="text-align: right"><span style="color: rgb(153, 153, 153)"><font size="2">0/30</font></span></div> and using an On User Input script like this which truncates the field to a particular length or displays the updated length in the Notes field: if(input.Headline_1.length() > 30) { input.Headline_1 = input.Headline_1.mid(0,30); } else { input.Headline_1_Char_Count = "<div style=\"text-align: right;\"><span
Can I build Accounting & ERP system by Creator ?
Does Creator has the capability to build ERP system if task done by experienced developer ?
Conditional filter based on user role
I have a look-up field which connects to our main family profile records. We have instructors that teach families, and each instructor has their own login via a customer portal. I've set up a filter on the look-up field so that the only family names that come up are the ones that are taught by the instructor that is logged in (so that they have access to only the names of the families that they teach). The issue is that if one of our administrators wants to add a record, the filter does not allow
Next Page