Creator embeded form look up fields are transparent?
I want to use a zoho creator form on my webpage but i need a way to modify it's appearance. You can see my form on my webpage below. It is in the orange footer at bottom of page named (Boat Selection). http://precisionsails.mybigcommerce.com/ I cant seem to figure out why the drop down fields are transparent. I want them to have a white background, not transparent, how can i change this? These are lookup fields in my form. Also is there something i can do to have the menu that drops down appear up
hide command not hiding fields
Hi, I have a form named stage with the following field and data: -Stage -Grapes -Fermenting -Juice -MustI have another form named Analysis that contains fields that I would like to hide in function of the stage chosen. For example, if the user chooses "Grapes", I would like to hide all fields except Brix and pH. To test my syntax, I have only been trying to hide the "Lot" field. I have used the following to try to accomplish this: if(input.Stage.toString() == "Grapes") { hide Lot; disable Lot;
Empty Records?
Everytime I go into the zoho software creator, I generate a blank record. How can this be avoided? Thanks, Mike
Problem with Bulk Edit
In some of my reports, certain users are allowed to edit or bulk edit data. The single edit part works well by bringing up a window of my original form not displaying hidden fields (action completed using the hide/show feature). However, when the user selects bulk edit, ALL fields are listed for the user to edit. I also notice that the Edit Only Visible Fields option is no longer available on the reports in new application. Is this the reason all fields are being shown on bulk edit?
Set Filter Error
Hi, I have a form called block that contains: vineyard & block fields. I also have another form called analysis which contains vineyard and block look up fields. I am trying to filter the block lookup field data based on the vineyard selected in this form. I initially got a type mismatch error when I tried to do this: I then tried using .toString() function which eliminated the error but does not show any data in the block field when I run the app. If I use an actual name in the filter-i.e. "Rotta
Form cut off time? Select next business day.
How would you change a submit date field (input.Submitted_Date = zoho.currentdate;) to select the next business day if it is after 5:00pm central?
Alphanumeric Code
I want to create a code field for my application, and it should look like P100 P101 P102 and so on... i have no idea how to do this in deluge scripting...i am just a beginner....can anyone help me in this regard?? Thanks in advance!!!
Creating if then statements in Creator
I'm working on a Daily Report in creator and want to create full automation. For example I have a drop down on work types (In office or in field). If an employee is working in the field I want the "in office" fields to zero out for hours worked. I have been able to create rules that if an employee selects "in office" as the work type then the "in field" fields are removed. However, I want the "in field" inputs to automatically go to zero if the "in office" field is chosen. Thanks in advance.
From MM-DD-YYYY to MM-DD
I have a field that is a standard date-field (no type), for birthdates. I want to have a 2nd field that shows only Month and Date (eg, Dec 22); what field type should this be?
ZOHO CRM to Zoho Creator Criteria Issues
I am able to push data from Creator to Zoho CRM and create new records and edit records that have been added to Creator. I can also push data from Zoho CRM to Creator using webhooks to create a new record when a lead is added to the CRM. However, I can't get edits in the Zoho CRM to update records in Creator. I think the issue is in the webhook that calls the function. I don't know how to add the required criteria to the webhook.
Getting Data from two fields into a multi-line field
Hi, I am trying to combine 2 fields into 1 field automatically when the two fields are updated. Basically I have a "Start_Time" field and a "Start_Date" field that I need to combine into a "Start_Time_Date" field that will have both displayed in the one field. How can I pull the information automatically into the multi-line field with a soft return between the two fields. Any help would be appreciated. Thanks! Trish
Working with a table inside of a note field
I'm developing a inventory system for service tech's. As a tech places a manual order each part is displayed in a note field as they click on "add". With different part names it becomes messy very quickly. I've inserted a table inside of the note field. How do I place the ordered data inside of the table in a note field?
Huge problems using webhooks on Accounts
I created a Workflow rule to execute on CREATE using a webhook and followed the instructions https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html and had new account details copied over to my Zoho Creator app. I then disabled the CREATE workflow rule and created a new rule to execute on CREATE or EDIT and setup the webhook in the same way. This resulted in a new account being entered in the Zoho Creator app whenever a CRM record is changed. Initially I thought that EDIT would
Extra charters appear in note field
I'm using a note field to display a list of parts ordered. When the from loads for the first time and no parts are in the Form to display it is good. Once a part is added to the Temp_Order Form I get this. _________________ Parts Currently Ordered _________________ null12v 12amp hr Battery 100088470 1 /> "null" appears at the beginning of the line and a close tag "/>" appears at the end. I've cleared the input.Pending_Order_Note = ""; before anything is written to it and removed the ending tag "<br>/>"
Numeric field format
Hello, how can I format numeric field to look like 123.123,56 (dot as thousand separator and comma as decimal separator)? Also, I would like that numeric filed value has right alignment. Thanks in advance
Custom Action Configuration
I have been configuring my Custom Actions so that they appear in the Show Action in Edit Drop-down Menu I decided to try the Custom Action so that they appear in the Show Action in Report Header (execute for each record) The menu of Custom Action now appears, but the action is not ... activated. Any ideas on what to look at to figure out why?
Summary View via iphone
Is it my imagination, or does the summary view not work with an iphone?
Add comma to record summary in report
Hello. I have created a record summary invoice template in a report. I would like to add a comma in the currency field. Currently shows $1200.00 would like to show $1,200.00. Thanks
checkbox tally
How do I tally the number of checked boxes in a multi-checkbox field?
Allowing users to import data through the report view.
Is there a way to enable the import option to appear for a public report view so users can upload a CSV / Excel of data?
Creator API - Update a record value
Trying to use the API to update a record in a view with a POST : https://creator.zoho.com/api/xml/student-record/view/myob_invoice_line/?scope=creatorapi&authtoken=xxxxxx&criteria=(ID == "1612333000000917031")&newvalues=field name = Job_Code value=1234 What is wrong with this request syntax? This request returns a zoho creator webpage.
Filter Embedded reports in HTML page
I have a page that has 3 reports embedded in it. When i put something like #Page:Display_job?Job_Number=8 in the URL the 3 reports continue to show all records. How can i make the embedded reports show just the Job_Number records and not show all records? If I put /#Page:Display_job?Job_Number=8 in the URL for each of the individual reports it works fine but not when they are embedded in an HTML page. Thanks
Subform View in Mobile App
The list view for all subform items in the mobile app shows just the item ID (which is a long ID number). Is there a way to display another field instead of the ID?
Add new lines to a Note<field>
I have an app that is a parts order form. I'm using a stateless form to input information. As the user selects and adds a part to their order I would like to have the items ordered appear in a note field. The action of ordering a part happens when the user "clicks" on the [Form Action] Add [on click] I've tried the below code, but nothing appears in the note field. for each r in Temp_Parts_Order [Tech_ID == User.Employee_ID] { input.Pending_Order = input.Pending_Order + r.Description + " " +
Time Lapsed since Last Record meeting criteria - script Question
I figured out the problem and found a solution: The sort by Added_Time desc; actually calls the record you are creating, so if you really want the last record before that you need to insert the criteria ID<input.ID (as shown in the corrected code below). test = input.Person; LastRecThisPerson = ThisForm [(Person = test && ID < input.ID && Added_Time == today)] sort by Added_Time desc; if (LastRecThisPerson.ID == null) { input.LapsedTimeInHours = 0.00; } if (LastRecThisPerson.ID > 100)
Adding image via iphone
I have an image field. From the iphone, in edit mode, the user can click PHOTO or CAMERA. When the user clicks PHOTO, I have the error message: this app does not have access to your photos or videos You can enable access in Privacy Settings Where are Privacy Settings????
addYear function causing problems since last weeks zoho update
I have a formula that calculates an expiry date with this statement Last_Renewal_Date.addYear(1) It has worked fine for years but last week we got the error that says "Invalid field value" for this formula field. I think it is now generating a DateTime value instead of just Date --- which is not allowing us to edit the records. I have had a request into Zoho for over a week and they are not responding in a timely manner. Is anyone else having this issue?
name an excel csv on export.
Is it possible to create a name for an excel.csv export file on export? I've created an excel spread sheet with a vlookup function. When I open excel the *.csv file has to have the same name each time for the function to work properly.
Attempting an Order Management application
Hello, I'm attempting to create an Order Management application and would appreciate any direction in helping me to think about this in the right way. This is what I'd like to do: 1) Import Order Number and related information via XLS file and automatically assign a "NEW" status to each of the records 2) Show "NEW" orders on a Home or Dashboard View with a click link to "Processing" Form that auto-fills the Order Number. The "Processing" Form would have the auto-filled Order Number field and fields
Assistance Needed With Developing an App
Hi, I'm still trying out the free version of Zoho Creator before I make the purchase and I need help with creating an app. Just a brief explanation of my business. We create and register private companies for individuals who want to start their own businesses. The process has two stages: - Name reservation - Incorporation Now these stages happen at different times (a few days apart). I want to be able to track the progress of each order from a client ie. when I enter a Job ID, I want to be able to
URL link for uploaded file is not accessible to general public
Hi Team I have a business where I upload a report for a client to my system, which then sends the report, in an email to the client. This is shown in the email as a URL link. The problem is the the client is presented with a Zoho Login page when he clicks on the link. Is there any way to remove security restrictions on uploaded file links at all so that my clients can download the report? Or simply attaching the file to the email? Thanks Jason
Help with Scripting
Hello, I am new to this type of workflow so I hope someone can help. I have a form that has 5 categories each with drop-down menus. Cat 1 has 3 variables, Cat 2 has 3 variables, Cat 3 has 26 variables, Cat 4 has 4 variables, and Cat 5 has 2 variables. Depending on what variables are selected for all 5 categories I would like a new form to open upon clicking the Submit button. Simply stated I would need to write a script for the Submit button: If cat1=variable, cat2=variable, cat3=variable, cat4=variable,
Date functions used in report criteria lost on re-edit
I have a number of reports set up using date functions such as 'Added_Time' ... Before ... today.subDay(7) to find records that are over a week old. These can be created OK, and work fine. However, when I go to edit the report criteria again, "today.subDay(7)" is always turned into just "subDay". In order to save the correct criteria, I have to retype "today.subDay(7)" into the text box before save. The same happens for other functions e.g. addDay, subMonth, etc. I've got this on a lots of reports,
Address field type
For mailing addresses, I use: 1 line for the addressee fields for city, state, country and postal code. and: 1 line (optional) for the c/o or company or to the attention of 1 line for the street or PO box My question is about the 2 lines.... I don't like how much room they take up in list view reports, and I'm wondering if I could switch to 1 multi-line field. Any opinions? Advice? Recommendations?
Accidentally deleted a form button
I accidentally deleted the wrong button on a form - and therefore the code behind it. Is there any version history available or any other way to restore it?
Can I MOVE a Form from one application to another?
Hi, I am new to Creator and I ended up creating multiple applications instead of multiple forms within an application. Can I move forms or copy forms between applications? Thanks
fetching records with multiple search criteria
I want to search my all the records in my Crew_DB for a name that I input. Then I want to input the data from a field in that record into the existing form. Can this be done? Example. crew = Crew_DB [(((((((((Crew_Member_1 == input.Employee1 || Crew_Member_2 == input.Employee1) || Crew_Member_3 == input.Employee1) || Crew_Member_4 == input.Employee1) || Crew_Member_5 == input.Employee1) || Crew_Member_6 == input.Employee1) || Crew_Member_7 == input.Employee1) || Crew_Member_8 == input.Employee1)
Send Reminder
Hello, I'm trying to trigger a function in which the program can automatically send an email to remind the user, who input some but not all of the data, that the deadline is approaching.
Archive Subform Data
Hello, I'm trying to archive data from both the parent form and its subform into another section, so that we can look back on old records. As a result, I created a function in which you can click a button on each record to archive it. However, only the fields in the parent form can be archived, NOT in the subform. Any advice? This is what I have so far: void deleteRecord(int ID) { fetch = Part_Information_Input [ID == input.ID]; insert into Archive [ Added_User = zoho.loginuser
href with View worked for me till a few days ago and suddenly stopped.
Hi - Till a few days ago this line worked well for me: htmlString = ((htmlString + "</br>" + "<a href=" + zoho.appuri + "'#view:customerRecordCompleteHtmlView?customerIDParam=" + custIDStringTemp + "' target='calendarIframe'>") + custRecTemp11.Formula2) + "</a>"; I noticed that in particularly any variations of the href-value that includes column " :" makes the url href value to be stripped when in display on the page. I think this seems to be relevant for Form's html fields .. So this is rendered
Next Page