Urgent Help with Sending Attachments on Emails
I have a form where the user can upload a file. Once the user submits the form, an email is sent to a group of people with the fields completed by the user. Is there a way to attach the uploaded file with this email? Thanks!
Remove Customer Portal
HI, As a test I created a customer Portal for one of our Creator app. Now, I like to remove the feature. Not only disabling it, but removing the full access and URL. How can I achieve this ? thanks.
Magento Website Integration
Hay, Is it possible to integrate Magento website with zoho creator through Rest API? Don't want to use third party App's. can anyone help me with any documentation ? or how do i start ? Thank you in Advance.
Dynamically Selecting and Updating Multiple Records
Hi All- I have a form ("Equipment Form") that contains multiple pieces of equipment of multiple equipment types from multiple locations. One field in this current form is a "Runtime Meter". I would like to provide a user the ability to select a location and equipment type (lookups), fetch and display the applicable current "Runtime Meter" and allow for that field and a "Meter Reading Date" field to be updated with a new meter reading. Essentially, the user will dynamically select, view current
Pivot Chart not Showing Form Fields
I have Table Called Material Used. There is Date_Created Field Which is not able available While Creating Pivot Chart Report. I need to created Weekly Material used report But this Field is not Available in Column Section
Lay Out Builder for Detail View
Hi, I see Zoho Creator currently has a "Lay out builder for print/mail" (Record Templates) and there is a coming release for the "Lay Out Builder for Quick View" (Announced on Zoholics Nov-2019). It would be great to have "Lay Out Builder for Detail View". Is that a planned feature? Thanks.
Send Multiple Records in Record Template Format as email attachment
Hi - I know it is possible to send a single record in Record Template format as an email attachment on success, such as an invoice attached to an order confirmation email. Is is possible to create a custom function or scheduled email to include multiple records in a form as an email attachment in the Record Template format? Currently, we can do this manually by printing the displayed records in a report as "Print as Summary" However, it would be very helpful to automate this process so that multiple
Multi Line carriage return in html view
Hi folks. I have a couple multi-line fields in my form. As they are used, carriage returns / line feeds are added with the enter key. In the list view, these carriage returns show up fine. But when I pull the data into an HTML view with a "fetch", the carriage return is not displayed - the text all runs together. Am I doing something wrong, or do I need to do something differently? Or does it just not work? I appreciate any tips... Thanks.
when was the custom domain feature changed ?
the feature was changed from premium to ultimate subscription???, we needed to change our payment method and resubscribed the next day and suddenly that feature is unavailable, we had all these past years the "premium "subscription and we were able to use custom domains, so what happened?
summary view of information from several forms
I am new to ZC, and maybe still not thinking in ZohoStyle. However, one main power of RDBMS is that data does NOT need to be stored in several places. As I see it, if I want to have data from 2 forms in 1 view, I need to add a lookup field, this distorts a little the logic of dividing the data. However, I will ask a question, and hopefully, it's possible: Each of us has many tables/forms, some of the objects are more core objects (person, ID...), while other are data decsribing - name, address,
Button in subform to refresh deluge script for updated response
Hi, I have an expenses form I've built that pulls live currency rates into it for each item in a subform (so items could all be in different currencies) and then makes a running total in our base currency USD (so GBP and EUR are all converted by Deluge into a USD total). Is there a way I can add a button "UPDATE" that runs the script again to refresh the values? I notice it always has to be on user input but sometimes I just want the user to be able to update each line in the subform via running
Stateless Form - Attempting to pass a record ID to a stateless form for fetch and populate fileds
ZC v5 I am using an open URL command (see below) url = "#Form:Finance?lID=" + input.ID; openUrl(url,"same window"); to try to pass a parameter to a STATELESS FORM. This is the URL that is generated when the stateless form is displayed https://app.zohocreator.com/<zohaccount>/<Zohoapp>/#Form:Finance?ID=3949349000000407063 But the parameter is not being passed through to the stateless form as al alert message shows the value of input.ID as null. The same code works if I change the stateless form to
Amount to Words or Numbers to Words Converter
When can we have the feature to automatically convert figures of currency to words. We have an application that generates bills, printed as invoice, and customers would like to see the Final Invoice Total amount automatically written in words eg: we'd like a feature that could translate USD 6073.66 as SIX THOUSAND AND SEVENTY THREE dollars and SIXTY SIX cents. I understand there are some numbers to words converter websites, Can anyone advise if any of these numbers to words website offer Callable
amyway to retrieve my work lost by the Sandbox feature in zoho curator
errror publishing keeps poping up. I filed a support ticket with no response in 12 hours. every time i press the Publish button I got a "errror publishing". These were minor changes. Support says 10 hour response but not every day I guess. This is a rather useless feature if I have to wait days or weeks to interrupt my workflow. Does everyone rely on the back up and restore feature instead or is that just as unreliable? ty
How can I allow users to upload more than 1 file at a time?
How can I allow end-user to upload more than one file if given quantity is more than one? For example: I've created a form where user can put quantity and I want them to allow as many file uploads a quantity amount. Right now, if the quantity is more than 1, it still only allows only one upload. Thank You
Add Business Days BUT excluding holidays and sundays only like workdays
Hi! Please, your help with the following: Please, use the example bellow to understand my idea: Initial_Date: '20-12-2019'; "Add" 32 "business days" to "Initial_Date", but with the following criterias: - 1st: Considering like workdays from Monday to Saturday. - 2nd: Considering the following Holiday list: Holidays = {'25-12-2019', '01-01-2020'; '15-02-2020'}; My problem is that the function "addBusinessDays()" do not permit both to exclude holidays like other functions (i.e. workdays) but to
Password Field in Zoho Creator
I need to know that whether a password field can be created in the Zoho Creator. Is their way to create a password field using Deluge Script.
Feedback Analysis by rating field in Zoho Creator
Namaskaram Zoho Creator team, Good if form builder contains a field for Rating with stars in Zoho creator form creation, to find customer satisfaction level - it is useful for feedback analysis specifically in products sales Now, form builder contains a field called sentiment analysis to analyze entered customer feedback from a single-line field. But the rating stars are often used in web forms and apps for feedback analysis. So people are familiar with using this one instead of using AI for
Functionality Issue in Zoho Creator - While opening the Deluge Script Editor
Namaskaram Zoho Creator team, Refer below image. Whenever opening the script editor from workflow editor [ref:Image 1], It should open the script editor page [ref:Image 2], Instead of that, it shows the 'Add New Action' page[ref:Image 3],. if we tried to close it by tap on the cross symbol 'X', It shows an dialog box with two options as 'Close' And 'Cancel' [ref:Image 4],. If we choose 'Close', it's not performing any action. while selecting 'Cancel' the dialogue box closes. To go back, we
UI Issue in Zoho Creator - 'Refer Fields' side bar is hiding the code content in HTML Snippet - Zoho Creator
Namaskaram Zoho Creator team, While using the refer fields side bar in HTML Snippet editor in Pages. It hides the code content. Image 1 shows the HTML snippet editor before using Refer Fields and Image 2 shows that the code contents are hidden while using Refer Fields.Also it is not showing any scroll bar below the HTML Snippet editor to view the hidden code content. Image 1: Image 2: Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho
UI Issue in Zoho Creator - While using conditional formatting tool tip should not be shown there
Namaskaram Zoho Creator team, In field configuration settings it shows 'i' icon (Refer Image 1) near the fields and while using conditional formatting for any field it shows a list of created rule and in that the 'i' icon is also visible which is in behind the conditional formatting setting (Refer Image 2) also it shows tool tip when we hover the 'i' icon which is in the conditional formatting setting (Refer Image 3) Image 1: Image 2: Image 3: Crafted with
Functionality Issue : Filtered keywords not containing space are not shown above Reports while using Open URL
Namaskaram Zoho Creator Team, While using filter in open URL to open a report the filter is applied properly. But its not showing the filtered key words above report when the key word used in filter has no space after are between the keyword.(For example: when we use current_status= 'Draft' as filter then the report shows list of entries having Draft as current_status but the applied keyword was not shown above the report.If we use current_status='Draft ' (Here
Customers - Timesheet - Calender
* Sorry moved this to the Zoho Creator Forum Hi, I'm trying to make an app where a user can see an appointment schedule (the user has a customer permission) for his workweek or month. The customer can only see his schedule. So far so good. But i want to make a timesheet where the user can add the real time spended during that appointment. Forms/Reports that i made are: - Customer - Employee (in this form i have a User field with customer permissions) - Appointments (in this form i have a lookup
ignore duplicates in for each
Hi, I am using the following programme to return values (Bin Numbers) and dates that have been used in the report. a = Collections[Bin_Number != "" && Site_Name.Customer_No == "WXH" && Date_Time > zoho.currentdate.subMonth(1)]; b = Master_Bin_List[Bin_Number not in a.Bin_Number.getall() && Site_Name.Customer_No == "WXH" && Ignore_in_count1 != "yes"].Bin_Number.getAll(); c = Collections[Bin_Number in b] sort by Date_Time desc; d = Master_Bin_List[Bin_Number not in c.Bin_Number.getall() && Bin_Number
Sending file via PostURL
I want to postURL data that includes a file that has been uploaded to a record. I created a simple function which should do it but I get a server error from the receiving web service. Probably because Zoho Creator automatically uses a Content-Type of application/x-www-form-urlencoded when what I really need to send is probably a different content-type (multipart/form-data?) to the url. Any ideas on how I can post a file using postURL?
Planning material with stock
Hi all, I'm trying some things with the conference room booking system, to build a crew and materials planning application. So what I did was changing the conference room page to a materials page. I love the way that it checks the availability. What I want to add is the following: 1. So lets' say I want to add a camera. I have 5 of these, so I want to add a number field in which I input 5. 2. Now when I make a booking I want the option to say I need 2 for that date/time. 3. Great! Now I have 2
Close Browser Tab
I am opening and editing a record via a link in an HTML page. I would like to close this window once the record has been submitted and return to the HTML page. I have tried a couple of options but have not found one that works. I am not opening the new window via openURL(), rather the <a> tag in HTML. Thanks for any suggestions.
Logic-based form calculations - Conditional Formula for Zoho Creator
Hi, I see Zoho just introduced a Conditional Formula for Zoho Forms. It would be great to implement the same feature on Zoho Creator Formula Fields. Here the details of the this new feature introduced in Zoho Forms: https://help.zoho.com/portal/en/community/topic/logic-based-form-calculations-introducing-conditional-formula-for-zoho-forms
Ability to define the appearance (currency, decimal, etc.) on Formula Field
The Formula Field does not allow the user to define the appearance/format option, it would be great to add it so that the user can define the appearance for this field same as currently supported in Number/Decimal/Currency fields: Post discussing this topic: https://help.zoho.com/portal/en/community/topic/how-to-display-formula-result-as-currency
How to update a form with data from a crm look up field in another form in the same application so that it shows as a text value rather than the ID number?
Hi there, I need to create update a form called "US Customers" with data from a form called "Customer Cancellation Form". This works fine using the Data Access/Add Record /"insert into... procedure . The only problem is that one field I need called "Organisation name" is a look up field to zoho crm . This field in the new form displays the Organisation ID not the name of the organisation insert into US_Customer [ Organisation_Name=input.Organisation_Name Contact=input.Contact Email=input.Email
In-App Notification Counter on Menu
See attached screenshot. Would be really nice to have a "counter", especially on the "Approvals" workflow tab.
Barcode Scanning
Hello, I would like to integrate hardware barcode scanner with Zoho creator, how do i do it?
Using addbusinessday formula with holidays and weekdays
Please, your help with the following situation. I want to use the formula addbusinessdays() but I cannot enter both holidays but specific workdays ranges. In my case I need to add some business days to a start date but considering workdays from Monday to Saturday and a short list of holidays... Please your help! Some formula example?
Enter value for input arguments
What does this mean? "Please enter the value for the input arguments." Room and Bed Registration is the name of the form I am trying to run this schedule on. I don't know what it is looking for. Thanks so much to all you who understand these things
Workflows with translated dropdown fields on mobile
Hi, I tried translating the values of a dropdown field to sapanish and found that my existing triggers related to the options chosen on that field still work while using the web but fail when using the mobile version. Is it a known error? Thanks!
Cancel subform delete
I have a form with a table of subform rows. I need to allow users to delete rows but not all rows. The capability to delete a row needs to be determined by a value in the subform record. I understand that I cannot conditionally enable/disable the delete function but was wondering if there was another way to achieve what I want. The onValidate function of a form provides the ability to 'cancel submit'. A 'cancel delete' function in onDeleteRow could give me what I need but alas it doesn't exist. onDeleteRow()
Menu - Sync Across Platforms
Hi, I've just noticed that my menu's are different across the different platforms. Is there a way to sync them all to my laptop view? Thanks
Data Limitation
What is the real limitations of size data and columns of a table in Creator? How many rows of data can it handle in a real production environment? At what point the performance of an app starts suffering because of size of table or total data size of an application?
Amount in words
Hi, Is it possible to get Currency in Words ? for e.g Total Amount is Rs 100 In Words: One Hundred Only.
Is there a way to send Uploaded Files from one application to another using postUrl?
I need to send a file from an application on one account to an app on another account, possibly using postUrl(). I'm currently getting an error when attempting this. Is there a way to resolve this?
Next Page